Data and Analytics Tester

**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.

**Qualifications**:
**Required**

Bachelor’s degree in computer science, information technology, or related field (or equivalent experience.)

3 -5+ years proven experience as a Tester, Developer or Data Analyst within a Pharmaceutical or working within a similar regulatory environment.

3-5+ years experience in using BI Development, ETL Development, Qlik, PowerBI including DAX and Power Automate (MS Flow) or PowerBI alerts or equivalent technologies.

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.

Category FoundationX

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

EOE including Disability/Protected Veterans