Job Description

Job Title: Data Engineer - Analyst

Experience: 2.5 to 5 Years

Location: PAN India (Remote/On-site as applicable)

Role Overview:

We are seeking skilled Data Engineer - Analyst to design, develop, and manage robust data pipelines and analytics-ready datasets. In this role, you will enable data-driven decision-making by supporting BI reporting, product analytics, and business insights. You will collaborate with multiple teams, work with diverse data sources, and ensure high data quality across the entire data lifecycle.

Key Responsibilities:

Develop and manage scalable ETL/ELT pipelines (both batch and incremental) using SQL and Python
Ingest and integrate data from multiple sources including databases, APIs, SaaS platforms, event streams, and flat files
Design and implement analytics-ready data models (such as star schema and data marts) for reporting and analysis
Build and optimize data transformations within cloud-based warehouses/lakehouses (Snowflake, BigQuery, Redshift, Synapse, Databricks)
Collaborate with stakeholders to define KPIs, metrics, and reporting requirements
Develop, maintain, and enhance dashboards and reports using BI tools like Power BI, Tableau, Looker, or Sigma
Ensure data reliability by implementing validation checks, monitoring systems, alerting mechanisms, and proper documentation
Optimize data performance and cost efficiency through techniques like incremental loading, partitioning, query tuning, and efficient file formats

Required Skills:

Strong proficiency in SQL (including CTEs, window functions, joins, aggregations, and performance tuning)
Strong programming skills in Python for data processing and automation
Hands-on experience with at least one cloud platform: AWS, Azure, or GCP
Practical experience with modern data warehouses/lakehouses such as Snowflake, BigQuery, Redshift, Synapse, or Databricks
Solid understanding of ETL/ELT concepts, including incremental processing, retries, idempotency, and basic CDC (Change Data Capture)
Good understanding of data modeling principles for analytics and BI use cases
Experience building user-friendly reports and dashboards using BI tools (Power BI, Tableau, Looker, or Sigma)

Good to have:

Experience with orchestration tools like Airflow, dbt, Dagster, Prefect, Azure Data Factory (ADF), or AWS Glue
Familiarity with streaming/event-driven data platforms such as Kafka, Kinesis, or Pub/Sub
Knowledge of monitoring and logging tools like CloudWatch, Azure Monitor, GCP Monitoring, or Datadog
Exposure to CI/CD practices and Git-based version control for managing data pipelines