Data Engineer with Power BI

Infosys; Pune District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Infosys, located in Pune District, is seeking an experienced Data Engineer with a strong background in SQL and data transformation. The ideal candidate will design and develop high-performance ELT pipelines using dbt, ensuring data quality and consistency.

Experience with AWS services such as Athena, S3, and Lambda is required, along with knowledge of Power BI and data modeling. This role emphasizes collaborative work with Product Owners to deliver analytics-ready data products.

Qualifications

• 5+ years of experience as a Data Engineer with strong SQL skills.
• Hands-on experience building ELT pipelines using dbt.
• Expertise in AWS data services like Athena, S3, and Lambda.

Responsibilities

• Design and develop robust data transformation pipelines.
• Implement effective data quality, consistency, and reliability checks.
• Monitor and optimize data pipeline performance.

Skills

SQL

Data transformation frameworks

dbt

AWS Data Services (Athena, S3, Lambda)

Power BI

Data Modeling

DAX

Education

Bachelor of Engineering, BBA, BCom

Tools

dbt

AWS

Power BI

Job description

Educational Requirements

Bachelor of Engineering, BBA, BCom

Service Line

Data Analytics Unit

Responsibilities

• Experienced Data Engineer (68 years) with strong expertise in SQL and data transformation frameworks, including hands‑on experience in dbt for building scalable, modular, and maintainable ELT pipelines. Proven ability to design and develop robust data transformation pipelines across raw to curated (gold) layers, ensuring data quality, consistency, and reliability. Hands‑on experience with AWS data services (Athena, S3, Lambda) to build and manage scalable data workflows, along with a solid understanding of data modeling concepts to support downstream analytics use cases. Expected to have working knowledge of Power BI, specifically in semantic modeling (data models, DAX, dataset design) to enable effective consumption of curated data. This role is not reporting‑focused. Strong focus on building automated, secure, and high‑performance pipelines with effective data validation practices. Experience in monitoring, troubleshooting, and optimizing data pipeline performance within Agile delivery environments, along with exposure to CI/CD practices for deploying data transformation workflows. Collaborative team player with strong analytical and problem‑solving skills, capable of working closely with Product Owners and Tech Leads to deliver high‑quality, analytics‑ready data products aligned with business objectives.

Technical and Professional Requirements

• Data Engineer


• Power BI


• Data Modeling


• DAX

Preferred Skills

• Technology -> Cloud Platform -> Power Platform -> Power BI


• Technology -> Data Engineering -> Databricks