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