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:[Confidential Information]. 
