Data Architect

• 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

• 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

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