• Design, develop, and maintain ETL pipelines within Microsoft Fabric (Data Factory, Lakehouse, and Dataflows) to ingest, transform, and standardize clinical trial and patient-related data from multiple source systems including CTMS platforms, and site-level datasets.
• Build and maintain interactive Power BI dashboards and reports that communicate performance metrics, site KPIs, enrollment trends, and data quality indicators to cross-functional stakeholders including Clinical Operations, Data Management, and executive leadership.
• Develop and execute data validation, anomaly detection, and quality control routines to ensure the integrity and regulatory compliance of clinical data assets in accordance with GCP, 21 CFR Part 11, and ICH guidelines.
• Write, optimize, and maintain SQL queries and Python scripts to support data extraction, feature engineering, and automated reporting workflows across structured and unstructured datasets.
• Support the implementation and maintenance of semantic data models within Microsoft Fabric, ensuring consistent definitions, documentation, and governance of clinical data elements across studies.
• Train and enable end users on Power BI dashboards and self-service reporting tools; document data dictionaries, standard operating procedures, and data governance guidelines to promote data literacy organization wide.
• Participate in the evaluation, selection, and integration of data platforms and contribute to data migration, mapping, and reconciliation activities during system implementations or upgrades.

• Education: Bachelor’s degree in Computer Science, Information Systems, Biostatistics, Data Science, or a related field. Master’s degree preferred.
• Experience: Minimum 3 years of experience in data analysis, data engineering, or clinical programming. Prior experience in clinical research, pharmaceutical, or CRO environment strongly preferred. Demonstrated ability to develop and maintain ETL pipelines, data models, and BI dashboards in a production setting.
• Licenses/Certifications: Microsoft Power BI Data Analyst Associate certification required or must be obtained within 6 months of hire. Microsoft Fabric or Azure Data Engineer Associate certification preferred.
• Technical Skills/Systems Experience: Required: Microsoft Fabric (Data Factory, Lakehouse, Dataflows Gen2), Power BI (report development, DAX, semantic modeling), SQL (intermediate to advanced), Python (pandas, NumPy, scikit-learn), and demonstrated experience with Enterprise AI and AI-assisted development tools (e.g., Microsoft Copilot, GitHub Copilot, or equivalent).
• Other Requirements: Ability to work effectively in a remote or hybrid environment with occasional travel to clinical sites or corporate offices as needed. Strong written and verbal communication skills with the ability to present complex data findings to non-technical audiences. Ability to manage multiple concurrent projects and deliverables in a fast-paced clinical research environment.

• Prior experience at a Contract Research Organization (CRO), clinical site network, or pharmaceutical/biotech company.
• Hands-on experience with NLP, machine learning model development, or RAG-based analytics applied to clinical or operational data.
• Familiarity with Apache Airflow, dbt, Snowflake, Databricks, or other modern data orchestration and warehousing tools.
• Experience with Microsoft Power Platform, including Power Automate for workflow automation and data integration scenarios within an M365 environment.
• Familiarity with Microsoft Fabric Direct Lake mode and experience planning or executing Direct Lake migrations from Import or DirectQuery semantic models.
• Familiarity with clinical data systems such as CTMS, or eTMF solutions. Working knowledge of data governance principles and regulatory standards applicable to clinical trial data (21 CFR Part 11, ICH-GCP, CDISC SDTM/ADaM concepts).
• Microsoft Azure Data Scientist Associate or AWS Cloud Practitioner certification.

• Analytical Thinking: Ability to decompose complex clinical data problems, identify root causes, and translate findings into clear, evidence-based recommendations.
• Attention to Detail & Data Integrity: Meticulous in validating data accuracy and maintaining rigorous quality standards consistent with regulated clinical research environments.
• Cross-Functional Collaboration: Demonstrated ability to partner effectively with clinical, operational, finance and IT stakeholders to align data solutions with business objectives.
• Communication & Data Storytelling: Able to communicate complex analytical results and technical concepts clearly to both technical peers and non-technical leadership audiences.
• Adaptability & Continuous Learning: Proactively keeps pace with evolving data technologies, clinical research regulations, and industry best practices; comfortable operating in a dynamic, growth-stage organization.
• Project Management & Prioritization: Skilled at managing multiple concurrent workstreams, setting priorities under deadline pressure, and communicating status proactively to stakeholders.

Pay

• $70,000 - $105,000