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 efficient 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 effective 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

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