Data and Systems Integration Specialist

Supports the administration, integrity, and performance of the agency’s SQL Server environments and the clinical, billing, and human resources data they hold. Supports the data layer behind the agency’s electronic health record (EHR), claims, and reporting systems, and turns that data into usable information for leadership and programs., * Support the administration, security, backup monitoring, and performance of production SQL Server databases.

• Assist with approved production data changes using documented change-control procedures.

• Develop and maintain SQL queries, stored procedures, ETL processes, and data migration tasks.

• Support EDI billing workflows (837) for county and Medi-Cal payers, including claims data validation and reconciliation.

• Support EHR integrations, system migrations, upgrades, testing, and related data interfaces.

• Design, build, and maintain Power BI dashboards, reports, and data models for clinical, operational, billing, and compliance reporting, including DAX measures.

• Analyze clinical, billing, historical, and multi-source data to identify trends, outcomes, discrepancies, and opportunities for improvement; summarize findings for leadership.

• Develop and update operational and compliance reports using SQL, Crystal Reports, and other approved reporting tools.

• Work with program managers, clinical teams, and QAC staff to gather reporting requirements and verify data accuracy.

• Troubleshoot routine data, database, and application issues, coordinating with IT and software vendors as needed.

• Assist with database forms, queries, and reporting layouts that support clinical workflows.

• Document data processes, report definitions, system changes, and issue resolutions; assist with internal audits and regulatory data requests.

• Experience using T-SQL and supporting SQL Server databases, including queries, stored procedures, and data validation.

• Experience developing Power BI dashboards and reports, including data modeling and DAX.

• Ability to mine, reconcile, and analyze large datasets from multiple sources.

• Familiarity with healthcare EDI, Medi-Cal billing, claims data, and EHR data structures.

• Working knowledge of ETL processes, data migrations, reporting tools, and system integrations.

• Experience handling protected health information (PHI) in accordance with HIPAA and agency confidentiality requirements.

• Strong analytical, problem-solving, communication, organizational, and documentation skills., Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field, or an equivalent combination of education and relevant experience. Experience with healthcare information systems and reporting is preferred.

For more than a century, Vista Del Mar Child & Family Services (VDM) has been dedicated to supporting children and families across Los Angeles County through high-quality programs and compassionate care. Our goal is to help children and families build strong foundations that support growth, stability, and meaningful opportunities throughout their lives. Many of the individuals we serve have faced long-standing challenges, and we are committed to meeting families where they are with respect and understanding. Vista Del Mar is guided by values centered on growth, opportunity, fairness, and excellence in service., Vista Del Mar provides a trauma-responsive continuum of services to empower children, youth, and families in Southern California to lead fulfilling lives.