Data Engineer

At Norstella, our mission is simple: to help our clients bring life-saving therapies to market quickerand 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

Norstella is seeking an experienced Data Engineer with a background in Data Warehouse & Technology, to manage and deliver our expanding program of work for integrating business applications to the data warehouse. The Data Engineer will be responsible for designing, implementing, deploying, and supporting various data management technologies and architectures.

You will be a critical team member and developing the means to collect and ingest data, developing data models and data engines, creating automated data pipelines, and taking the lead in making them production ready. You will assist with integrating with existing applications and will have the opportunity to accelerate the delivery of and improve the quality of the enterprise data & insight.

Key Duties & Responsibilities

• Analyse data sources and prepare data ingestion pipelines.
• Stage data, assess the quality of the data, cleanse data.
• Design and implement ETL jobs and transformations to populate a data lake and data warehouse.
• Integrate data pipelines to the enterprise data warehouse following the architecture principles.
• Perform and monitor data loads and optimize data for extraction and reporting use.
• Administer the data warehouse by performing appropriate database management functions (e.g., maintain space availability, set indexing, monitor utilization, jobs, performance, check databases integrity) to ensure optimum capacity and data warehouse performance.
• Monitor, report, and analyse usage trends to maintain quality control and high performance of the data retrieval from a database or other data storage.
• Administer users access with data governance policies.
• Participating in data workshops as necessary
• Collaborating with business and technology partners to grow and develop the data engineering practice.

Key Requirements

• 4+ years of experience working in cloud technology especially AWS stack
• Aws data stack experience is a must (AWS Glue), Apache airflow experience.
• Strong Python, T-SQL, C# development skills (min 4 years hands-on experience) for building and redefining data pipelines is required.
• Data modelling experience in data warehouse concepts like fact tables, lookup tables, both designing and creating database objects like tables, views, stored procedures, functions, row level security is a must.
• 4+ years of experience working with Data Lakehouse especially Snowflake
• Good analytical skills, ability to learn quick and synthesize the information.
• Experience in fast moving projects with tight deadlines.
• Strong communication skills, both verbal and written.
• The successful candidates will be expected to communicate effectively with both business and technical teams when troubleshooting issues.
• Excellent debugging, problem solving and testing skills.
• Good interpersonal skills and capable of working individually and as part of a team.
• BS degree in Computer Science, Information Systems, or equivalent experience.

Nice to Have

• Real-time data processing with Apache Kafka
• Experience in working with / supplying data to visualization tools such as Qlik, Tableau, Power BI or similar.
• Good understanding of data integration patterns.
• Experience with / exposure to software development for analytic applications.

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.