Jobs
>
Los Angeles

    Lead SQL Reports Developer - Los Angeles, United States - L.A. Care Health Plan

    L.A. Care Health Plan
    L.A. Care Health Plan Los Angeles, United States

    2 weeks ago

    Default job background
    Description
    Lead SQL Reports Developer


    Job Category:
    Information Technology


    Department:
    Provider Data Management


    Location:
    Los Angeles, CA, US, 90017


    Position Type:
    Full Time

    Requisition ID: 10836


    Salary Range:
    $102, Min.) - $132, Mid.) - $163, 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 in five health plans, 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.

    Job Summary


    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 LA 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.

    Duties

    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 LA 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 LA Care systems environment and seek lasting solutions.

    Develop policy, procedures, and reports tailored to the various user groups at LA 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.

    Duties Continued


    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.

    Education Required

    Bachelor's Degree

    In lieu of degree, equivalent education and/or experience may be considered.

    Education Preferred

    Experience


    Required:


    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.

    Skills


    Required:
    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.

    Licenses/Certifications Required

    Licenses/Certifications Preferred

    Required Training

    Physical Requirements

    Light

    Additional Information

    Salary Range Disclaimer:
    The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

    L.A. Care offers a wide range of benefits including

    Paid Time Off (PTO)

    Tuition Reimbursement

    Retirement Plans

    Medical, Dental and Vision

    Wellness Program

    Volunteer Time Off (VTO)
    #J-18808-Ljbffr
  • UCLA

    Reporting & Visualization Developer

    1 week ago

    UCLA Los Angeles, United States

    The **Reporting & Visualization Developer** will design, develop, and maintain business intelligence reports and dashboards to support effective decision making throughout the university. This role will ensure that solutions balance technical excellence with usability and accessi ...

  • Los Angeles Homeless Services Authority

    Sr. Report Developer

    1 week ago

    Los Angeles Homeless Services Authority Los Angeles, United States

    The · Los Angeles Homeless Services Authority (LAHSA) · seeks motivated professionals who want to use their talents and skills to make a difference. Our 750+ FTE staff are adaptive problem solvers and passionate about enriching people's lives. · If you are mission-driven, dedi ...

  • American General Life Insurance Company

    Reporting Development Analyst

    1 week ago

    American General Life Insurance Company Los Angeles, United States

    All fields are required unless specified optional · Your Name · Your Email · Your Resume (optional) · By clicking on the apply button, I agree to the Terms of Use · and acknowledge I have read the Privacy Policy · and agree to receive email job alerts. The information you provi ...

  • Georgia IT Inc

    NetSuite Report Developer

    5 days ago

    Georgia IT Inc Los Angeles, United States

    Position - NetSuite Report Developer · Location - Vernon, CA · Position type - Full time · Salary plus benefits · US Citizens and those authorized to work in the U.S are encouraged to apply. We are unable to sponsor at this time.2+ years of writing high quality, maintainable, ...

  • L.A. Care Health Plan

    Lead SQL Reports Developer

    3 weeks ago

    L.A. Care Health Plan Los Angeles, United States

    Salary Range: $102, Min.) - $132, Mid.) - $163, 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 opera ...

  • American General Life Insurance Company

    Reporting Development Analyst

    1 week ago

    American General Life Insurance Company Calabasas, United States

    Reporting Development Analyst: (Woodland Hills, CA): Develop, design, & maintain Tableau dashboards & analytics. Collect, refine, & prepare data for analytics & visualization. Work with Tableau development; designing data models & reports; relational databases; query authoring; s ...

  • City National Bank

    HR Reporting Analyst

    16 hours ago

    City National Bank Los Angeles, United States

    Overview: · **HR REPORTING ANALYST** · **WHAT IS THE OPPORTUNITY?** · This position is responsible for performing various types of reporting, creating and maintaining metric dashboards, for the Human Resources (HR) division. The position also provides project support as needed fo ...

  • Steneral Consulting

    SQL Developer

    5 days ago

    Steneral Consulting Los Angeles, United States

    **Position · - SQL Developer** · **Location · - Los Angeles, CA** · **Duration · - 7 months + possible extension** · **Interview Mode · - Video** · **Visa · - USC, GC, GC-EAD, H4-EAD** · **Mandatory Skills**: · 1) Establish and document the technical requirements for reporting so ...

  • Lucas Museum of Narrative Art

    Manager, Database and Donor Operations

    1 day ago

    Lucas Museum of Narrative Art Los Angeles, United States

    *** · The Lucas Museum of Narrative Art is seeking an experienced Manager, Database and Donor Operations to be a key resource to driving operational excellence in the Development department. Reporting to the Director, Membership & Development Operations, this role will provide le ...

  • Baby2Baby

    Development Coordinator

    1 week ago

    Baby2Baby Los Angeles, United States

    **Reports to - Director of Development**: · **Organization Overview**: · Baby2Baby provides children living in poverty with diapers, clothing, and all the basic necessities that every child deserves. In the last 13 years, Baby2Baby has distributed over 450 million items to childr ...

  • City National Bank

    Business Intelligence

    1 week ago

    City National Bank Los Angeles, United States

    Overview: · **BUSINESS INTELLIGENCE (BI) DEVELOPER** · **WHAT IS THE OPPORTUNITY?** · As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and i ...

  • Equitas Academy Charter Schools

    Special Education Case Manager

    1 week ago

    Equitas Academy Charter Schools Los Angeles, United States

    The mission of Equitas Academy Charter Schools is to provide a structured, achievement-based community that prepares students to graduate from four-year colleges and universities. We currently serve over 1,800 students and operate four elementary schools and two middle schools in ...

  • UCLA

    Manager, Prospect and Stewardship

    2 days ago

    UCLA Los Angeles, United States

    Reporting to the Chief Development Officer, the incumbent will work closely with senior leaders of the Development team to manage overall prospect development across multiple fundraising areas, including annual fundraising, campaign, and special projects to advance ambitious goal ...

  • Secretariat LLC

    Associate Director Construction Delay

    5 days ago

    Secretariat LLC Los Angeles, United States

    Job Description: · THE COMPANY · When you join Secretariat, you become part of a rapidly growing elite team of bright minds and passionate problem-solvers. Your skills and expertise will be utilized on day one - working with the world's most renowned law firms, leading corporatio ...

  • St. Francis Center

    Development Manager

    1 week ago

    St. Francis Center Los Angeles, United States

    Since 1972 the mission of St. Francis Center (SFC) is to feed, serve, and walk with the poor as a community of hope in the spirit of Saint Francis of Assisi. St. Francis Center seeks a Development Manager to work with the Executive Director and Associate Director to develop a com ...

  • L.A. Care Health Plan

    Clinical Data Analyst Iii

    1 week ago

    L.A. Care Health Plan Los Angeles, United States

    Clinical Data Analyst III · **Job Category**:Clinical**Department**:Quality Improvement**Location**:Los Angeles, CA, US, 90017**Position Type**:Full Time**Requisition ID**:11152**Salary Range**: $88, Min.) - $115, Mid.) - $142, Max.)- Established in 1997, L.A. Care Health Plan is ...

  • Leadership Education for Asian Pacifics, Inc.

    Director of Finance

    3 days ago

    Leadership Education for Asian Pacifics, Inc. Los Angeles, United States

    **Who We Are**: · - **LEAP (Leadership Education for Asian Pacifics) **_is a national, nonprofit organization founded in 1982 with a mission to achieve full participation and equality for Asian and Pacific Islanders (APIs). LEAP works to achieve this mission by**:Developing Peopl ...

  • Jada Systems, Inc.

    SQL Developer

    1 week ago

    Jada Systems, Inc. Los Angeles, United States

    Job Summary: · Jada Systems Inc seeks qualified proposers to provide SQL Developer on behalf of the Information Technology Services. · **Duties**: · 1) Establish and document the technical requirements for reporting software such as tables, views, report design, unit test plans, ...

  • USC

    Project Assistant

    1 week ago

    USC Los Angeles, United States

    Assists with data collection for a project or study and assists with research center or project administrative functions. · Job Accountabilities, · - Assists with data collection for a research study. Follows established data collection and management procedures to prepare, colle ...

  • EDR Technology

    SQL Developer

    3 days ago

    EDR Technology Los Angeles, United States

    **SQL Developer** · **Location: Los Angeles, CA(Onsite)** · **Must be a Green Card Holder or US Citizen** · **Job Description: Qualifications and Duties** · 1) Establish and document the technical requirements for reporting software such as tables, views, report design, unit test ...