Lead ETL Data Integration Developer

Job Category: Information Technology

Department: IT Enterprise Data Management

Location:

Los Angeles, CA, US, 90017

Position Type: Full Time

Requisition ID: 11491

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 Systems

In 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 Systems

Experience

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

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)