Job Description

Description

About Norstella

At Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker--and help patients in need. Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle --and get the right treatments to the right patients at the right time.



Each organization (Citeline, Evaluate, MMIT, Panalgo, The Dedham Group) delivers must-have answers for critical strategic and commercial decision-making. Together, via our market-leading brands, we help our clients:Citeline - accelerate the drug development cycle Evaluate - bring the right drugs to market MMIT - identify barrier to patient access Panalgo - turn data into insight faster The Dedham Group - think strategically for specialty therapeutics


By combining the efforts of each organization under Norstella, we can offer an even wider breadth of expertise, cutting-edge data solutions and expert advisory services alongside advanced technologies such as real-world data, machine learning and predictive analytics.

As one of the largest global pharma intelligence solution providers, Norstella has a footprint across the globe with teams of experts delivering world class solutions in the USA, UK, The Netherlands, Japan, China and India.

As an Engineer in Data Platform & Architecture, you will work on projects under the guidance of senior engineers, contributing to the design, development, testing, and maintenance of software applications.

Responsibilities

Develop, test, and maintain high-quality software applications using modern frameworks Take ownership of modules and drive development from concept to production Participate in code reviews and contribute to team knowledge sharing Ensure code quality, maintainability, and scalability through best practices Collaborate with team members, QA engineers, UI/UX designers, and product managers Help Troubleshoot and debug issues in production and non-production environments Participate in code reviews and contribute to improving our coding practices and standards

Qualifications

Minimum 3+ years' experience in designing, developing, and orchestrating ETL pipelines using Python, SQL, and AWS Glue

, including building scalable data ingestion and transformation workflows using PySpark, workflow scheduling tools, and modern data engineering best practices.

Minimum 3+ years' experience working with cloud data ecosystems and data warehousing technologies,

including developing complex SQL transformations, creating and optimizing Snowflake stored procedures, and implementing reliable, production-grade ETL/ELT solutions within modern data pipelines. Minimum 3+ years' experience or equivalent of AWS, GCP, Azure, or another cloud service and/or microservices architecture and/or commensurate skills building commercial applications with modern software engineering practices Minimum 3+ years' experience or equivalent of Agile development and delivery - Scrum, Lean, XP, Kanban methodologies and/or microservices architecture and/or commensurate skills building commercial applications with modern software engineering practices Minimum 3+ years' experience or equivalent of modern relational and NoSQL databases (Experience with relational and/or non-relational databases like PostgreSQL, DynamoDB, MySQL, etc., is a big plus) and/or microservices architecture and/or commensurate skills building commercial applications with modern software engineering practices Minimum 3+ years' experience or equivalent of Terraform, Serverless, AWS Cloud Formation, Azure Front Door, CI/CD in Azure Devops, Security groups, auto scaling etc, Git/GitHub, Monitoring, Log Analytics and/or microservices architecture and/or commensurate skills building commercial applications with modern software engineering practices

Tech-Stack

Strong foundation in core data engineering technologies including

Python, SQL, PySpark, and Snowpark APIs

, with hands-on experience developing scalable data transformation and processing workflows. Proficiency in modern programming and scripting for data engineering workloads using Python, SQL-based development, and distributed processing frameworks. Experience working with cloud-based data platforms and related services, particularly:

Snowflake:

Data warehousing,

SnowSQL, SnowPipe,

stored procedures, streams/tasks, and performance optimization

Orchestration & Workflow Tools: Apache Airflow,

event-driven scheduling, DAG design, dependency management

Data Processing: PySpark,

Snowpark, large-scale ETL/ELT development

DevOps/DataOps Tools: Liquibase

for schema versioning and deployment automation Experience with Code Repository, CI/CD , test driven development is preferred. Creating Unit Testing and Automated integration tests is strongly preferred. Experience with multi-cloud AWS/Azure/GCP cloud is a plus. AWS is required/Others preferred. Data processing experience at scale, generating and consuming large feeds. Experience with other cloud data warehouses like Redshift/Azure SQLWH etc., (nice to have). Experience in handling big data at PB scale (nice to have) Experience in dbt, SQL Mesh would be a plus (nice to have)

Benefits

Health Insurance Provident Fund 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: ApplicationHelp@norstella.com