Data Integration Developer

Our client in Modesto is seeking a Data Integration Engineer to support the build-out of their BHRS data platform and modern analytics environment. This is a 6‑month contract role that requires 100% onsite work.

Key Responsibilities:

• Build, test, and deploy data pipelines using Azure Data Factory, AzureFunctions, and/or custom scripts to ingest data from multiple source systemsinto the BHRS data platform.
• Extend the existing SmartCare API integration to pull additional datasets andensure comprehensive EHR data coverage for the dashboard.
• Develop new integrations with state-level systems (BHIS, Cal

OMS, CSI

) andcounty internal systems (financial, HR/workforce, compliance tracking) usingAPIs, SFTP, flat file ingestion, or database connectors as appropriate.

• Write data transformation and cleansing logic (SQL, Python, or C#) tonormalize, deduplicate, validate, and prepare source data for the analyticaldata model.
• Implement error handling, logging, retry logic, and alerting for all datapipelines to ensure reliability and rapid troubleshooting.
• Replace placeholder/dummy data in the existing dashboard with live data feeds,validating accuracy and completeness against source systems.
• Support the Solutions Architect in implementing the data model, including tablecreation, stored procedures, views, and indexing.
• Write and maintain unit tests and integration tests for data pipelines andtransformation logic.
• Document all integrations, data mappings, transformation rules, and pipelineconfigurations for ongoing maintenance and knowledge transfer.