L.A. Care Health Plan · 10 hours ago
Lead SQL Reports Developer
Los Angeles, CA
Full-time
Onsite
Senior Level, Lead/Staff
$102K/yr - $163K/yr
5+ years expL.A. Care Health Plan is the nation’s largest publicly operated health plan, dedicated to providing health coverage to low-income residents of Los Angeles County. The Lead SQL Reports Developer will be responsible for developing complex reports, overseeing data quality, and guiding teams in data analysis and reporting processes.
FitnessGovernmentHealth Care
Responsibilities
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 respond to error reports, problems and/or questions; Plan for backup and recovery of database information
Lead data quality efforts and develop appropriate policy where needed
Review the application of all provider data throughout the L.A. Care systems environment and seek lasting solutions
Develop policy, procedures, and reports tailored to the various user groups at L.A. Care such as claims that identify provider issues, and moreover make recommendations as to how the issues could be resolved
Prepare and deploy complex schema updates, data migration and ETL scripts
Undertake ad-hoc queries and develop reports to support the Department
Allocate system storage and plan future storage requirements for the database
Follow and contribute to team standards and utilize industry best practices
Timely, relevant and actionable reports to frontline users and supervisors on provider data issues
Enroll users and design system security
Manages complex projects, engaging and updating key stakeholders, developing timelines, leads others to complete deliverables on time and ensures implementation upon approval
Assist frontline staff to resolve provider data issues through an in-depth knowledge of the data and upstream and downstream processes
Guide and mentor business analysts and other report writers in the department and for those staff working on provider data at L.A. Care
Become a key resource that can actively contribute to the fault finding and resolution process when problems are identified with provider data
Mentor and train staff so they learn, understand and able to navigate the complexity of provider data
Leads the work of assigned staff; regularly assigns and checks the work of others, providing guidance, training and feedback on performance to department management
Oversees the daily office workflow, develops and recommends enhancements to process and procedures
Organize and attend meetings and present/discuss provider data, data schema, and systems with technical and business stakeholders
Present the desired provider data view and ensure that provider data is being extracted and interpreted appropriately
When new requirements are uncovered, develop a plan to deliver provider data to the client (internal or external)
Become a key member on data governance committees
Perform other duties as assigned
Qualification
Required
Bachelor's Degree
At least 5 years of direct experience developing complex reports derived from a SQL or Oracle databases in a Managed Care environment, which includes developing complex reports to external regulators and other entities
Hands-on experience creating all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL; Significant experience with SQL•Loader, TOAD, and Korn Shell programming
Strong general Extract, Transform, and Load (ETL) / data integration experience; Experience developing/managing large-scale databases
Have well develop project management skills and experience leading a project that improved data integrity
At least 1 year of lead experience (process, program, or staff)
Strong database performance tuning experience in a RDBMS environment
Extensive knowledge on PL/SQL, SQL, SQL•Plus; Must have the ability to code complex PL/SQL packages, functions, and procedures; Proven ability in overseeing SQL & Oracle databases of 500+ GB in sizes
Ability to design and develop the database based on established requirements, including modifying any existing SQL database structure as necessary; Ability to maintain application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis and SQL refactoring
Ability to develop proactive working relationships with Providers and other managed care organizations in order to determine business and functional requirements and identify solutions to resolve needs
Ability to provide architectural/database technical expertise to team concerning methods, procedures, and standards to be used during design and development phases
Ability to develop technical documentation and operational procedures for areas of responsibility
Ability to create test plans, test data sets and automated testing to ensure all components of the system meet specifications; Investigate and fix defects; pre and post-release
Ability to troubleshoot/resolve complex database issues
Proficient in database modeling & design with a focus on performance and scalability
Excellent organizational skills with the ability to achieve results within tight deadlines
Strong customer service orientation
Excellent verbal and written communication skills
Work under limited supervision
Benefits
Paid Time Off (PTO)
Tuition Reimbursement
Retirement Plans
Medical, Dental and Vision
Wellness Program
Volunteer Time Off (VTO)
Company
L.A. Care Health Plan
L.A. Care’s mission is to provide access to quality health care for L.A.
1001-5000 employees
H1B Sponsorship
L.A. Care Health Plan has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2023 (1)
2021 (3)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Melanie Rainer
Chief Strategy and Transformation Officer
Recent News
2026-01-17
MarketScreener
2025-08-27
Company data provided by crunchbase