Data Engineer
Company: Norstella
Location: Remote, India
Date Posted:
Employment Type: Full Time
Job ID: R-743
Share:
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:
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 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.
THE TEAM
Building on this success, we know there is more scope for data acquisition, data pipeline
orchestration. advanced data processing, real time data ingestion and data science. The Data
Engineering team consists of a blend of data engineers and data scientists with wide-ranging
skills located across the globe.
As part of our growth, we are looking for new data engineers to help building data engineering
pipelines and to support the production of new products. We have multi-functional teams
consisting of pharmaceutical industry experts, R&D, data engineering and data scientists to
rapidly prototype new visualisations and interactive reports using both our existing and newly
acquired datasets.
SCOPE OF THE ROLE
In this role as a Data Engineer, you will:
• Design and optimization of database solutions that sit upstream of main production
environment.
• Creation of optimised upstream database systems in Snowflake / RDS, e.g.
consolidated/standardised clinical trial or pricing database (across multiple
geographies).
• Pulling, processing and structuring new data sets, from public and private sources, e.g.
research abstracts.
• Automate data pipelines using Step Function, Airflow and AWS serverless compute
services.
• Develop & maintain data publication and synchronization processes, supporting
Norstella Data platform (NDP).
• Production sing Snowflake Data Warehouse for all data platforms.
HOW YOU'LL SUCCEED
You will work with NDP team to understand a problem which is hindering developing and
releasing effective new data products which we believe we can help with. After understanding the
problem and how it can be solved, you will work with the team to provide carefully curated and
transformed data for the product.
The data sources may be already available in Snowflake, and simply require dedicated views, or
be more complex such as ingestion of external datasets, use of Data acquisition Framework
(DAF) to gather data, or to join with data from other companies within the Norstella group.
Working with the broader product team, this dataset will be continuously updated, cleaned, and
refined.
Data Engineering
After iterating the design with the visualisation team, the prototype will be demoed and if suitable
converted into a full production product. This will involve productionising the pipeline using Step
Function / Airflow and other AWS cloud services, ensuring it is automatically refreshed with data
if required, and putting in place monitoring and alerts so any issues can be identified and solved
rapidly.
WHAT IT TAKES
• Bachelor’s degree in computer science, similar technical field of study or equivalent
practical experience.
• Excellent SQL querying skills and stored procedure creation skills.
• Experience handling large data sets in formats such as XML, JSON and CSV.
• Building data pipelines.
• Good Python knowledge, with a focus on data manipulation.
• AWS Data services (S3, Glue, MWAA, Lambda, Step Functions, Secrets Manager, SQS,
SES, etc.)
• Superior communication skills, friendly approach to business and the ability to grow and
adapt as business does.
• Finger on the pulse with new & emerging technologies.
Desirable:
• AWS certifications.
• Snowflake / Any Columnar / Any RDS certifications.
• Experience with data visualisation tools such as Tableau, Power BI or QuickSight.
Norstella is an equal opportunities employer and do not discriminate on the grounds of gender,
sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment,
race, colour, 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 behaviour and our business requirements. Norstella operates a zero tolerance policy to any
form of discrimination, abuse or harassment
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.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.
Share:
