Description

Location: Mumbai 

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 be playing 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 India and may require on-site work from time to time.

Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

Purpose and Scope:

As a Data and Analytics Tester, you will play a critical role in validating the accuracy, functionality, and performance of our BI, Data Warehousing and ETL systems. You’ll work closely with FoundationX Data Engineers, analysts, and developers to ensure that our QLIK, Power BI, and Tableau reports meet high standards. Additionally, your expertise in ETL tools (such as Talend, DataBricks) will be essential for testing data pipelines.

Essential Job Responsibilities:

Development Ownership:

• Support testing for Data Warehouse and MI projects.
• Collaborate with senior team members.
• Administer multi-server environments.

Test Strategy and Planning:

• Understand project requirements and data pipelines.
• Create comprehensive test strategies and plans.
• Participate in data validation and user acceptance testing (UAT).

Data Validation and Quality Assurance:

• Execute manual and automated tests on data pipelines, ETL processes, and models.
• Verify data accuracy, completeness, and consistency.
• Ensure compliance with industry standards.

Regression Testing:

• Validate changes to data pipelines and analytics tools.
• Monitor performance metrics.

Test Case Design and Execution:

• Create detailed test cases based on requirements.
• Collaborate with development teams to resolve issues.
• Maintain documentation.

Data Security and Privacy:

• Validate access controls and encryption mechanisms.
• Ensure compliance with privacy regulations.

Collaboration and Communication:

• Work with cross-functional teams.
• Communicate test progress and results.

Continuous Improvement and Technical Support:

• Optimize data platform architecture.
• Provide technical support to internal users.
• Stay updated on trends in full-stack development and cloud platforms.
• Requirements

Qualifications:

Required

• Bachelor’s degree in computer science, information technology, or related field (or equivalent experience.)
• 1-3 + years proven experience as a Tester, Developer or Data Analyst within a Pharmaceutical or working within a similar regulatory environment.
• 1- 3 + years' experience in using BI Development, ETL Development, Qlik, PowerBI including DAX and Power Automate (MS Flow) or PowerBI alerts or equivalent technologies.
• Experience with QLIK Sense and QLIKView, Tableau application and creating data models.
• Familiarity with Business Intelligence and Data Warehousing concepts (star schema, snowflake schema, data marts).
• Knowledge of SQL, ETL frameworks and data integration techniques.
• Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical.
• Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools.
• Exposure to at least 1-2 full large complex project life cycles.
• Experience with test management software (e.g., qTest, Zephyr, ALM).
• Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
• Manual testing (test case design, execution, defect reporting).
• Awareness of automated testing tools (e.g., Selenium, JUnit).
• Experience with data warehouses and understanding of BI/DWH systems.
• Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

Preferred: -

• Experience working in the Pharma industry. Understanding of pharmaceutical data (clinical trials, drug development, patient records) is advantageous.
• Certifications in BI tools or testing methodologies.
• Knowledge of cloud-based BI solutions (e.g., Azure, AWS)
• Cross-Cultural Experience:  Work experience across multiple cultures and regions, facilitating effective collaboration in diverse environments
• Innovation and Creativity: Ability to think innovatively and propose creative solutions to complex technical challenges
• Global Perspective: Demonstrated understanding of global pharmaceutical or healthcare technical delivery, providing exceptional customer service and enabling strategic insights and decision-making.