Data and Systems Integration Specialist — Los Angeles, CA

GET TO KNOW US

For more than a century, gfH9X A6f mbB yhGf8 & 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. kAfTr TSS fCc is guided by values centered on growth, opportunity, fairness, and excellence in service.

OUR CULTURE

At kAfTr TSS fCc, our work is strengthened by the people we serve and the dedicated staff who support them. We strive to create an environment where everyone is treated with dignity, care, and respect. We recognize that personal experiences and life circumstances shape how individuals engage within their communities, and we actively work to reduce barriers while improving access and outcomes for families. kAfTr TSS fCc is committed to fostering a workplace rooted in care, collaboration, professional growth, and mutual support, where each individual feels welcomed and valued. We believe meaningful action is the foundation of lasting trust. We welcome qualified applicants from a wide range of backgrounds and life experiences. Relevant professional and lived experience that supports effective service delivery to children and families is valued. All employment decisions are based on job-related qualifications, experience, and organizational needs.

Mission

kAfTr TSS fCc provides a trauma-responsive continuum of services to empower children, youth, and families in Southern California to lead fulfilling lives.

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.

zrA67 BuC DgH’7 fJGyzevgVmR

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.

Equal Employment Statement

kAfTr TSS fCc is committed to the full inclusion of all qualified individuals. Therefore, all qualified applicants will be considered for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. kAfTr TSS fCc will ensure that persons with disabilities are provided reasonable accommodations as part of this commitment.