What are the responsibilities and job description for the Data Integration Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Robert Half, is seeking the following. Apply via Dice today!
Description
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, Azure
Functions, and/or custom scripts to ingest data from multiple source systems
into the BHRS data platform.
Extend the existing SmartCare API integration to pull additional datasets and
ensure comprehensive EHR data coverage for the dashboard.
Develop new integrations with state-level systems (BHIS, CalOMS, CSI) and
county internal systems (financial, HR/workforce, compliance tracking) using
APIs, SFTP, flat file ingestion, or database connectors as appropriate.
Write data transformation and cleansing logic (SQL, Python, or C#) to
normalize, deduplicate, validate, and prepare source data for the analytical
data model.
Implement error handling, logging, retry logic, and alerting for all data
pipelines 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 table
creation, stored procedures, views, and indexing.
Write and maintain unit tests and integration tests for data pipelines and
transformation logic.
Document all integrations, data mappings, transformation rules, and pipeline
configurations for ongoing maintenance and knowledge transfer.
Requirements
Required Qualifications:
4 years of experience in data integration, data engineering, or backend
development with a focus on ETL/ELT pipelines.
Hands-on experience with Microsoft Azure data services, particularly Azure Data
Factory and Azure SQL Database.
Strong SQL skills including complex queries, stored procedures, views,
indexing, and performance tuning.
Proficiency in Python or C# for scripting, data transformation, and automation
tasks.
Experience consuming and integrating with RESTful APIs, including
authentication (OAuth, API keys), pagination, and error handling.
Familiarity with common data exchange formats and protocols (JSON, XML, CSV,
SFTP, HL7/FHIR is a plus).
Understanding of data quality principles: validation, deduplication,
reconciliation, and data lineage.
Experience with version control (Git) and collaborative development workflows.
Strong troubleshooting and debugging skills for data pipeline issues.
U.S. citizenship or authorization to work in the United States.
Preferred Qualifications:
Experience working in healthcare, behavioral health, or county/state government IT environments.
Familiarity with SmartCare EHR (Streamline Healthcare Solutions) or similar behavioral health EHR platforms and their data structures.
Knowledge of healthcare data standards such as HL7, FHIR, or X12 transactions.
Experience with California DHCS data systems and reporting requirements (BHIS, CalOMS, CSI).
Familiarity with HIPAA and 42 CFR Part 2 data privacy requirements.
Experience with Power BI datasets, dataflows, or DirectQuery configurations.
Azure certifications (e.g., Azure Data Engineer Associate, Azure Fundamentals).
Experience with Azure DevOps for CI/CD pipelines and release management.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Description
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, Azure
Functions, and/or custom scripts to ingest data from multiple source systems
into the BHRS data platform.
Extend the existing SmartCare API integration to pull additional datasets and
ensure comprehensive EHR data coverage for the dashboard.
Develop new integrations with state-level systems (BHIS, CalOMS, CSI) and
county internal systems (financial, HR/workforce, compliance tracking) using
APIs, SFTP, flat file ingestion, or database connectors as appropriate.
Write data transformation and cleansing logic (SQL, Python, or C#) to
normalize, deduplicate, validate, and prepare source data for the analytical
data model.
Implement error handling, logging, retry logic, and alerting for all data
pipelines 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 table
creation, stored procedures, views, and indexing.
Write and maintain unit tests and integration tests for data pipelines and
transformation logic.
Document all integrations, data mappings, transformation rules, and pipeline
configurations for ongoing maintenance and knowledge transfer.
Requirements
Required Qualifications:
4 years of experience in data integration, data engineering, or backend
development with a focus on ETL/ELT pipelines.
Hands-on experience with Microsoft Azure data services, particularly Azure Data
Factory and Azure SQL Database.
Strong SQL skills including complex queries, stored procedures, views,
indexing, and performance tuning.
Proficiency in Python or C# for scripting, data transformation, and automation
tasks.
Experience consuming and integrating with RESTful APIs, including
authentication (OAuth, API keys), pagination, and error handling.
Familiarity with common data exchange formats and protocols (JSON, XML, CSV,
SFTP, HL7/FHIR is a plus).
Understanding of data quality principles: validation, deduplication,
reconciliation, and data lineage.
Experience with version control (Git) and collaborative development workflows.
Strong troubleshooting and debugging skills for data pipeline issues.
U.S. citizenship or authorization to work in the United States.
Preferred Qualifications:
Experience working in healthcare, behavioral health, or county/state government IT environments.
Familiarity with SmartCare EHR (Streamline Healthcare Solutions) or similar behavioral health EHR platforms and their data structures.
Knowledge of healthcare data standards such as HL7, FHIR, or X12 transactions.
Experience with California DHCS data systems and reporting requirements (BHIS, CalOMS, CSI).
Familiarity with HIPAA and 42 CFR Part 2 data privacy requirements.
Experience with Power BI datasets, dataflows, or DirectQuery configurations.
Azure certifications (e.g., Azure Data Engineer Associate, Azure Fundamentals).
Experience with Azure DevOps for CI/CD pipelines and release management.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.