Lead SQL Reports Developer

Lead SQL Reports Developer

Job Category:
Administrative, HR, Business Professionals

Department:
Provider Data Management

Location:

Los Angeles, CA, US, 90017

Position Type:
Full Time

Requisition

Salary Range: $ (Min.) - $ (Mid.) - $ (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County’s vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

The Lead Structured Query Language (SQL) Reports Developer provides business insights, serves as the focal point for data review and remediation in peak work periods, and develops a range of complex formal reports for government entities. The Lead SQL Reports Developer will work closely with the Information Technology (I.T.) enterprise data warehouse and application development teams. The Lead SQL Reports Developer will represent the Department at key multi-disciplinary and technical meetings that impact the department’s policies, procedures, and supporting technical systems.

The Lead SQL Reports Developer will work with claims, member services, finance, and compliance departments to provide guidance and information on provider data related issues. The Lead SQL Reports Developer will develop expert level knowledge of the systems data structures in L.A. Care’s three core systems and provide high level advice and guidance to management on systems development and data integration.

The Lead SQL Reports Developer will work with L.A. Care’s Information Technology and Compliance departments to submit a range of mandatory provider network reports for local, state, and federal government entities. These reports will require significant preparation, data integration from multiple data sources, review, and validation before L.A Care delivers them to the requesting entity. The complexity of the reports will require a thorough understanding of database systems, provider data, provider types, encounters, and experience with compliance reports in a managed care environment.

The Lead SQL Reports Developer will respond to inquiries for operational insights from a range of departments and will develop and test complex queries against two complementary, although separate databases. The Lead SQL Reports Developer will develop operational reports and metrics that support the PNO Department Key Performance Indicators (KPI).

The Lead SQL Reports Developer will act as the provider data Subject Matter Expert (SME) for requirements analysis, data analysis, data mapping, report development and testing, report modifications and documentation. The Lead SQL Reports Developer will develop and refine quality review programs to maintain the integrity and reliability of provider data. The SQL Reports Developer will be actively involved in resolving escalated issues interfering with the accurate and timely use of provider data throughout L.A

Care and must have well-developed problem solving skills. This position will research, audit and analyze data that is of a highly complex level. Responsible for the daily workflow and leading the work of assigned staff. This role will mentor, coach, act as a resource and provide feedback on performance of assigned staff.

Lead complex data reviews, develop complex formal reports and audit provider data. Make or recommend ongoing changes to systems to better deliver provider data internally and externally. Oversee the quality of all outbound files and data transfers. Develop accurate formal reports to ‘C-level’ staff at L.A. Care and formal reports and audits to state and federal audiences. Provide an audit trail for provider data and be able to review and respond to complex regulator data questions.

Develop and implement data improvement projects. Provide technical consulting and…