Summary
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.
Responsibilities
• 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.
Qualifications
• 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.
Education and Experience
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.
Vista Del Mar's Credentials:
Our nationally recognized clinical programs have been awarded a Gold Seal by the Joint Commission, the highest level of accreditation possible. In addition, our educational facilities are fully accredited through the Western Association of Schools and Colleges (WASC), and our graduate degree program is recognized worldwide for its high quality of instructions.
