ETL Developer II | SAP Data Engineer / Data Modeler Developer

$187,200 - $208,000/Yr

Blue Star Partners - Lake Forest, IL

Full-time - Mid Level

Lake Forest, IL

General Merchandise Retailers

About the position

The ETL Developer II role focuses on designing, building, and maintaining SAP data models to enhance strategic decision-making within the RMDx business. This position requires expertise in application integration and database application development, particularly using IBM's InfoSphere suite for ETL development. The developer will collaborate with teams to ensure efficient data delivery and support business analytics through Power BI.

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.

Requirements

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

Nice-to-haves

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

Benefits

• Competitive hourly rate of $90 - $100/hour with overtime paid at time and a half.
• Possibility of contract extension beyond the initial period.