Data and Analytics Tester SQL, Python, Pyspark

Building your career at Astellas continues to offer inspiring challenges and a chance to make your mark in doing good for others. Our open and progressive culture is what makes us Astellas. It is a culture of doing good for others and contributing to a sustainable society.

About This Job

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.

Were looking for skilled Testers specializing in SQL, Python, and PySpark to join our FoundationX team. As part of this team, your role will involve maintaining operational, scalable data-driven systems that deliver business value.

Purpose And Scope

As a Tester, you will play a crucial role in ensuring the quality and reliability of our pharmaceutical data systems. Your expertise in testing methodologies, data validation, and automation will be essential in maintaining high standards for our data solutions.

Essential Skills & Knowledge
 SQL ProficiencyStrong skills in SQL for data querying, validation, and analysis.
 Experience with complex joins, subqueries, and performance optimization.
 Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).

Python And PySpark
 Proficiency in Python for test automation and data manipulation.
 Familiarity with PySpark for big data testing.

Testing Methodologies
 Knowledge of testing frameworks (e.g., pytest, unittest).
 Experience with test case design, execution, and defect management.

Data Validation
 Ability to validate data transformations, aggregations, and business rules.
 Understanding of data lineage and impact analysis.

Business Intelligence Tools
 Proficiency in designing and maintaining QLIK/Tableau applications.
 Strong expertise in creating interactive reports and dashboards using Power BI.
 Knowledge of DAX and Power Automate (MS Flow).

Data Modelling And Integration
 Ability to design and implement logical and physical data models.
 Familiarity with data warehousing concepts and ETL processes.

Data Governance And Quality
 Understanding of data governance principles and metadata management.
 Experience ensuring data quality and consistency.

Testing Techniques
 Familiarity with SQL, Python, or R for data validation and testing.
 Manual and automated testing (e.g., Selenium, JUnit).
 Test Management Tools: Experience with test management software (e.g., qTest, Zephyr, ALM).

Data Analysis
 Knowledge of statistical analysis and data visualization tools (e.g., Tableau, Power BI).

Pharmaceutical Domain
 Understanding of pharmaceutical data (clinical trials, drug development, patient records).
 Attention to Detail: Meticulous review of requirements and data quality.

Collaboration And Communication
 Ability to work with end users and technical team members. Self-starter who collaborates effectively.
 Experience and Agile Mindset: Experience with data warehouses, BI, and DWH systems.
 Analytical thinking and adherence to DevOps principles.

Preferred Skills And Knowledge
 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. Global Perspective: Demonstrated understanding of global pharmaceutical or healthcare technical delivery, providing exceptional customer service and enabling strategic insights and decision-making.

Responsibilities: Development Ownership:
 Take ownership of testing key development projects related to the Data Warehouse and other MI systems.
 Collaborate with senior team members in a multi-skilled project team.
 Contribute to efficient administration of multi-server environments.
 Test Strategy and Planning:
 Collaborate with stakeholders, data scientists, analysts, and developers to understand project requirements and data pipelines.
 Develop comprehensive end-to-end test strategies and plans for data validation, transformation, and analytics.
 Data Validation and Quality Assurance:
 Execute manual and automated tests on data pipelines, ETL processes, and analytical models.
 Verify data accuracy, completeness, and consistency.
 Identify anomalies and data quality issues.
 Ensure compliance with industry standards (e.g., GxP, HIPAA).
 Regression Testing:
 Validate changes and enhancements to data pipelines and analytics tools.
 Verify data accuracy, consistency, and completeness in QLIK, Power BI, and Tableau reports.
 Monitor performance metrics and identify deviations.
 Test Case Design and Execution:
 Create detailed test cases based on business requirements and technical specifications.
 Execute test cases, record results, and report defects.
 Collaborate with development teams to resolve issues promptly.
 Documentation: Maintain comprehensive documentation of test scenarios, test data, and results.
 Document test procedures and best practices.
 Data Security and Privacy:
 Ensure data security and compliance with privacy regulations (e.g., GDPR).
 Validate access controls and encryption mechanisms.
 Collaboration and Communication:
 Work closely with cross-functional teams, including data engineers, data scientists, and business stakeholders

Experience
 3 years+ of experience as a Tester, Developer or Data Analyst within a Pharmaceutical or working within a similar regulatory environment.
 Analytical mindset and logical thinking.
 Familiarity with Business Intelligence and Data Warehousing concepts.
 Web integration skills (Qlik Sense).
 Advanced SQL knowledge.
 Understanding of stored procedures, triggers, and tuning.
 Experience with other BI tools (Tableau, D3.js) is a plus.

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

Qualifications
 Global Perspective: Demonstrated understanding of global pharmaceutical or healthcare technical delivery, providing exceptional customer service, and enabling strategic insights and decision-making Other complex and highly regulated industry experience will be considered
 Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling 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, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.

Working Environment
 Permanent position.
 Remote/ Hybrid: candidates must be located within commutable distance from the office.
 Astellas is a global company. Successful candidates will be expected to work across different time zones and according to regions or specific locations based upon demand.
 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.

Category FoundationX

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

EOE including Disability/Protected Veterans,