Data and Systems Integration Specialist
Vista Del Mar
Data and Systems Integration Specialist
Vista Del Mar
Trauma-informed child and family services nonprofit
GET TO KNOW US
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.
OUR CULTURE
At Vista Del Mar, 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. Vista Del Mar 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:
Vista Del Mar 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.
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.
Equal Employment Statement
Vista Del Mar 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. Vista Del Mar will ensure that persons with disabilities are provided reasonable accommodations as part of this commitment.
Pay Range: 74000.0 - 77000.0 USD
Trauma-informed child and family services nonprofit
Vista Del Mar provides trauma-responsive services for children, youth, and families in Southern California, including residential treatment, mental health care, early intervention, adoption and foster care, and a state-certified school (The Vista School). It is funded as a non-profit through donations, grants, and billing for services, delivering a continuum of care from early intervention to residential programs in West Los Angeles with a family-centered, trauma-informed approach and on-site schooling plus professional training. It differentiates itself by offering education, mental health, adoption/foster care, and residential care all under one organization, supported by a long history dating back to 1908 and a focus on trauma-informed care and family empowerment. Its goal is to help children, youth, and families become self-reliant, stable, and productive by providing coordinated services that support emotional, social, learning, and developmental needs.
Explore more opportunities at Vista Del Mar