BI & Data Warehouse Data Engineer

Astellas Pharma; Bengaluru; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

Astellas Pharma is looking for a Junior Data Engineer to join the FoundationX team in Bangalore, India. The role focuses on the design, build, and maintenance of data infrastructure, utilizing technologies like Databricks, PySpark, and SQL.

Join Astellas to contribute to digital transformation initiatives, ensuring systems are scalable and operational, while promoting data-driven decision-making across the organization.

Qualifications

• Bachelor’s degree in computer science or related field required.
• 3–5+ years of experience in data engineering and BI technologies.
• Experience utilizing cloud platforms (AWS, Azure, GCP).

Responsibilities

• Collaborate to design and maintain scalable data systems.
• Build and maintain robust data infrastructure.
• Ensure system reliability by incorporating accurate data.

Skills

Data pipeline development

Business intelligence (BI)

SQL

PySpark

Databricks

Cloud platforms (AWS, Azure)

Education

Bachelor’s degree in computer science or IT

Tools

Databricks

PowerBI

Qlik

Job description

As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives.

DigitalX, our new information technology function, is spearheading this value‑driven transformation across Astellas. We are looking for people who excel in embracing change, manage technical challenges, and have exceptional communication skills. We are seeking committed and talented MDM Engineers to join our new FoundationX team, which lies at the heart of DigitalX. As a member within FoundationX, you will play a critical role in ensuring our MDM systems are operational, scalable and continue to contain the right data to drive business value. You will play a pivotal role in building, maintaining and enhancing our MDM systems.

This position is based in Bangalore, India. We recognize the importance of work/life balance and believe in optimizing the most productive work environment for all employees to succeed and deliver.

Purpose And Scope

As a Junior Data Engineer, you will play a crucial role in assisting in the design, build, and maintenance of our data infrastructure focusing on BI and DWH capabilities. Working with the Senior Data Engineer, your foundational expertise in BI, Databricks, PySpark, SQL, Talend and other related technologies will be instrumental in driving data‑driven decision‑making across the organization. You will contribute to building, maintaining and enhancing our systems across the organization. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilize your development skills, and contribute to the continuous improvement and delivery of critical IT solutions.

Essential Job Responsibilities

• Collaborate with FoundationX Engineers to design and maintain scalable data systems.
• Assist in building robust infrastructure using technologies such as PowerBI, Qlik, Databricks, PySpark, and SQL.
• Contribute to ensuring system reliability by incorporating accurate business‑driving data.
• Gain experience in BI engineering through hands‑on projects.

Data Modelling And Integration

• Collaborate with cross‑functional teams to analyze requirements and create technical designs, data models, and migration strategies.
• Design, build, and maintain physical databases, dimensional data models, and ETL processes specific to pharmaceutical data.

Cloud Expertise

• Evaluate and influence the selection of cloud‑based technologies such as Azure, AWS, or Google Cloud.
• Implement data warehousing solutions in a cloud environment, ensuring scalability and security.

BI Expertise

• Leverage and create PowerBI, Qlik or equivalent technology for data visualization, dashboards, and self‑service analytics.

Data Pipeline Development

• Design, build, and optimize data pipelines using Databricks and PySpark. Ensure data quality, reliability, and scalability.
• Support the migration of internal applications to Databricks (or equivalent) based solutions.
• Collaborate with application teams to ensure a seamless transition.
• Mentor and lead junior data engineers; share best practices and provide technical guidance.
• Contribute to the organization’s data strategy by identifying opportunities for data‑driven insights and improvements.
• Participate in smaller focused mission teams to deliver value‑driven solutions aligned to our global and bold move priority initiatives.
• Design, develop and implement robust and scalable data analytics using modern technologies.
• Collaborate with cross‑functional teams across the organization to translate user needs into technical solutions.
• Provide technical support to internal users by troubleshooting complex issues and ensuring system uptime as soon as possible.
• Champion continuous improvement initiatives to optimize performance, security, and maintainability of existing data and platform architecture.
• Participate in the continuous delivery pipeline, adhering to DevOps best practices for version control, automation, and deployment.
• Leverage knowledge of data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization.
• Stay up‑to‑date on the latest trends and technologies in data engineering and cloud platforms.

Qualifications

Required

• Bachelor’s degree in computer science, information technology, or related field (master’s preferred) or equivalent experience.
• 3–5+ years of experience in data engineering with a strong understanding of BI technologies, PySpark, SQL, and building data pipelines and optimization.
• 3–5+ years of experience in data engineering and integration tools (e.g., Databricks, Change Data Capture).
• 3–5+ years of experience utilizing cloud platforms (AWS, Azure, GCP). A deeper understanding or certification of AWS and Azure is considered a plus.
• Experience with relational and non‑relational databases.
• Relevant cloud‑based integration certification at foundational level or above (any QLIK or BI certification, AWS Certified DevOps Engineer, AWS Certified Developer, Microsoft Certified Azure qualification, proficiency in RESTful APIs, CDMP, MDM, DBA, SQL, SAP, TOGAF, API, CISSP, VCP or any relevant certification).
• Experience with MuleSoft (Anypoint platform, its components, designing and managing API‑led connectivity solutions).
• Experience in AWS (environment, services and tools), developing code in at least one high‑level programming language.
• Experience with continuous integration and continuous delivery (CI/CD) methodologies and tools.
• Experience with Azure services related to computing, networking, storage, and security.
• Understanding of cloud integration patterns and Azure integration services such as Logic Apps, Service Bus, and API Management.

Preferred

• Subject‑matter expertise and strong understanding of data architecture, engineering, operations, and reporting within Life Sciences/Pharma across commercial, manufacturing, and medical domains.
• Experience in other complex and highly regulated industries.
• Data analysis and automation skills: proficiency in identifying, standardizing, and automating critical reporting metrics and modeling tools.
• Analytical thinking: demonstrated ability to lead ad‑hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
• Technical proficiency: strong coding skills in SQL, R, and/or Python, with expertise in machine learning techniques, statistical analysis, and data visualization.
• Agile champion: adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

Working Environment

We recognize the importance of work/life balance and offer a hybrid working solution that allows time to connect with colleagues at the office while also providing the flexibility to work from home. Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

Category FoundationX

Astellas is committed to equality of opportunity in all aspects of employment.

EOE including Disability/Protected Veterans.