L.A. Care Health Plan

Lead SQL Reports Developer

L.A. Care Health Plan

full-time

Posted on:

Location Type: Office

Location: Los AngelesCaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $102,183 - $163,492 per year

Job Level

Tech Stack

About the role

  • Provide business insights and serve as a focal point for data review and remediation
  • Develop complex formal reports for government entities
  • Work closely with I.T. enterprise data warehouse and application development teams
  • Represent the Department at key multi-disciplinary and technical meetings
  • Develop expert level knowledge of the systems data structures
  • Provide high level advice and guidance to management on systems development and data integration
  • Submit a range of mandatory provider network reports for local, state, and federal government entities
  • Research, audit and analyze complex data
  • Oversee daily workflow and lead assigned staff

Requirements

  • Bachelor's Degree
  • At least 5 years of direct experience developing complex reports derived from SQL or Oracle databases in a Managed Care environment
  • 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)
Benefits
  • Paid Time Off (PTO)
  • Tuition Reimbursement
  • Retirement Plans
  • Medical, Dental and Vision
  • Wellness Program
  • Volunteer Time Off (VTO)
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLOracleETLdata integrationdatabase objectsSQL*LoaderTOADKorn Shell programmingcomplex report developmentdata analysis
Soft Skills
project managementleadershipcommunicationadvice and guidanceworkflow oversight
Certifications
Bachelor's Degree