Global Pharma Data Analyst & Data Product Developer (pharma, data modelling)

Description

Global Data Analyst & Data Product Developer (pharma, lakehouse, data modelling)
About Astellas

Astellas is a global life sciences company committed to turning innovative science into VALUE for patients. We provide transformative therapies in disease areas that include oncology, ophthalmology, urology, immunology and women's health. Through our research and development programs, we are pioneering new healthcare solutions for diseases with high unmet medical need. Learn more at Astellas.com .

Are you driven to make a real difference in the lives of patients?

We're seeking passionate individuals who thrive in dynamic environments, embrace new ideas, and aren't afraid to take intelligent risks. People who act with unwavering integrity and are deeply committed to making a tangible impact.

Astellas’ Global Capability Centres – Overview

Astellas’ Global Capability Centres (GCCs) are strategically located sites that give Astellas the ability to access talent across various functions in the value chain and to co-locate core capabilities that are currently dispersed. Our three GCCs are located in India, Poland and Mexico.

The GCCs will enhance our operational efficiency, resilience and innovation potential, enabling a timely response to changing business demands.

Our GCCs are an integral part of Astellas, guided by our shared values and behaviours, and are critical enablers of the company’s strategic priorities, sustainable growth, and commitment to turn innovative science into VALUE for patients.

Location and Working Environment

This is a permanent role based in our Global Capability Centre in Warsaw, Poland and hybrid working with the expectation for some office presence. Flexibility may be required in line with business needs. Candidates must be located within a commutable distance of the office

At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

Purpose & Scope

The Global Pharma Data Analyst & Data Product Developer

• Transforms complex raw data into clear, actionable insights across the Product Development & Manufacturing (PDM) landscape.
• Builds and optimizes a high‑performing Databricks Lakehouse that serves as the single source of truth for CMC, Manufacturing, and Supply Chain teams.
• Enables data‑driven decisions that accelerate the delivery of life‑changing therapies by turning business needs into robust data models, AI‑ready datasets, and intuitive dashboards.
  
  

Role And Responsibilities

• Data Modelling & Architecture: Design, develop, and maintain robust data models within the Databricks Lakehouse (Gold layer).
• Business Rules Development: Design, develop, and maintain robust business rules within the Databricks Lakehouse (Silver layer).
• Data Product Development: Build and deploy end-to-end data products, including high-performance Power BI dashboards, automated reports, and curated datasets optimized for AI/ML consumption.
• Business Translation : Facilitate workshops with stakeholders in CMC, Manufacturing, and Supply Chain (Commercial and Clinical) to capture complex business logic and translate it into scalable technical requirements.
• Performance Tuning: Monitor and optimize Spark jobs and SQL queries to ensure the Lakehouse environment remains performant and cost-effective.
• Technical Support: Act as the primary technical point of contact for the PDM value chain, providing rapid troubleshooting, issue resolution, and guidance for existing data solutions.
• Documentation: Maintain comprehensive specification and verification documentation in line with internal GxP and non-GxP standards for business rules, data models and data products.
  
  

Required Qualifications

• Solid data modeling experience ideally in t he pharmaceutical and/or biotech industry.
• Experience with Data Vault 2.0 modelling and strong expertise in dimensional (star schema) modelling
• Strong understanding of the data lifecycle and experience developing business rules, data models, and data products.
• Strong understanding of Lakehouse architecture (preferably Databricks)
• Ability to understand key business processes and translate business needs into technical requirements.
• Proficiency in relevant tools and technologies, including Python, SQL, and BI platforms such as Databricks, Qlik Sense, and Power BI
• Excellent English communication and stakeholder management skills
  
  

Preferred Qualifications

• Experience with Agile and Waterfall project methodologies
• Familiarity with advanced analytics, AI/ML, or predictive modelling
• Exposure to global pharmaceutical or biotech organizations
• Knowledge of continuous improvement frameworks
  
  

What awaits you at Astellas?

• Global collaboration: Become part of a connected global business of like-minded life science leaders, all dedicated to improving patients' lives worldwide.
• Real-world patient impact: Contribute to transformative therapies that reach patients around the world, knowing your work makes a difference every day.
• Relentless Innovation: Join a company at the forefront of scientific breakthroughs, where you'll have the opportunity to shape the future of healthcare.
• A Culture of Growth: Chart your own course within a supportive environment that values your contributions, champions your development, and empowers you to pursue your passions.
  
  

Our Organizational Values and Behaviors

• Impact
• Innovation
• Integrity
• One Astellas
• Accountability
• Courage
• Sense of Urgency
• Outcome Focus