Data Engineer

By clicking the “Apply” button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takeda’s Privacy Notice and Terms of Use.  I further attest that all information I submit in my employment application is true to the best of my knowledge.

Job Description

The Future Begins Here

At Takeda, we are leading digital evolution and global transformation. By building innovative solutions and future-ready capabilities, we are meeting the need of patients, our people, and the planet.

Bengaluru, the city, which is India’s epicenter of Innovation, has been selected to be home to Takeda’s recently launched Innovation Capability Center. We invite you to join our digital transformation journey. In this role, you will have the opportunity to boost your skills and become the heart of an innovative engine that is contributing to global impact and improvement.  

At Takeda’s ICC we Unite in Diversity

Takeda is committed to creating an inclusive and collaborative workplace, where individuals are recognized for their backgrounds and abilities they bring to our company. We are continuously improving our collaborators journey in Takeda, and we welcome applications from all qualified candidates. Here, you will feel welcomed, respected, and valued as an important contributor to our diverse team

Role Summary:

The Data Engineer is a senior data professional responsible for building, modeling, and optimizing analytics‑ready data pipelines with a strong emphasis on Power BI, enterprise SQL modeling, and self‑service analytics. This role bridges data engineering and business intelligence, enabling scalable reporting, dashboards, and advanced analytics through well‑governed, high‑performance datasets.

The position partners closely with Business Analysts, Data Scientists, and Product teams to translate complex data into trusted insights that drive strategic decision‑making.

Core Responsibilities:

• Develop high‑performance SQL data models (fact/dimension tables, star/snowflake schemas) optimized for Power BI and self‑service BI
• Create and optimize Power BI–ready datasets, including semantic models, aggregated tables, and reporting layers
• Partner with business stakeholders and BI developers to define analytical requirements and translate them into scalable data solutions
• Enable Power BI dashboards, KPIs, and reports by delivering reliable, trustworthy, and well‑documented datasets
• Optimize SQL query performance, data refresh strategies, and incremental load patterns for large‑scale reporting workloads
• Implement data quality, validation, and reconciliation checks using statistical and rule‑based approaches
• Support Data Scientists by preparing curated, analysis‑ready datasets for advanced analytics and predictive modeling
• Collaborate with Solution Architects to define end‑to‑end analytics architectures, including cloud, ingestion, modeling, and visualization layers
• Mentor junior engineers and analysts on SQL best practices, data modeling, and Power BI design standards

Required Skills:

• Strong hands‑on experience with Power BI (datasets, data modeling, performance optimization, report enablement)
• Strong understanding of semantic layers, analytical models, and self‑service BI enablement
• Experience supporting enterprise reporting, dashboards, KPIs, and executive insights.
• Expert‑level SQL skills: complex joins, window functions, CTEs, subqueries, query tuning, and performance optimization
• Proven experience designing analytics‑optimized schemas (star, snowflake, dimensional modeling)
• Strong background in data mart and reporting layer design
• Advanced experience designing and maintaining scalable data pipelines in Big Data environments
• Hands‑on expertise with Spark, Hadoop ecosystem, or distributed data platforms
• Experience integrating data across multiple source systems (batch and streaming)
• Proficiency in Python for data transformation and pipeline orchestration
• Solid foundation in software engineering principles, data structures, and algorithmic optimization
• Experience with cloud data platforms and containerized deployments
• Strong understanding of CI/CD, DevOps practices, and automated data pipeline deployments

Locations

Worker Type

Worker Sub-Type

Time Type