Data Engineer - Analyst

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, Saa S 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, Big Query, 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, Big Query, 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 Cloud Watch, Azure Monitor, GCP Monitoring, or Datadog 
Exposure to CI/CD practices and Git-based version control for managing data pipelines