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 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/Business Intelligence Administrator is responsible for the architecture, implementation and support of enterprise-wide data migration, data science, data visualization and data analytics platforms. This position partners with existing Analytics and Data Science teams acting as the subject matter expert and technical lead to develop critical data pipelines for making real-time decisions and business recommendations.

Works closely with project managers, Directors and application developers in creating functional and scalable solutions for business clients. Ideal candidate would have passion for and knowledge of data-engineering, big data framework, and distributed computing. Ideal candidate has expertise in designing solutions using sqoop, hive, hdfs, spark, Impala, Python and R. This position is responsible for solving complex data issues and perform root cause analysis to proactively resolve product and operational issues. Approaches work with security first mindset, adheres to stringent L.A. Care security standards and drives the same level of standards from the team. 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

Mentor and act as a resource to other DBAs, in a distributed environment, in the installation, modification and operational capabilities of ETL Informatica, Data Science (Cloudera), SAS, Data warehouse and Business Intelligence (Informatica, OBIEE) environments.

Drive Big Data Hadoop platform vision for the entire organization by delivering end-to-end applications and frameworks that provide value to entire organization.

Design, develop and provide support for ETL and BI platforms which includes configuration, planning, tuning, database creations, monitoring, and troubleshooting.

Evaluate and seek solutions to production issues as well as new projects. Work closely with applications developers in solving production issues.

Partner with existing Analytics and Data Science teams acting as the subject matter expert and technical lead to develop critical data pipelines for making real-time decisions and business recommendations

Prepare short and long term plans to address infrastructure projects as well as support to and technical leadership for internally/externally sponsored company projects.

Build and expand on L.A. Care's data platform's Hadoop clusters within an agile collaboration environment.

Responsible for automated deployment of Data Science models through CICD based deployments into Cloudera Data Science Workbench and creates custom docker engines on top of the out of box engines to support the data science team.

Ensure all ETL, Data engineering and BI projects and processes are fully documented.

Recommend schedules for database upgrades; assist in the planning and implementation of major software upgrades; adhere to change management procedures and methodologies.Duties ContinuedManages complex projects, engaging and updating key stakeholders, developing timelines, leads others to complete deliverables on time and ensures implementation upon approval.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. Perform other duties assigned.Education RequiredBachelor's DegreeIn lieu of degree, equivalent education and/or experience may be considered.Education PreferredMaster's DegreeExperience

Required:

At least 6 years of experience in a technical function creating and maintaining software applications with the demonstrated experience on the following list of stated knowledge, experience and/ or skills.

Experience in building Apache open source projects and deploying into container platforms such as Clouder Data Science Workbench.

Experience with source controls such as Github and related development process. Experience with workflow scheduling tools such as oozie and Airflow.

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

Significant experience with Big Data tool sets, TOAD and Shell programming.

Preferred:

Healthcare HMO experience

Experience with MS SQL Server, .NET technologies preferred.

Skills

Required:
Expert knowledge in database (Oracle) design, tuning, modeling, ETL, Data warehousing, Business Intelligence and Big Data Technological areas like Cloudera & SAS in multiple computing environments (Unix, Linux, AIX) and must be well versed in Extract, Transform and Load (ETL) tools including Informatica, Oracle PL/SQL programming, and Business Intelligence tools such as OBIEE.

Expertise in Big Data preferably Cloudera and SAS technologies.

Require extensive development/administration experience with specific hands-on practices in Informatica Powercenter, Informatica Data Replication (Real time replication), Oracle Business Intelligence (OBIEE) Server, BI Answers, BI Dashboard, Cloudera and SAS Administration.

Understand and leverage the Oracle Real Application Clusters (RAC), Partitioning, Replication, Materialized View and Parallel SQL Processing.

Expertise in supporting the SAS Analytic platform and resolving any issues integrating the platform with other applications.

Expertise in installing, configuring and administering R-Studio Connect platform. Expertise in deploying shiny applications to Rstudio-connect platform.

Expertise in optimizing Big data applications written in Spark and hive.

Expertise in designing solutions using sqoop, hive, hdfs, spark , and Impala. Expertise in data-engineering, big data framework, and distributed computing. Knowledge of creating custom dockers.

Expertise in scripting languages such as Shell and Python, and analytical programming languages such as R.

Able to lead others in solving complex problems by taking a broad perspective to identify innovative solutions.

Strong understanding of solution and technical design.

Able to influence and communicate optimally, both verbally and written, with team members and business partners.

Proven ability in managing Databases in excess of 1TB+ in sizes.

Must be well versed in data modeling, data warehousing, OLAP technology and tools sign tools such as CA/ERWin, ER/Studio, etc.

Must have the ability to code complex PL/SQL packages, functions, and procedures.

Solid communication skills (verbal, written, and presentation) and strong interpersonal skills required.

Ability to accurately set and adhere to deadlines.

Must have a very high ability to learn new things, especially about new technology developments.

Ability to prioritize projects and workload.

High level of independent judgment.

Must be flexible, organized, and able to handle multiple tasks simultaneously.

Strong project management skills.

Ability to persuade business clients to be able to accept certain design and development issues that may not be the most favorable business practices due to technical reasons.

Licenses/Certifications RequiredLicenses/Certifications PreferredOracle Certified ProfessionalInformatica Certified ProfessionalRequired TrainingPhysical RequirementsLightAdditional 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 ReimbursementRetirement PlansMedical, Dental and VisionWellness ProgramVolunteer 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...

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

  • Business Intelligence Developer III

    1 month ago

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

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

  • Informatica Administrator

    5 days ago

    Los Angeles, California, United States eTek IT Services, Inc. Full time

    Job DescriptionOverview:The role of an Informatica Administrator at eTek IT Services, Inc. is crucial to the organization as it involves managing and maintaining the Informatica platform, ensuring seamless data integration, and contributing to the efficient functioning of the data management infrastructure.Key Responsibilities:Administer and maintain the...

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

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

  • Business Intelligence Analyst

    6 days ago

    Los Angeles, California, United States Avature Full time

    Job SummaryWe are seeking a highly motivated and experienced Business Intelligence Analyst to join our team at Avature. As a Business Intelligence Analyst, you will be responsible for developing and maintaining data visualizations and reports to provide insights into our company's operations.Key ResponsibilitiesDesign and implement data visualizations and...

  • Business Intelligence Developer

    3 months ago

    Los Angeles, California, United States Matal Full time

    Responsiblties Developing publishing and maintaining interactive reports dashboards and data models utilizing Vantagepoint and data visualization such as Power BI. Collaborating closely with stakeholders to gather requirements design impactful visualizations and uncover actionable insights. Conducting in-depth analysis of complex datasets to identify...

  • Business Intelligence Analyst

    2 days ago

    Los Angeles, California, United States Bamboo Digital Inc Full time

    Job Description**Business Intelligence Analyst Position Overview**We are seeking a highly motivated Business Intelligence Analyst to join our team at Bamboo Digital Inc. The ideal candidate will leverage their expertise in data analysis, business insights, and market research to drive strategic decisions that enhance our influencer marketing and e-commerce...

  • Senior Business Intelligence Analyst, Client Solutions, Analytics

    1 week ago

    Los Angeles, California, United States IPG Mediabrands Colombia Full time

    Company OverviewIPG Mediabrands Colombia stands out in the media landscape.We drive business expansion for some of the most ambitious brands globally. Our belief lies in the transformative power of media to redefine our sector and orchestrate a brand's complete consumer journey, harmonizing both commonalities and unique distinctions. When brands resonate...

  • Business Intelligence Developer

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

  • Business Intelligence Lead

    2 days ago

    Los Angeles, California, United States Moonbug Entertainment Full time

    About Moonbug EntertainmentMoonbug Entertainment is a global leader in children's entertainment, inspiring kids everywhere to laugh, learn, and grow. Our company is behind some of the biggest kids' entertainment brands in the world, including CoComelon and Blippi. We believe every child should have access to our entertaining and enriching content, which is...

  • Informatica Administrator

    5 days ago

    Los Angeles, California, United States eTek IT Services, Inc. Full time

    Job DescriptionOverview:The role of an Informatica Administrator at eTek IT Services, Inc. is crucial to the organization as it involves managing and maintaining the Informatica platform, ensuring seamless data integration, and contributing to the efficient functioning of the data management infrastructure.Key Responsibilities:Administer and maintain the...

  • Geopolitical Intelligence Analyst

    2 days ago

    Los Angeles, California, United States Snapchat Full time

    About the RoleSnapchat is a leading technology company that empowers people to express themselves, live in the moment, learn about the world, and have fun together. We are seeking a highly skilled Geopolitical Intelligence Analyst to join our Global Security team.Key ResponsibilitiesImplement and Coordinate Intelligence Programs: Serve as a team...

  • Lead Salesforce Solutions Analyst

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

  • Lead Business Systems Analyst

    1 week ago

    Los Angeles, California, United States Irvine Technology Corporation Full time

    Position OverviewSenior Business Applications Analyst (Remote)We are seeking a contract Senior Business Applications Analyst to collaborate with a premier academic medical institution. This role involves engaging with external partners, system stakeholders, community collaborators, contractors, and leadership to architect, develop, implement, and...

  • Senior Technical Business Analyst

    1 month ago

    Los Angeles, California, United States Fox Corporation Full time

    OVERVIEW OF THE COMPANYFox CorporationUnder the FOX banner, we produce and distribute content through some of the world's leading and most valued brands, including: FOX News Media, FOX Sports, FOX Entertainment, FOX Television Stations and Tubi Media Group. We empower a diverse range of creators to imagine and develop culturally significant content, while...

  • Senior Technical Business Analyst

    2 months ago

    Los Angeles, California, United States Fox Entertainment Group Full time

    OVERVIEW OF THE COMPANY Fox CorporationUnder the FOX banner, we produce and distribute content through some of the world's leading and most valued brands, including: FOX News Media, FOX Sports, FOX Entertainment, FOX Television Stations and Tubi Media Group. We empower a diverse range of creators to imagine and develop culturally significant content, while...

  • Senior Analyst, Marketing Intelligence

    2 months ago

    Los Angeles, California, United States Keck Medicine of USC Full time

    The Senior Marketing Intelligence & Research Analyst will play a pivotal role in shaping the strategic direction of Keck Medicine of USC's marketing efforts. Reporting to the Director of Marketing Operations and Analytics, this senior position will not only lead the delivery of data-driven insights but also guide the cross-functional team towards impactful...