Job Information
Norstella Sr. Engineer (Data Engineer) in Remote, India
Sr. Engineer (Data Engineer)
Company: Norstella
Location: Remote, India
Date Posted: Nov 29, 2024
Employment Type: Full Time
Job ID: R-716
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.
Job Description
Have you wondered how life savingdrugs and therapies are created, tested, marketed,and made available to patients in need? Have you wondered how clinical trials are conducted at a global scale? How governments and health authorities regulate various organizationsparticipatingin this marketplace? Have you wondered how those companies and insurance providers price a certain drug, and how a care providerdeterminesthe right treatment for a given patient? If yes, Norstella could the next step in your career.
In this role, youwill work with internal and external developers responsible for the development andsubsequentsupport of the various platform services components underpinning all the customer facing applications across Norstella. As part of a large technology group,youwill work with product management, architecture,and other software engineering teams in support of the product development roadmap.
We are looking for an experiencedindividualwithgreat communicationskills, deep experience in software engineering, and most importantly, the ability and willingness to keep learning in this ever-changing technology landscape.
Education:
Minimumbachelor’s degree in computer science and engineering or related field of study, or equivalentexperience.
Key Duties and Responsibilities:
Design, develop, andoptimizescalable data pipelines and ETL processes.
Work with AWS services (ECS, Lambda, API Gateway, S3, RDS) to deploy and manage data workflows.
Develop and implement ETL solutions using Python,PySpark, AWS Glue, and AWS Airflow.
UtilizePostgres (knowledge of RDS and Aurora beneficial)and advanced SQL for complex data transformations, including joins, subqueries, and CTEs.
Perform data completeness and quality checks to ensure high data accuracy across all feeds.
Collaborate with data modelers to implement data models (e.g., Snowflake, Star Schema) andoptimizeperformance for data warehousing.
Implement andmaintainCI/CD pipelines for ETL and data processes using AWS DevOps practices.
Key Requirements:
Bachelor’s degree in Computer Science, Engineering, or a related field.
5+ years of experience in data engineering, specifically with cloud data warehousing and ETL development.
Strong programming skills inPythonandPySpark.
ProficiencywithRDBMS, Advanced SQL (including joins, subqueries, CTEs, and writing complex queries), Preference: Postgres.
Hands-on experience with AWS services (ECS, Lambda, API Gateway, S3, RDS).
Familiarity with AWS Glue andAirflowfor workflow orchestration.
Solid understanding of data modelling principles, including Snowflake schema and Star schema.
Experience with ETL testing for data quality and completeness.
Proven experience with AWS DevOps CI/CD practices.
Ability to create Functions/Views/Stored Procs. Experience with complex queries including use of CTEs, table variables,mergeand dynamicSQL.
Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion.
The 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 toaccomplishmust 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 whatdoesn’t.By being true to the data and producing realistic metrics, weare able tocreate 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,Perserverance
We will persevere – even in difficult and challenging situations. Our ability to recover frommis-stepsand 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.
Benefits
Health Insurance
Provident Fund
Reimbursement of Certification Expenses
Gratuity
24x7 Health Desk
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.
Norstella is an equal opportunity employer. All job applicants will receive equal treatment regardless of race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability or handicap, medical condition, sex (including pregnancy and pregnancy-related conditions), marital or domestic partner status, military or veteran status, gender, gender identity or expression, sexual orientation, genetic information, reproductive health decision making, or any other protected characteristic as established by federal, state, or local law.