Data Integration Specialist II

7 days ago


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

Position Title: ETL Developer II
Company: Blue Star Partners LLC
Work Arrangement: Onsite

Contract Type: W-2 only, no visa sponsorships

Role 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 expertise in application integration and database development, particularly with IBM's InfoSphere suite for ETL tasks. The Developer will collaborate with cross-functional teams to ensure the effective management of data pipelines and schedules across diverse technologies, guaranteeing reliable and timely data delivery.

Key Responsibilities:

  • Develop scalable data models to enhance self-service reporting and actionable insights.
  • Create comprehensive data mapping for engineers to facilitate pipeline development.
  • Collaborate with IT leads to validate capability design and support deployment.
  • 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.
  • Conduct troubleshooting for production challenges and perform root cause analysis.

Qualifications:

  • 5-10 years of experience in application development with a focus on integration and database applications.
  • 1 to 3+ years of experience in ETL development using IBM's InfoSphere suite.
  • Proficient in PL/SQL and SQL, with skills in developing database views and optimizing query performance.
  • Experience in designing ETL metadata layers and ensuring compliance with industry standards.

Essential Skills:

  • Bachelor's degree in engineering or a related field, or equivalent 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 and ETL pipeline development using various tools.
  • 3+ years of experience with Databricks and/or Spark.
  • Solid understanding of architecture, integration, data governance, and analytics.

Preferred Qualifications:

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

Competencies:

  • Ability to analyze and synthesize complex concepts from engineering to implementation.
  • Adaptability to changing priorities and navigating ambiguities.
  • Strong business acumen with the capability to communicate technical concepts effectively.


  • Lake Forest, California, United States Woodlands Academy of the Sacred Heart Full time

    The Database Specialist/Annual Fund Coordinator is an in-person role responsible for managing the Development database to ensure "A" Grade data health, integrity, and security. As a member of the Development Team, this position will engage with alumnae to increase their involvement and contributions to the school. Additionally, the Database Specialist/Annual...


  • 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(R) 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...


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

  • 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 Abbott Full time

    About AbbottAbbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 114,000 colleagues serve people in more than 160...


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

    Work Location Type: Hybrid 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...

  • Senior ETL Engineer

    1 week ago


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

    Job OverviewPosition Title: ETL Developer IICompany: Blue Star Partners LLCContract Type: W-2 only, no visa sponsorshipsRole 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...


  • Lake Forest, California, United States Olson Superior Plumbing Full time

    Customer Support Specialist at Olson Superior PlumbingOlson Superior Plumbing, a dynamic plumbing service provider in Southern California, is seeking a dedicated and skilled Customer Support Specialist to enhance our client relations. If you excel in providing outstanding customer assistance, possess strong organizational abilities, and have a background in...


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

    Position OverviewJoin our dynamic team at EVS Inc as a Junior Enrollment Specialist. We are on a mission to establish ourselves as the premier marketing and sales organization in the Santa Ana region. We are looking for an articulate, intelligent, and detail-oriented individual to fill this role. As a Junior Enrollment Specialist, you will receive training...


  • Lake Forest, California, United States COMPATIBLE ELECTRONICS INC Full time

    Job OverviewThe Electronics Testing Specialist will evaluate a range of electronic devices for Electromagnetic Compatibility (EMC) adherence to global regulatory standards. This role will involve working with innovative technologies and advanced equipment.In this position, the specialist will utilize testing instruments such as spectrum analyzers, RF...


  • Lake Forest, California, United States Select Source International Full time

    Job DescriptionJob Title: CAPA Process Analyst IIJob Summary:We are seeking a highly skilled Process Improvement Specialist to join our team at Select Source International. As a Quality Assurance Lead, you will be responsible for leading cross-functional teams in the use of investigational tools to determine the root cause of nonconformities.Main...


  • Lake Forest, California, United States Pfizer Full time

    Job SummaryThe Director, CX and Access Integration is a critical role that will lead the strategy, design, and launch of best-in-class HCP, office staff, and consumer programs to ensure a seamless customer experience for Velsipity and the RHU/GI portfolio of products. This marketing role reports to the RHU/GI Franchise Access Team Lead and will work closely...


  • Lake Forest, California, United States Pfizer Full time

    Job SummaryThe Director, CX and Access Integration is a critical role that will lead the strategy, design, and launch of best-in-class HCP, office staff, and consumer programs to ensure a seamless customer experience for Velsipity and the RHU/GI portfolio of products.Key ResponsibilitiesOwnership of and responsibility for post-Rx customer journey for HCPs,...


  • Lake Forest, California, United States Advantest America Full time

    Human Resources Operations SpecialistAdvantest America is looking for a dedicated HR Operations Specialist to manage various administrative functions within the Human Resources department. This role involves collaborating closely with the HR Business Partner, providing exposure to a range of HR activities including benefits administration, employee...


  • Lake Forest, California, United States Messina Talent Advisors Full time

    Job OverviewWe are seeking a Quality Assurance Specialist for a contract-to-hire opportunity with our client, a prominent manufacturer and supplier of uniform microparticles for biomedical and diagnostic applications. In this role, you will execute quality assurance protocols and comply with standard operating procedures to evaluate products, ensuring strict...


  • Lake Forest, California, United States Northwestern Medicine Full time

    Job SummaryThe Pharmacy Technician Specialist reflects the mission, vision, and values of Northwestern Medicine, adheres to the organization's Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines, and all other regulatory and accreditation standards.Key ResponsibilitiesSupports the Ambulatory...


  • Lake Forest, California, United States Toshiba America Business Solutions, Inc. Full time

    Exciting Opportunity as Senior Regional Service Specialist (Remote)Competitive Annual Salary Range: $80,000.00 to $88,000.00 based on experienceToshiba America Business Solutions, Inc. (TABS) is currently seeking a Senior Regional Service Specialist to join their dynamic team.When you join Toshiba Business Solutions, you become part of a global powerhouse...


  • Lake Forest, California, United States FASTSIGNS #66301 Full time

    Position OverviewAre you seeking a role that combines creativity with structured design principles to leave a lasting impression on your community? Do you find fulfillment in witnessing your designs in everyday life? Is maintaining brand integrity and delivering high-quality work important to you? Are you an autonomous professional eager to elevate your...


  • Lake Forest, California, United States lancesoft Full time

    Job DescriptionJob Title: CAPA Process Analyst IILocation: RemoteDuration: 6 MonthsShift Timings: FlexibleDescription:This is a challenging opportunity for a highly skilled Quality Assurance Specialist to join our team at Lancesoft. As a CAPA Process Analyst II, you will be responsible for progressing investigations and other activities through the CAPA...