ETL Developer II | SAP Data Engineer / Data Modeler Developer Job at Blue Star Partners LLC, Lake Forest, IL

UVdBelRFUVFTZUhYY1duR2FkMzRHOUQweXc9PQ==
  • Blue Star Partners LLC
  • Lake Forest, IL

Job Description

Job Title: ETL Developer II
Location: Lake Forest, IL – 100% Onsite – Local candidates only
Period: 07/01/2024 to 02/07/2025, with possibility of extension

Hours/Week: 40 hours 

Rate: $90 - $100/hour (Hours over 40 will be paid at Time and a Half)

Contract Type: W-2 only, no visa sponsorships


Scope of Services:

The SAP Data Engineer / Data Modeler Developer is responsible for designing, building, and maintaining the SAP data models to accelerate strategic decision-making in the RMDx business. This role requires a background in application integration and database application development, with a focus on utilizing IBM’s InfoSphere suite for ETL development. The Developer will work with the team to maintain data pipelines and schedules across multiple technologies, ensuring timely, trusted, and targeted data delivery to data value consumers.

 
What You’ll Work On:

  • Establish the fundamentals for reporting by developing scalable data models to enable self-service reporting, accelerated insights, and improved actionability.
  • Create source-to-destination data mapping for data engineers to develop pipelines.
  • Partner with IT Functional leads to ensure capability design, build validation, deployment, and steady state support.
  • Build and execute data models using SAP data and other sources as needed for reporting business analytics in Power BI.
  • Resolve and/or facilitate resolution of problems, including identifying causes to prevent re-occurrence. Identify and resolve business issues, escalating issues when appropriate.
  • Troubleshoot production issues and conduct root cause analysis.

 
Responsibilities:

  • Design and map technical specifications per business requirements.
  • Communicate structure of models to visualization engineers and business analytics team.
  • Design and build Power BI certified semantic models and reports.
  • Provide hypercare support and issue resolution.
  • Work with the teams to maintain data pipelines and schedules across multiple technologies, ensuring timely, trusted, and targeted data delivery to data value consumers.

 
Experience:

  • 5-10 years of experience in application development and support with a background in application integration and database application development.
  • 1 to 3+ years of experience using a full life cycle methodology for ETL development utilizing IBM’s InfoSphere suite, DataStage, QualityStage, MetaData Workbench, and Info Analyzer.
  • Strong PL/SQL and SQL skills with the ability to develop database views and tune query performance.
  • Experience designing the ETL meta data layer, ETL/Interface architecture, and security to ensure the solutions align with industry and SJM standards.

 
Required:

  • Bachelor’s degree in engineering or a relevant field, or equivalent years of experience.
  • 4+ years of experience in IT as a Data Engineer/ETL developer.
  • 4+ years of technical experience with SAP, with at least 2 years of experience in SAP BI.
  • Strong SAP data modeling experience.
  • 4+ years of experience developing ETL pipelines in tools such as Azure Data Factory, Azure Functions, Data Flow, Event Hubs, Event Grids, and Informatica.
  • 3+ years of experience with Databricks and/or Spark.
  • Strong architecture, integration, data governance, analytics, and development background.

 
Skills and Competencies:

  • Ability to digest, analyze, and think through concepts from engineering through implementation and support.
  • Ability to adapt to changing priorities and work through ambiguities.
  • Strong business acumen, with the ability to articulate technical concepts to a functional audience.

 
Preferred:

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

Job Tags

Contract work, Local area, Visa sponsorship,

Similar Jobs

TLC Healthforce

Travel Social Worker Medical Social Worker Job Job at TLC Healthforce

Step into a pivotal role as a Medical Social Worker in Georgia, based in Lawrenceville, and...  ...of its urban centers, a reminder that work and life can harmonize. Beautiful Georgia...  ...a signon or performance bonus, housing assistance to ease relocation or temporary housing,... 

College of Marin

Senior Human Resources Analyst Canvass Form Job at College of Marin

 ...Human Resources Analyst Canvass Form Salary: $90,432 - $96,876...  ...January 26, 2026 Open Until Filled To Apply: Senior Human Resources...  ...of the various types of work that may be performed. The omission...  ...from the comfort of their homes. (Kaiser members). For more... 

Richland R-4

2026-2027 School Year Special Education Process Coordinator Job at Richland R-4

 ...Special Education Process Coordinator Richland R-IV School District The Richland R-IV School District is currently accepting applications for a Special Education Process Coordinator . This position plays a vital role in supervising the special education... 

GreatAuPair LLC

Au Pair Job at GreatAuPair LLC

Looking for assistance in foster child care in the Galveston/Texas area. Child's age group: 9-14. Can be "live in" if required. Help mostly needed in mornings and afternoons, sometimes in the evenings/overnight and weekends. Remaining time free for personal use for au pair.

jobgether

Entry Level Data Analyst - REMOTE Job at jobgether

 ...behalf of a partner company. We are currently looking for a Entry Level Data Analyst. This role is crucial as it supports data-driven...  ...Requirements Bachelor's degree or Master's degree in Computer Science, Engineering, Mathematics, Statistics, or a related field....