Data Architect

Required qualifications

• Hands-on experience with Google BigQuery (data modeling, SQL, pipelines)
• Experience with Power BI (data models, datasets, DAX, dashboard support)
• Experience with Salesforce data structure, APIs and integrations
• Proven experience building and maintaining REST APIs and two-way system integrations
• Strong background in data architecture, ETL/ELT and data mapping
• Ability to work at least [4] hours overlapping with US Pacific Time (6:00 a.m.–3:30 p.m. PT)
• Clear written and verbal English and strong documentation habits
• Excellent communication skills: you can explain technical issues in plain language to non-technical teams, give proactive updates, flag risks early and respond promptly

What you’ll do

• Maintain our BigQuery data warehouse: schema design, data modeling, pipelines and performance
• Design, build and manage APIs and integrations with two-way sync between Salesforce, CRIO, Sage Intacct, BigQuery and other tools
• Create and maintain clear data mapping, field definitions and a data dictionary across all systems
• Monitor pipelines and integrations, set up alerting, and fix failures before they affect operations, finance or reporting
• Build and support the data models behind our Power BI dashboards so reporting is accurate and trusted
• Set standards for data quality, naming, access control and documentation
• Partner with leadership to turn business needs into scalable data solutions
• Protect sensitive data and keep all systems and integrations compliant with HIPAA privacy and security standards

Preferred qualifications

• Experience working with healthcare applications (e.g., CTMS, EHR/EMR or patient-facing systems)
• Working knowledge of HIPAA privacy and security requirements, including handling protected health information (PHI)
• Experience with CRIO or another clinical trial management system
• Experience with Sage Intacct or another ERP system (NetSuite, QuickBooks Enterprise, Dynamics, etc.)
• Experience in clinical research or another regulated industry
• Familiarity with integration or orchestration tools (e.g., MuleSoft, Workato, Zapier, Airflow, Fivetran, Cloud Functions)

Details

Location: Remote

Engagement: Contract, as-needed, with the goal of a long-term ongoing partnership

Schedule: Flexible hours, with required overlap of at least [4] hours with US Eastern Time when working