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, 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