Lead SQL Reports Developer

Found in: beBee jobs US - 7 days ago

Los Angeles, California, United States L.A. Care Health Plan Full time

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 DegreeIn 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
LightAdditional 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)

  • Sr. Report Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States Los Angeles Homeless Services Authority Full time

    TheLos 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, dedicated to superior service and support, and can diligently work independently in a...

  • SQL Server Database Administrator III

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $105, Min.) - $139, Mid.) - $156, 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...

  • Lead Business Intelligence Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $105, Min.) - $139, Mid.) - $156, 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...

  • Business Intelligence Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States MSIT Full time

    Responsibilities Design develop bank wide dashboard using PowerBI. Design develop and maintain reports ad hoc queries and analytical tools. Produce metrics and other report objects and components. Perform ongoing monitoring automation and refinement of reports and PowerBI. Work with BI Management to identify and resolve data related issues. Work with...

  • ETL Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Analyze requirements from clients and work with development team to provide meaningful analysis on data to satisfy client s business needs. Design maintain and develop efficient SQL & PL/SQL languages to maintain ETL code. Design build and configure applications to meet business process and application requirements. Works with analyst and...

  • Report Writer III

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $77,265.00 (Min.) - $100,445.00 (Mid.) - $123,625.00 (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...

  • C++ Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States Soro Technologies Full time

    Responsibilities Work with Lead and development team to ideate scalable software solutions. Adhere to development strategies and coding practices. Develop well-functioning databases and applications. Ensure consistency with initial design and adhere to Schedules/Deadlines. Analyze structural requirements for new software and applications. Collaborate with...

  • C++ Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Work with Lead and development team to ideate scalable software solutions. Adhere to development strategies and coding practices. Develop well-functioning databases and applications Ensure consistency with initial design and adhere to Schedules/Deadlines. Manage server-side architecture. Analyze structural requirements for new software and...

  • Sales and Business Development Lead

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States Doodle Labs Full time

    Job Description & Responsibilities Doodle Labs is the global leader in high-performance private wireless networking systems. We provide cutting-edge mesh networks for robotics, drones, and the Industrial Internet of Things. Doodle Labs has experienced rapid growth over the past five years as our products have been adopted by Fortune 500 companies (e.g....

  • Php Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States Emblue Full time

    Responsibilities Producing clean efficient code based on specifications. Following the coding standards. Testing and deploying programs and systems. Fixing and improving existing software. Your goal will be to build efficient programs and systems that serve user needs. Work with developers to design algorithms and flowcharts. Produce clean efficient code...

  • Business Intelligence Developer III

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States L.A. Care Health Plan Full time

    Salary Range: $91, Min.) - $121, Mid.) - $136, 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...

  • javascript Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States VISART Full time

    Responsiblities Follow coding standards builds unit tests integration tests and deployment scripts. Prototype/translate designs and style guides into functional user interfaces. Create requirements design and test documentation. Perform training and support to end users. Write technical reports manuals and support documentation. Prepare and deliver...

  • Etl Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Maintain and Manage the existing Client's Enterprise Data Warehouse and ODS builds. Model extensions to the existing Data Warehouse. Builds ETL components according to ETL specifications. Code must address performance dependency auditing error handling and data quality issues. Support post deployment by debugging fixing and participating in...

  • Senior BI Cognos Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States QData Full time

    Required Qualifications Bachelor's Degree in Computer Science / MIS or equivalent experience 5+ years of experience BI Database Experience Cognos BI experience 3+ years (Framework Manager/Data Modeling) Extensive experience on multiple full life cycle Data Warehouse implementations Extensive experience in business intelligence and OLAP SSIS(SQL Server...

  • Senior Java Developer

    Found in: beBee jobs US - 1 week ago

    Los Angeles, California, United States Matal Full time

    Responsibilities Develop through modern Agile development methodologies intuitive easy-to-use native cloud applications in collaboration with the development team project managers business analysts UX designers quality assurance and users across the organization. Take ownership of assigned application development tasks. Design and code complex RESTful micro...

  • Java Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States itechstack Full time

    Position Java Developer with "Java 8 and above HTML 5 CSS3 Angular JS Spring MVC Spring Boot REST API Junit"Candidate Should have good expertise on SQL knowledge ((e.g. PostgreSQL MySQL MongoDB)Location Los Angeles CAWhat You'll DoDesign develop implement and maintain java application phases code and software.Conduct software analysis programming testing and...

  • Lead Sales Development Representative

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States AdQuick Full time

    We're reinventing how marketers and agencies plan, book, and measure outdoor advertising.AdQuick's mission is to make outdoor advertising easy, and is the first company to allow anyone to complete the full cycle of booking outdoor ads online, from searching available inventory, to vetting locations, approving assets and analyzing results. With revenue...

  • Dot Net Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States VISART Full time

    Qualifications Bachelor's degree in Computer Science Engineering or a related field. 5-8 years of professional experience as a .NET Developer. Strong proficiency in .NET Core/C# programming language. Solid understanding and hands-on experience with microservices architecture. Experience with CI/CD tools like Jenkins for automated build test and deployment....

  • Lead iOS Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States Soyal Full time

    About Soyal:Soyal is a company working to automate the hotel check in system and provide a more customizable experience in the hospitality industry.Soyal is co-founded by the CEO of Uptown (a smart beverage distribution company) currently valued at ~$38M and founder of WorkBench, Amazon Regional Manager, and a crypto day trader Lead iOS Developer Position...

  • Software Developer

    Found in: beBee jobs US - 2 weeks ago

    Los Angeles, California, United States wipros Full time

    Responsibilities Develop custom modules scripts and templates to extend the functionality of the Ignition platform and meet specific operational requirements. implements Ignition features and changes while monitoring security reliability and performance. Performs complex and precise troubleshooting to pinpoint root causes for issues identified by the...