We're looking for a Senior ETL Data Engineer to design, build, and optimize scalable data pipelines that power analytics, reporting, and machine learning initiatives across the organization. You'll own the full lifecycle of data pipeline development — from ingestion to transformation to delivery — while also enabling downstream BI consumption through well-structured, reporting-ready datasets. You'll mentor junior engineers and drive best practices in data engineering.

Key Responsibilities
Design, develop, and maintain robust, scalable ETL/ELT pipelines to ingest data from diverse sources (databases, APIs, flat files, streaming sources)
Build and optimize data models (star/snowflake schemas) for data warehouses and data lakes, structured for effective BI consumption
Own end-to-end pipeline orchestration, monitoring, and error handling to ensure high reliability and data quality
Optimize SQL queries and pipeline performance for large-scale datasets
Partner with BI developers and business stakeholders to design semantic layers and datasets that support Power BI dashboards and reports




Build and maintain Power BI data models (star schema), DAX measures, and dataset refresh pipelines, ensuring alignment with underlying ETL structures
Optimize Power BI datasets and queries for performance, including incremental refresh strategies and efficient data source connections (Import vs. DirectQuery)
Implement data quality checks, validation frameworks, and observability/monitoring for pipelines
Manage and evolve CI/CD practices for data pipeline (and where applicable, Power BI deployment pipeline) releases
Ensure data governance, security, and row-level security (RLS) standards are met across pipelines and Power BI reports
Mentor junior data engineers and contribute to engineering best practices and documentation
Troubleshoot and resolve production pipeline and reporting issues, ensuring minimal downtime

Required Skills & Qualifications
·
5–8 years of hands-on experience in data

📌 Senior ETL Data Engineer (India)
🏢 Kavi Software Technologies Private
📍 India