Senior ETL Engineer

1 week ago


Lake Forest, California, United States Blue Star Partners LLC Full time
Job Overview

Position Title: ETL Developer II
Company: Blue Star Partners LLC
Contract Type: W-2 only, no visa sponsorships

Role Summary:

The ETL Developer II is tasked with the design, construction, and upkeep of SAP data models, aimed at enhancing strategic decision-making within the organization. This position necessitates expertise in application integration and database development, particularly leveraging IBM's InfoSphere suite for ETL processes. The Developer will collaborate with the team to sustain data pipelines and schedules across various technologies, ensuring the efficient and reliable delivery of data to stakeholders.

Key Responsibilities:

  • Develop scalable data models to facilitate self-service reporting and enhance actionable insights.
  • Create comprehensive data mapping for data engineers to construct effective pipelines.
  • Collaborate with IT Functional leads to validate capability design, build, deployment, and ongoing support.
  • Construct and implement data models utilizing SAP data and other relevant sources for business analytics reporting.
  • Identify and resolve issues, ensuring root causes are addressed to prevent recurrence.
  • Diagnose production challenges and perform root cause analysis.

Experience Requirements:

  • 5-10 years in application development and support, with a focus on application integration and database development.
  • 1 to 3+ years utilizing a full life cycle methodology for ETL development with IBM's InfoSphere suite, including DataStage and QualityStage.
  • Proficient in PL/SQL and SQL, with capabilities in developing database views and optimizing query performance.
  • Experience in designing ETL metadata layers and architecture, ensuring alignment with industry standards.

Qualifications:

  • Bachelor's degree in engineering or a related field, or equivalent professional experience.
  • 4+ years of experience in IT as a Data Engineer/ETL developer.
  • 4+ years of technical experience with SAP, including at least 2 years in SAP BI.
  • Strong background in SAP data modeling.
  • 4+ years of experience in developing ETL pipelines using tools such as Azure Data Factory and Informatica.
  • 3+ years of experience with Databricks and/or Spark.

Skills and Competencies:

  • Ability to analyze and synthesize concepts from engineering through implementation and support.
  • Adaptability to changing priorities and the capacity to navigate ambiguities.
  • Strong business acumen, with the ability to convey technical concepts to non-technical audiences.

Preferred Qualifications:

  • 2+ years of SAP experience in Manufacturing and/or Supply Chain.
  • 1+ year of SAP experience in Order to Cash and/or Finance.


  • Lake Forest, California, United States ICU Medical Full time

    Position OverviewThe Senior Engineer, Mechanical plays a pivotal role in enhancing product quality through strict adherence to established design control protocols and effective engineering documentation practices. This position focuses on executing fundamental projects assigned by senior engineers and management, concentrating on existing products while...


  • Lake Forest, California, United States Solugenix Corp Full time

    Senior Automation EngineerLocation: Lake Forest, CA (Onsite)Employment Type: Direct HireSolugenix is in search of a Senior Automation Engineer to join our esteemed client in Lake Forest, CA. This position presents a remarkable opportunity for a seasoned engineer to become part of a prominent aerospace organization.Key Qualifications:In-depth understanding of...


  • Lake Forest, California, United States ICU Medical Full time

    Senior Engineer, Mechanical – Supplier Quality Key Responsibilities As a Senior Engineer specializing in Supplier Quality, you will serve as the primary representative for quality assurance at our manufacturing facility. Your role will involve overseeing the quality of incoming materials by addressing supplier non-conformances and implementing...


  • Lake Forest, California, United States ICU Medical Full time

    Senior Engineer, Mechanical – Supplier Quality Overview The Senior Engineer, Mechanical will serve as the Supplier Quality Engineering Site Representative for ICU Medical. This role is crucial in overseeing the quality of incoming materials by addressing supplier non-conformances (NCs) and Supplier Corrective Action Requests (SCARs). Key...


  • Lake Forest, California, United States ICU Medical Full time

    Position Overview The Senior Engineer, Mechanical plays a crucial role in enhancing product performance by adhering to established design control protocols and maintaining high standards in engineering and documentation practices. This position primarily involves executing complex projects assigned by senior engineers and managers, focusing on existing...


  • Lake Forest, California, United States ICU Medical Full time

    Position Overview The Senior Engineer, Mechanical is tasked with enhancing product functionality through strict adherence to established design control protocols and sound engineering practices. This role primarily involves executing advanced projects under the guidance of senior engineers and management, focusing on existing products while adhering to...


  • Lake Forest, California, United States ICU Medical Full time

    Senior Mechanical Engineer – Supplier Quality Overview The Senior Mechanical Engineer will serve as the Supplier Quality Engineering Site Representative, ensuring the highest standards of incoming material quality. This role is pivotal in managing supplier non-conformances (NCs) and Supplier Corrective Action Requests (SCARs). Key...


  • Lake Forest, California, United States Blue Star Partners LLC Full time

    Job OverviewPosition Title: ETL Developer IICompany: Blue Star Partners LLCWork Arrangement: OnsiteContract Type: W-2 only, no visa sponsorshipsRole Summary:The ETL Developer II will play a crucial role in the design, construction, and upkeep of data models within the SAP environment, facilitating informed decision-making processes. This position demands...


  • Lake Forest, California, United States ICU Medical Full time

    Job Title Senior Mechanical Engineer FLSA Status Non-Exempt Position Summary The Senior Mechanical Engineer will possess a comprehensive understanding and demonstrate proficiency in executing all tasks related to device service operations. This includes responsibilities such as repair, refurbishment, analysis of out-of-box failures, yield enhancement, and...

  • Data Engineer

    3 months ago


    Lake Forest, California, United States Grainger Businesses Full time

    Grainger is a leading broad line distributor with operations in North America, Japan and the United Kingdom. We achieve our purpose, We Keep the World Working, by serving more than 4.5 million customers with a wide range of products that keep their operations running and their people safe. Grainger also delivers services and solutions, such as technical...


  • Lake Forest, California, United States Sterling Engineering Full time

    Job OverviewWe are in search of a skilled Senior Mechanical Engineer with extensive expertise in packaging systems.The ideal candidate will take charge of the design, development, and enhancement of mechanical systems and packaging solutions for our esteemed client specializing in automation technologies.Job Type:Direct HireSalary:$90,000-$120,000Key...


  • Lake Forest, California, United States Sterling Engineering, Inc. Full time

    Job OverviewWe are seeking an experienced Senior Mechanical Engineer to join our team at Sterling Engineering, Inc. in a key role that involves designing, developing, and optimizing mechanical systems and packaging solutions for our clients in the food automation industry.Key Responsibilities:Design and Development: Design and develop mechanical systems and...


  • Lake Forest, California, United States Grainger Businesses Full time

    As a leading industrial distributor with operations primarily in North America, Japan and the United Kingdom, We Keep The World Working by serving more than 4.5 million customers worldwide with products delivered through innovative technology and deep customer relationships. With 2023 sales of $16.5 billion, we're dedicated to providing value for customers,...

  • Data Engineer

    3 months ago


    Lake Forest, California, United States Grainger Businesses Full time

    Grainger is a leading broad line distributor with operations in North America, Japan and the United Kingdom. We achieve our purpose, We Keep the World Working(R), by serving more than 4.5 million customers with a wide range of products that keep their operations running and their people safe. Grainger also delivers services and solutions, such as technical...


  • Lake Forest, California, United States ICU Medical Full time

    Job Title Senior Engineer, Mechanical FLSA Status Non-Exempt Position Summary This role requires a comprehensive understanding and demonstration of proficiency in executing all necessary tasks related to device service operations. This includes repair, refurbishment, analysis of out-of-box failures, yield enhancement, and investigations into product...


  • Lake Forest, California, United States ICU Medical Full time

    Job Title Senior Engineer, Mechanical FLSA Status Non-Exempt Position Summary This role requires a comprehensive understanding and proficiency in executing all tasks essential for device service operations, encompassing repair, refurbishment, failure analysis, yield enhancement, and Product Complaint Investigations (PCI).Additionally, this position entails...


  • Lake Forest, California, United States ARB, Inc Full time

    Job SummaryWe are seeking a highly skilled Senior Construction Project Engineer to join our team at ARB, Inc. As a Senior Construction Project Engineer, you will play a key role in the successful delivery of our construction projects.Key ResponsibilitiesProject Coordination: Facilitate and coordinate engineering activities with all stakeholders, including...


  • Lake Forest, California, United States Insight Global Full time

    Position Overview:This role involves a variety of mechanical engineering tasks focused on the design, testing, and assessment of hardware subsystems for managing and evaluating electronic systems, including semiconductors and embedded devices.Key Responsibilities:Develop and implement detailed designs for new and/or modified existing products in a dynamic...


  • Lake Forest, California, United States ASSA ABLOY Group Full time

    Position OverviewThe Senior Quality Assurance Engineer plays a pivotal role within the Corporate Quality division of ASSA ABLOY – Americas Residential Group. This position is integral to the Baldwin brand, a prestigious name in luxury door hardware, recognized for its commitment to excellence and innovation. The Senior Quality Assurance Engineer will...


  • Lake Forest, California, United States Abbott Full time

    About the RoleWe are seeking a highly skilled and experienced Regional Technical Leader to join our team at Abbott. As a key member of our engineering team, you will be responsible for providing technical leadership and engineering services to support our operations, R&D, new product launches, and manufacturing improvements.Key ResponsibilitiesProvide...