[Remote] Data Analyst / Programmer

Note: The job is a remote job and is open to candidates in USA. Elite Clinical Network is focused on supporting clinical research operations, and they are seeking a Data Analyst / Programmer. This role involves designing, developing, and maintaining data pipelines and analytical models to provide actionable insights from clinical trial data.

Responsibilities

• 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

Skills

• 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

Company Overview