Description

About Norstella

Norstella is a premier and critical global life sciences data and AI solutions provider dedicated to improving patient access to life-saving therapies. Norstella supports pharmaceutical and biotech companies across the full drug development lifecycle — from pipeline to patient. Our mission is simple: to help our clients bring therapies to market faster and more efficiently, ultimately impacting patient lives.

Norstella unites market-leading brands - Citeline, Evaluate, MMIT, Panalgo, Skipta and The Dedham Group and delivers must-have answers and insights, leveraging AI, for critical strategic, clinical, and commercial decision-making. We help our clients:

Accelerate the drug development cycle
Assess competition and bring the right drugs to market
Make data driven commercial and financial decisions
Match and recruit patients for clinical trials
Identify and address barriers to therapies

Norstella serves most pharmaceutical and biotech companies around the world, along with regulators like the FDA, and payers. By providing critical proprietary data supporting AI-driven workflows, Norstella helps clients make decisions faster and with greater confidence. Norstella's investments in AI are transforming how data is consumed and decisions are made, disrupting inefficient legacy workflows and helping the industry become more efficient, innovative, and responsive to patient needs.

The Role

The Senior Engineer – QA plays a critical role in ensuring the quality, reliability, and accuracy of large-scale data platforms and pipelines. This role focuses on validating cloud-based data architectures, automated data pipelines, and data warehousing solutions through robust automation, advanced SQL testing, and DevOps-enabled CI/CD practices. The ideal candidate brings strong experience in data engineering QA, AWS-based data ecosystems, and automated data quality validation frameworks.

Responsibilities

Design, develop, and maintain automated data validation and data quality test frameworks for cloud-based data platforms.
Validate end-to-end data pipelines, including ingestion, transformation, and consumption layers, ensuring data completeness, accuracy, and consistency.
Perform data modelling validation and ensure data integrity across dimensional and relational models.
Develop and execute automated tests using Python, Pytest, and PySpark or similar for large-scale data processing workflows.
Design and execute advanced SQL-based data quality tests, including complex joins, subqueries, CTEs, and reconciliation queries.
Perform scripted ETL testing to validate data completeness, transformations, and business rules across multiple data feeds.
Implement and maintain orchestrated SQL testing for scheduled data pipelines and batch workloads.
Validate and test AWS-based data services, including S3, Lambda, API Gateway, ECS, RDS, Glue, Airflow, and Redshift.
Collaborate closely with data engineers, analytics teams, DevOps, and product stakeholders to ensure quality is embedded across the data lifecycle.
Integrate automated data test suites into CI/CD pipelines using AWS / Azure DevOps tools to enable continuous data quality monitoring.
Perform root cause analysis for data issues and work with engineering teams to drive permanent fixes.
Define, track, and report data quality metrics and KPIs, driving continuous improvement initiatives.
Mentor junior QA engineers on data testing strategies, SQL best practices, and automation standards.

Requirements

Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
7+ years of experience in Quality Assurance, with strong focus on Data Automation and Data Quality Testing.
Hands-on experience with cloud data warehousing concepts and large-scale data platforms.
Strong proficiency in Python, Pytest, and PySpark or similar for data automation.
Advanced expertise in RDBMS and SQL, including complex joins, subqueries, CTEs, and performance-optimized queries.
Proven experience testing data pipelines and ETL workflows in cloud environments.
Solid hands-on experience with AWS data and compute services (ECS, Lambda, API Gateway, S3, RDS, Glue, Airflow, Redshift).
Strong understanding of data modelling concepts (fact/dimension models, normalization, denormalization).
Experience implementing and maintaining CI/CD pipelines for data testing using AWS DevOps tools.
Familiarity with Agile and DevOps methodologies.
Strong analytical, debugging, and problem-solving skills.
AWS (ECS, Lambda, API Gateway, S3, RDS
AWS (Glue, Airflow, Redshift)
Data Engineering & Testing
Cloud Data Warehousing Concepts
Data Pipelines & ETL Frameworks
Data Modelling Validation
Data Quality Testing using SQL
Scripted ETL & Data Completeness Testing
Languages & Frameworks:BPython, Pytest or similar,PySpark
Database & Querying:RDBMS (Advanced SQL: joins, subqueries, CTEs, complex queries),Snowflake,Postgres or similar
DevOps:AWS / Azure DevOps (CI/CD for data pipelines and automation)
Test Management:Testrail, Azure Devops or similar
AI tools:Claude code,Cursor, Github copilot or similar

Benefits

Health Insurance
Provident Fund
Life Insurance
Reimbursement of Certification Expenses
Gratuity
24x7 Health Desk

Our guiding principles for success at Norstella

01: Bold, Passionate, Mission-First

We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients. Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.

02: Integrity, Truth, Reality

We make promises that we can keep, and goals that push us to new heights. Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesn't. By being true to the data and producing realistic metrics, we are able to create plans and resources to achieve our goals.

03: Kindness, Empathy, Grace

We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude. We use this principle across the organization to collaborate and build lines of open communication.

04: Resilience, Mettle, Perseverance

We will persevere – even in difficult and challenging situations. Our ability to recover from missteps and failures in a positive way will help us to be successful in our mission.

05: Humility, Gratitude, Learning

We will be true learners by showing humility and gratitude in our work. We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.

Norstella is an equal opportunities employer and does not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, color, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value people's differences, to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individual's abilities, skills, performance and behavior and our business requirements. Norstella operates a zero tolerance policy to any form of discrimination, abuse or harassment.

Sometimes the best opportunities are hidden by self-doubt. We disqualify ourselves before we have the opportunity to be considered. Regardless of where you came from, how you identify, or the path that led you here- you are welcome. If you read this job description and feel passion and excitement, we're just as excited about you.

All legitimate roles with Norstella will be posted on Norstella's job board which is located at norstella.com/careers. If a role is not posted on this job board, a candidate should assume the role is not a legitimate role with Norstella. Norstella is not responsible for an application that may be submitted by or through a third-party and candidates should proceed with extreme caution if a third-party approaches them about an open role with Norstella. Norstella will never ask for anything of value or any type of payment during or as part of any recruitment, interview, or pre-hire onboarding process. If you are aware of or have reason to believe a job posting purportedly for a role with Norstella is fraudulent or otherwise not authorized by Norstella, please contact the Company using the following email address:[HIDDEN TEXT].

Senior Engineer, QA (Data Quality & Automation)