Scientific Data Engineer Consultant

ProPharma; Raleigh (NC); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Hybrid work model

Remote work options

Job summary

ProPharma is seeking an experienced Data Engineer to advance data solutions in the pharmaceutical R&D domain. You will prototype data models and pipelines, integrate diverse data sources, and enable low‑code data processing for faster decision making across the product lifecycle.

You will join a small agile team, collaborate with stakeholders, and help standardize data from internal and CRO sources while supporting a hybrid, remote‑friendly work model offered by ProPharma.

Qualifications

• 5+ years designing and developing data pipelines on enterprise data platforms.
• Proficient in Python, PySpark and SQL.
• Experience with modern data platforms, preferably Microsoft Fabric.
• Pharma R&D data domain experience desirable.
• Understanding of CMC and pharmaceutical data workflows desirable.

Responsibilities

• Design flexible, parameterized data models and data pipelines.
• Integrate data from multiple heterogeneous sources.
• Develop configurable data processing pipelines with low-code/no-code approaches.
• Collaborate with stakeholders to evaluate approaches and validate with real-world data.
• Develop tools to extract/transform/ingest data from PDFs, JSON and CSV files.

Skills

Python

PySpark

SQL

Data pipelines

Stakeholder collaboration

Tools

Microsoft Fabric

Job description

For the past 25 years, ProPharma has improved the health and wellness of patients by providing advice and expertise that empowers biotech, med device, and pharmaceutical organizations of all sizes to confidently advance scientific breakthroughs and introduce new therapies. ProPharma partners with its clients through an advise-build-operate model across the complete product lifecycle. With deep domain expertise in regulatory sciences, clinical research solutions, quality & compliance, pharmacovigilance, medical information, and R&D technology, ProPharma offers an end-to-end suite of fully customizable consulting solutions that de-risk and accelerate our partners’ most high-profile drug and device programs.

ProPharma is looking for an experienced Data Engineer with a strong understanding of Pharmaceutical R&D, particularly within the CMC (Chemistry, Manufacturing and Controls) and product development domain.

The successful candidate will work within a small, agile team responsible for prototyping data solutions that support a more efficient, data-driven and model-enabled development organization. The objective is to improve the integration, cleansing, standardization and utilization of both internal and CRO-generated data, enabling better decision‑making, reporting and analytical capabilities across the product development lifecycle.

Key Areas of Work

The Prototyping Activities Are Expected To Include

• Designing and implementing flexible, parameterized data models and data pipelines.
• Integrating data from multiple heterogeneous sources, including datasets with overlapping or related data structures.
• Developing highly configurable data processing pipelines that enable business users to manage data cleansing, standardization and business rules through low‑code/no‑code approaches.
• Working iteratively with stakeholders to evaluate alternative solution approaches and validate them using real‑world data.
• Developing tools and automation pipelines to extract, transform and ingest data from third‑party artefacts, including PDF, JSON and CSV files.

Required Experience

• Minimum of 5 years of experience designing and developing data pipelines and data integration solutions on enterprise data platforms.
• Strong hands‑on experience with Python, PySpark and SQL.
• Experience working with modern data platforms, preferably Microsoft Fabric.
• Demonstrated experience delivering data solutions within the pharmaceutical industry, including working with laboratory and product development data workflows.
• Understanding of CMC and Pharmaceutical R&D data domains would be highly desirable.

We celebrate our differences and strive to create a workplace where each person can be their authentic self. We are committed to diversity, equity, and inclusion. Employees are encouraged to unleash their innovative, collaborative, and entrepreneurial spirits. With a holistic approach as an Equal Opportunity Employer, we provide a safe space where all employees feel empowered to succeed.

All applications to roles at ProPharma are personally reviewed by a member of our recruitment team. We do not rely on AI screening tools to support our hiring process. You will always receive an outcome to your application so that you have an answer from us - whether you're successful or not.

Whilst ProPharma supports remote working, we also recognise the value that comes from in-person collaboration. As such, we encourage any new hires that are based within a reasonably short commute of one of our offices to work on a hybrid basis and spend some time working from that office location, as agreed with your manager. All applications will be treated on their own merit and candidates will not be at any advantage or disadvantage based on their proximity to an office.