Lead ETL Data Integration Developer

1 month ago

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

Salary Range:  $121,056.00 (Min.) - $160,400.00 (Mid.) - $199,742.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, 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 ETL Data Integration Developer is responsible for the design, develop, test and implement of current and future data warehouse, business intelligence solutions and data migration projects. This position is responsible for leading the Extract, Transform, and Load (ETL) development activities and ensuring quality of ETL code. The Lead ETL Data Integration developer guides and mentors other developers as well as work collaboratively with other team members. The Lead ETL Data Integration Developer collaborates with data architects, BI architects to design and develop robust and scalable data solutions.  This position is responsible for the daily workflow and leading the work of assigned staff.  The Lead will mentor, coach, act as a resource and provide feedback on performance of assigned staff.  Perform as the expert at identifying opportunities that improve and optimize their data environment for maximum value.

Duties

Responsible for the requirement analysis, design, development, architecture, implementation and support of enterprise-wide databases. Participates in requirements gathering sessions with business and technical staff to distill technical requirements from business requests. Present ETL documentation and designs to team members and convey complex information in a clear and concise manner

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. Contributes to the technical decisions, working with managers to provide coaching, counseling and feedback on technical performance and implementations on projects members. Provide detailed plans and estimates for all phases of a project.

Delivers data integration through the implementation of shared databases, modification and optimization of current systems, managing the exchange and storing of data, and making recommendations when upgrades or changes are needed to maintain smooth operations. Optimizes data warehouse performance by dealing with any data conflicts that arise and keeping data definitions up to date. Updates knowledge of best practices for senior data integration position by keeping track of new technologies and strategies for ETL, partaking in workshops and other educational opportunities, widening personal networks and reading industry publications

Leads the technical planning & requirements gathering phases including estimate, develop, test, manage projects, architect and deliver the projects by applying Systems Development Life Cycle (SDLC) standards.  Manages complex and critical  projects, engaging and updating key stakeholders, developing timelines, leads others to complete deliverables on time and ensures implementation upon approval.

Leads the  defect review meetings with business team and Quality Assurance (QA) leads to prioritize development tasks around project milestones. Collaborate with Quality Assurance resources to debug ETL development and ensure the timely delivery of products.

Provide detailed plans and estimates for all phases of a project; Provides technical support or leadership in the development and continual improvement of service. 

Tune and optimize ETL and database processes and framework. 

Ensures adherence to data management/governance policies, processes, and standards and responsible for fixing data quality issues by working together with data analyst and data architect. 

Duties Continued

Conduct analysis to determine size of effort and resource requirements. 

Provide technical support in outlining and managing Agile sprints.

Automate the processes using UNIX shell and python scripts for business needs. 

Perform other duties as assigned
 

Education Required Bachelor's Degree in Computer Science or Related fields; like: Statistics, Math, or Business SystemsIn lieu of degree, equivalent education and/or experience may be considered.Education Preferred Master's Degree in Computer Science or Related fields; like: Statistics, Math, or Business SystemsExperience

Required: 

At least 6 years of experience designing, developing, and testing ETL interfaces aligned with defined requirements preferably in a healthcare, or analytical or technological industries.

 

At least 3 years of leading process, program, or staff experience.

 

Experience in software development and design with strong emphasis on Data warehousing concepts, database design patterns, ETL methodologies, Processing and Transforming massive quantities of Data, Data cleansing, Data quality and Performance Tuning of ETL and database processes.

 

Experience with Erwin data modeling toolset.

 

Extensive experience in strategizing roadmap projects, data modeling, designing ETL framework and data mart life cycle development and providing technical supervision on implementation of  large end-to-end Data Warehouse applications.

 

Experience in UNIX Shell / Python Scripting for automation of batch and ETL jobs.

Skills

Required: 

Strong technical skill to learn, certified and lead team to EDM technology roadmap.  The Enterprise Data Platforms includes Cloud based Informatica tool, IICS; Amazon AWS, Snowflake cloud technology

Demonstrated ability in success executing I.T. strategies to meet and exceed.  

Strong knowledge and ability in identifying strategic business objectives.

Strong project management skills.

Strong ability to demonstrate success in selling I.T. ideas and solutions to business.  

Strong ability to present ETL documentation and designs to team members and convey complex information in a clear and concise manner.

Ability to demonstrate effectiveness in developing successful business relationships with I.T. internal and business personnel.

Ability to engage key decision makers when it is required.  

Ability to articulate and sell complex solutions to I.T. and Business leaders.

Proven consultative and strategic skills. 

Outstanding inter personal and presentation skills.

Excellent written and verbal/ telephonic communication skills.

Demonstrated ability in providing high level  technical expertise

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)

 

  • Lead ETL Data Integration Developer

    1 month ago

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

    Salary Range:  $121,056.00 (Min.) - $160,400.00 (Mid.) - $199,742.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,...

  • Lead ETL Data Integration Developer

    1 month ago

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

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

  • Lead ETL Data Integration Developer

    1 month ago

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

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

  • ETL Data Integration Developer II

    2 days ago

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

    Salary Range:  $91,536.00 (Min.) - $121,286.00 (Mid.) - $151,034.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,...

  • ETL Data Integration Developer III

    1 month ago

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

    ETL Data Integration Developer III Job Category: Information Technology Department: IT Enterprise Data Management Location: Los Angeles, CA, US, 90017 Position Type: Full Time Requisition ID: 11512 Salary Range: $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.00 (Max.) Established in 1997, L.A. Care Health Plan is an independent public agency...

  • ETL Data Integration Developer III

    4 days ago

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

    Job Category: Information Technology Location: Los Angeles, CA, US, 90017 Position Type: Full Time Salary Range: $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.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...

  • ETL Data Integration Developer III

    2 weeks ago

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

    Salary Range:  $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.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,...

  • ETL Data Integration Developer III

    1 month ago

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

    Salary Range:  $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.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...

  • ETL Data Integration Developer II

    4 days ago

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

    Salary Range:  $91,536.00 (Min.) - $121,286.00 (Mid.) - $151,034.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...

  • ETL Data Integration Developer III

    1 month ago

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

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

  • ETL Data Integration Developer III

    1 month ago

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

    Salary Range:  $105,267.00 (Min.) - $139,478.00 (Mid.) - $173,689.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...

  • Senior ETL Developer

    4 weeks ago

    Los Angeles, United States Solugenix Corp Full time

    Senior ETL Developer LosAngeles, CA (Remote/Onsite) 3-month contract to hire Job ID 24-09100 Solugenix is assisting a client, a health insurance company, in their search for an Senior ETL Developer. This is a 3-month contract to hire opportunity. The Senior ETL-Data Integration Developer is responsible for the operational support of the Informatica...

  • Senior ETL Developer

    3 months ago

    Los Angeles, United States Solugenix Full time

    Overview Senior ETL Developer Los Angeles, CA (Remote/Onsite) 3-month contract to hire Job ID 2024-9498 Solugenix is assisting a client, a health insurance company, in their search for an Senior ETL Developer. This is a 3-month contract to hire opportunity. The Senior ETL-Data Integration Developer is responsible for the operational...

  • ETL Developer

    5 months ago

    Los Angeles, 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...

  • ETL Developer

    5 months 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...

  • Etl Developer

    3 months ago

    Los Angeles, 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...

  • Etl Developer

    5 months 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...

  • Data Integration Lead for Case Management Solution

    1 month ago

    Los Angeles, United States pro it Full time

    Job DescriptionJob DescriptionJob Summary:We are looking for a highly skilled and experienced Data Integration Lead to join our team. The Data Integration Lead will be responsible for overseeing the integration of data across various systems and platforms to ensure seamless and efficient case management solutions. This role requires extensive experience in...

  • Data Integration Lead for Case Management Solution

    1 month ago

    Los Angeles, United States pro it Full time

    Job DescriptionJob DescriptionJob Summary:We are looking for a highly skilled and experienced Data Integration Lead to join our team. The Data Integration Lead will be responsible for overseeing the integration of data across various systems and platforms to ensure seamless and efficient case management solutions. This role requires extensive experience in...

  • Lead Data Engineer

    1 month ago

    Los Angeles, United States Incedo Inc. Full time

    Lead Data EngineerJob Location: Atlanta, GA/Encino, CA (Hybrid)Role Description: As a Senior Technical Lead –Data Modeling at Incedo, you will be responsible for managing and optimizing the data infrastructure, including data modeling and data warehouse solutions using the Data Vault methodology, ensuring its performance, scalability, and security. You...