Data Engineer at Takeda in Bengaluru, Karnataka, India

Data Engineer Location: IND - Bengaluru 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 Qualifications: 5–6 years of professional experience in data engineering, analytics engineering, or business intelligence roles, with hands‑on ownership of SQL modeling and Power BI–based analytics solutions. BENEFITS: It is our priority to provide competitive compensation and a benefit package that bridges your personal life with your professional career. Amongst our benefits are: Competitive Salary + Performance Annual Bonus Flexible work environment, including hybrid working Comprehensive Healthcare Insurance Plans for self, spouse, and children Group Term Life Insurance and Group Accident Insurance programs Employee Assistance Program Broad Variety of learning platforms Diversity, Equity, and Inclusion Programs Reimbursements – Home Internet & Mobile Phone Employee Referral Program Leaves – Paternity Leave (4 Weeks) , Maternity Leave (up to 26 weeks), Bereavement Leave (5 calendar days) ABOUT ICC IN TAKEDA: Takeda is leading a digital revolution. We’re not just transforming our company; we’re improving the lives of millions of patients who rely on our medicines every day. As an organization, we are committed to our cloud-driven business transformation and believe the ICCs are the catalysts of change for our global organization. Locations IND - Bengaluru Worker Type Employee Worker Sub-Type Regular Time Type Full time