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 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, 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 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 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

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

  • Lead ETL Business Intelligence Administrator

    4 weeks 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 Data Engineer

    3 months ago

    Los Angeles, California, United States SprintFWD Full time

    Data is essential for all our clients decision-making needs whether it's related to franchisee advertising effectiveness, helping key stakeholders understand business KPI's or building new products in emerging markets. This data is deeply valuable and gives us insights into how we can continue improving our service for our team, advertisers and partners....

  • Data Engineer

    5 months ago

    Los Angeles, California, United States Apollose Full time

    Responsibilities Standardize data and reporting across businesses and teams to enhance the consistency and quality of data. Design develop test and document data integrations and assist with deployment validation and hyper care processes. Maintain and support existing ETL/ELT integrations leveraging technical documentation. Develop and maintain existing...

  • MS SQL Database Developer with Informatica Expertise

    4 hours ago

    Los Angeles, California, United States Tetrahed INC Full time

    Job OverviewThe role of an MS SQL Database Developer with Informatica expertise is crucial in ensuring the efficient design, development, and maintenance of MS SQL databases and Informatica ETL processes. This role plays a pivotal part in the organization's data management and integration efforts, contributing to the overall success of data-driven...

  • MS SQL Database Developer with Informatica Expertise

    1 day ago

    Los Angeles, California, United States Tetrahed INC Full time

    Job OverviewThe role of an MS SQL Database Developer with Informatica expertise is crucial in ensuring the efficient design, development, and maintenance of MS SQL databases and Informatica ETL processes. This role plays a pivotal part in the organization's data management and integration efforts, contributing to the overall success of data-driven...

  • Integration Solutions Architect

    6 days ago

    Los Angeles, California, United States Satwic Inc Full time

    Position Overview:As a key member of the Satwic Inc team, the Integration Solutions Architect will play a pivotal role in shaping our integration strategies and solutions. This position requires a seasoned professional with extensive experience in designing and implementing integration frameworks that enhance our operational efficiency.Key...

  • Sr Data Engineer

    5 months ago

    Los Angeles, California, United States codesbright Full time

    Responsibtlies Produce ad-hoc data extracts to answer business questions quickly and thoroughly. Collaborate with Project Managers IT Architecture Business Analysts and Report Developers to achieve business objectives. Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions....

  • Sr Data Analyst

    5 months ago

    Los Angeles, California, United States wipros Full time

    Responsibilities Create and maintain documentation related to data solutions for supply chain operations. Analyze data to identify trends and insights that inform decision-making for supply chain operations. Develop and maintain dashboards scorecards and other visualizations to monitor and analyze supply chain performance. Stay up-to-date with the latest...

  • Sr SSRS PBI Developer

    2 weeks ago

    Los Angeles, California, United States iLink Digital Full time

    Job DescriptionAbout The Company:iLink is a Global Software Solution Provider and Systems Integrator, delivers next-generation technology solutions to help clients solve complex business challenges, improve organizational effectiveness, increase business productivity, realize sustainable enterprise value and transform your business inside-out. iLink...

  • Data Engineer

    5 months ago

    Los Angeles, California, United States VISART Full time

    Responsibilities Implement data ingestion routines both real time and batch using best practices in data modeling. Develop ETL/ELT processes leveraging AWS technologies and Big data tools. Gather business and functional requirements and translate these requirements into robust scalable operable solutions that work well within the overall data architecture....

  • Sr Data Engineer

    5 months ago

    Los Angeles, California, United States wipros Full time

    Responsibilities Building data architectures and data pipelines to collectively bring together data. Designing solutions using Microsoft Azure services and other tools. Assuring that data is cleansed mapped transformed and optimized for storage and use according to business and technical requirements Automating tasks and deploying production standard code....

  • Associate Data Analyst

    5 months ago

    Los Angeles, California, United States MSIT Full time

    Responsiblties Build data pipelines to acquire load and cleanse data sets and prep them for analytical use. Knowledge of quantitative analysis to understand and communicate the value of a data asset and how it can be used to create meaningful insights. Develop analytical models that expose opportunities related to the trading market. Develop and support...

  • Lead Salesforce Solutions Analyst

    6 days ago

    Los Angeles, California, United States Resource Informatics Group Full time

    Position Overview: The Lead Salesforce Solutions Analyst serves as a critical link between business stakeholders and IT departments, facilitating the solution delivery process for the Digital Distribution application suite under the guidance of the Director of Business Engagement. Become part of a dynamic team of skilled professionals dedicated to product...

  • Senior Data Scientist, 5+ Years of Experience

    2 days ago

    Los Angeles, California, United States Data Masked Full time

    Job DescriptionAbout the RoleWe are seeking a highly skilled Data Scientist to join our team at Data Masked. As a Data Scientist, you will play a critical role in driving business growth and decision-making through data-driven insights.Key ResponsibilitiesDevelop and implement advanced data models and algorithms to drive business outcomesCollaborate with...

  • Senior Data Engineer

    2 months ago

    Los Angeles, California, United States Riot Games Full time

    Riot's Data Engineers build products that improve the experience of our players worldwide using petabytes of data and state-of-the-art processing technology. Maximizing the potential of this data is a complex task. The League Data Central team is made up of engineers, data scientists, producers, and product managers focused on evolving the data powered...

  • Data Engineer

    5 months ago

    Los Angeles, California, United States codesbright Full time

    Responsibilities Utilizes the Microsoft SQL Server database software to manage and house data from multiple sources. Assists in the designing of data structures that can support large amounts of data are easy to use and processes efficiently; implements creation of data structures. Designs creates and QCs ETL processes via SQL Server's SSIS functionality...