Data and Systems Integration Specialist

Vista Del Mar•Los Angeles, CA

About The Position

The Data and Systems Integration Specialist supports the administration, integrity, and performance of Vista Del Mar Child & Family Services’ SQL Server environments and the clinical, billing, and human resources data they contain. The role supports the data layer behind the agency’s electronic health record (EHR), claims, and reporting systems, and helps turn data into useful information for leadership and programs. The specialist supports production database administration and security, backup monitoring, performance, approved production data changes, data development and migration, EDI billing workflows, EHR integrations, and system upgrades and testing. The position also develops reports and Power BI dashboards, analyzes data across sources, works with internal teams to verify reporting needs and accuracy, troubleshoots routine issues, and documents processes and system changes. The role handles protected health information in accordance with HIPAA and agency confidentiality requirements.

Requirements

  • 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.

Nice To Haves

  • Experience with healthcare information systems and reporting.

Responsibilities

  • Support 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service