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, fostering an engaging culture for team members and driving strong financial results. Our welcoming workplace enables you to learn, grow and make a difference by keeping businesses running and their people safe. As a 2024 Glassdoor Best Place to Work and a Great Place to Work-Certified company, we're looking for passionate people to join our team as we continue leading the industry over our next 100 years. Position Details: Grainger is looking for a Data Engineer for our CE Design Custom Apps & Automation team. The Data Engineer will report to a CE Design Manager. The Custom Apps and Automation team's primary mission is to Utilize available and emerging technology solutions to reduce waste and enhance team member and customer experience. The Data Engineer will design and deploy automation solutions and custom applications as well as support, maintain, and govern a growing portfolio of tools while fostering strong partnerships across the business. You Will: Pioneer a new way of thinking about Data Pipelines, Orchestration and Configuration at Grainger. Develop our next-generation micro-services to enhance and mature a data-driven culture Help develop the Analytics and Data Kubernetes products in AWS Experience building data products for Customer Service use cases Assemble complex sets of data that meet requirements Identify and design internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes Build required tools for extraction, transformation and loading of data from data sources Work with partners including data, design, product and executive teams and assisting them with data-related technical issues You Have: 3+ years of hands-on experience with Modern Data Engineering projects and practices (Airflow, Kafka, Spark, and python) Successful track record in developing and automating large-scale, high-performance data engineering systems (batch and streaming). Experience with both scripting and system programming languages (Python and Scala). Experience with microservices including defining and testing APIs Experience architecting, developing, and deploying both offline and online feature stores Experience leading data integration efforts of data sources Experience partnering with internal departments (Supply Chain, Marketing, Finance, and HR) to establish requirements. Develop junior team members through modern cloud-based development Translate requirements into technical requirements and produce required source-to-target data mappings. Bring complex concepts into our organization and mentor others. Technology Experience Required: AWS, SQL, Python, Docker/Kubernetes, CI/CD, Github, Snowflake, dbt, Airflow Rewards and Benefits: With benefits starting day one, Grainger is committed to your safety, health and wellbeing. Our programs provide choice and flexibility to meet our team members' individual needs. Check out some of the rewards available to you at Grainger Medical, dental, vision, and life insurance plans Paid time off (PTO) and 6 company holidays per year Automatic 6% 401(k) company contribution each pay period Employee discounts, parental leave, 3:1 match on donations and tuition reimbursement A comprehensive set of emotional, financial, physical and social wellbeing programs We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. We are committed to fostering an inclusive, accessible environment that includes both providing reasonable accommodations to individuals with disabilities during the application and hiring process as well as throughout the course of one's employment. With this in mind, should you need a reasonable accommodation during the application and selection process, please advise us so that we can provide appropriate assistance.

<h3>Job Description</h3><div>Job Description<div>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:<ul><li>Establish the fundamentals for reporting by developing scalable data models to enable self-service reporting, accelerated insights, and improved actionability. </li><li>Create source-to-destination data mapping for data engineers to develop pipelines. </li><li>Partner with IT Functional leads to ensure capability design, build validation, deployment, and steady state support. </li><li>Build and execute data models using SAP data and other sources as needed for reporting business analytics in Power BI. </li><li>Resolve and/or facilitate resolution of problems, including identifying causes to prevent re-occurrence. Identify and resolve business issues, escalating issues when appropriate. </li><li>Troubleshoot production issues and conduct root cause analysis. </li></ul> Responsibilities:<ul><li>Design and map technical specifications per business requirements. </li><li>Communicate structure of models to visualization engineers and business analytics team. </li><li>Design and build Power BI certified semantic models and reports. </li><li>Provide hypercare support and issue resolution. </li><li>Work with the teams to maintain data pipelines and schedules across multiple technologies, ensuring timely, trusted, and targeted data delivery to data value consumers. </li></ul> Experience:<ul><li>5-10 years of experience in application development and support with a background in application integration and database application development. </li><li>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. </li><li>Strong PL/SQL and SQL skills with the ability to develop database views and tune query performance. </li><li>Experience designing the ETL meta data layer, ETL/Interface architecture, and security to ensure the solutions align with industry and SJM standards. </li></ul> Required:<ul><li>Bachelor’s degree in engineering or a relevant field, or equivalent years of experience. </li><li>4+ years of experience in IT as a Data Engineer/ETL developer. </li><li>4+ years of technical experience with SAP, with at least 2 years of experience in SAP BI. </li><li>Strong SAP data modeling experience. </li><li>4+ years of experience developing ETL pipelines in tools such as Azure Data Factory, Azure Functions, Data Flow, Event Hubs, Event Grids, and Informatica. </li><li>3+ years of experience with Databricks and/or Spark. </li><li>Strong architecture, integration, data governance, analytics, and development background. </li></ul> Skills and Competencies:<ul><li>Ability to digest, analyze, and think through concepts from engineering through implementation and support. </li><li>Ability to adapt to changing priorities and work through ambiguities. </li><li>Strong business acumen, with the ability to articulate technical concepts to a functional audience. </li></ul> Preferred:<ul><li>2+ years of SAP experience in the Manufacturing and/or Supply Chain area. </li><li>1+ year of SAP experience in the Order to Cash and/or Finance area. </li></ul></div></div>

Location: LAKE FOREST, IL, US, 60045-5202As 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, fostering an engaging culture for team members, and driving strong financial results.Our welcoming workplace enables you to learn, grow, and make a difference by keeping businesses running and their people safe. As a 2024 Glassdoor Best Place to Work and a Great Place to Work-Certified company, we’re looking for passionate people to join our team as we continue leading the industry over our next 100 years.As the Supply Chain Senior Data Engineer at Grainger, your primary responsibility is to curate a portfolio of high-quality data products in Grainger's purchasing data domain. You will build and improve products in this portfolio by leveraging an end-to-end expertise about the types of insights we seek to generate, the analytics use cases that can drive those insights, the transformations of data in the semantic layer to support the analytics, back to the ingestion of source data that needs to be transformed.Your responsibilities include constructing data pipelines, performing key data transformations, and educating users about your data products so that analytics and applications can generate insights, drive informed decisions, and continuously innovate.You will report to the Sr. Manager, Analytics Enablement.<h3>Key Responsibilities:</h3><ul><li>Design, plan, develop, publish, and enhance data products within the purchasing data domain using scalable data processing systems and pipelines on Snowflake, Kubernetes, Databricks, Airflow, Kafka, APIs, and AWS services using Python.</li><li>Identify, plan, prioritize, and execute against a backlog of data acquisition targets that will enhance a purchasing data domain portfolio.</li><li>Build data pipelines and assets that align with the needs of stakeholders of the purchasing data domain, both inside and outside of the supply chain organization.</li><li>Collaborate with technical and non-technical personnel to design, develop, test, and deploy data pipelines and data product increments.</li><li>Modify and enhance previously developed datasets as business conditions and strategies evolve.</li><li>Educate business stakeholders about the data products in your portfolio through live demonstrations and documentation in our enterprise data catalog.</li><li>Informally mentor and assist less experienced data engineers and business analysts.</li></ul><h3>Minimum Requirements:</h3><ul><li>5+ years of experience in batch and streaming ETL using SQL, Python, AWS S3, Snowflake, Docker, Airflow, CI/CD, GitHub Actions / Circle CI, DAGs, DBT, GitHub / Bitbucket, and data visualization software for Data Engineering or Machine Learning workloads.</li><li>Proficiency in advanced SQL for complex data transformations and query development that optimizes compute performance.</li><li>Working knowledge of how B2B supply chains execute their end-to-end purchasing life cycle from purchase order generation, supplier fulfillment, carrier delivery, warehouse receiving, and payment to supplier.</li><li>Bachelor's degree or equivalent experience in Supply Chain, Computer Science, Data Science, Engineering, or related disciplines.</li><li>Hands-on experience with modern data engineering projects and practices and experience prepping structured and unstructured data for data products.</li><li>Familiarity with containerization and orchestration technologies (Docker, Kubernetes) and experience with shell scripting in Bash, Unix, or Windows shell is preferable.</li><li>Demonstrated experience implementing data management life cycle, using data quality functions like standardization, transformation, rationalization, linking, and matching.</li><li>Experience leading data integration efforts of internal and external data sources.</li><li>Design thinking and product mentality to facilitate common data requirements across multiple stakeholders and use cases.</li></ul>We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.We are committed to fostering an inclusive, accessible environment that includes both providing reasonable accommodations to individuals with disabilities during the application and hiring process as well as throughout the course of one’s employment. With this in mind, should you need a reasonable accommodation during the application and selection process, please advise us so that we can provide appropriate assistance.
#J-18808-Ljbffr

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, fostering an engaging culture for team members and driving strong financial results. Our welcoming workplace enables you to learn, grow and make a difference by keeping businesses running and their people safe. As a 2024 Glassdoor Best Place to Work and a Great Place to Work-Certified™ company, we're looking for passionate people to join our team as we continue leading the industry over our next 100 years. Position Details: As the Supply Chain Senior Data Engineer at Grainger, your primary responsibility is to curate a portfolio of high-quality data products in Grainger's purchasing data domain. You will build and improve products in this portfolio by leveraging an end-to-end expertise about the types of insights we seek to generate, the analytics use cases that can drive those insights, the transformations of data in the semantic layer to support the analytics, back to the ingestion of source data that needs to be transformed. Your responsibilities include constructing data pipelines, performing key data transformations, and educating users about your data products so that analytics and applications can generate insights, drive informed decisions, and continuously innovate. You will report to the Sr. Manager, Analytics Enablement. You Will: <ul> <li>Design, plan, develop, publish, and enhance data products within the purchasing data domain using scalable data processing systems and pipelines on Snowflake, Kubernetes, Databricks, Airflow, Kafka, APIs, and AWS services using Python.</li> <li>Identify, plan, prioritize, and execute against a backlog of data acquisition targets that will enhance a purchasing data domain portfolio.</li> <li>Build data pipelines and assets that align with the needs of stakeholders of the purchasing data domain, both inside and outside of the supply chain organization.</li> <li>Collaborate with technical and non-technical personnel to design, develop, test, and deploy data pipelines and data product increments.</li> <li>Modify and enhance previously developed datasets as business conditions and strategies evolve.</li> <li>Educate business stakeholders about the data products in your portfolio through live demonstrations and documentation in our enterprise data catalog.</li> <li>Informally mentor and assist less experienced data engineers and business analysts.</li></ul> You Have: <ul> <li>5+ years of experience in batch and streaming ETL using SQL, Python, AWS S3, Snowflake, Docker, Airflow, CI/CD, GitHub Actions / Circle CI, DAGs, DBT, GitHub / Bitbucket and data visualization software for Data Engineering or Machine Learning workloads. </li> <li>Proficiency in advanced SQL for complex data transformations and query development that optimizes compute performance.</li> <li>Working knowledge of how B2B supply chains execute their end-to-end purchasing life cycle from purchase order generation, supplier fulfillment, carrier delivery, warehouse receiving, and payment to supplier.</li> <li>Bachelor's degree or equivalent experience in Supply Chain, Computer Science, Data Science, Engineering, or related disciplines.</li> <li>Hands-on experience with modern data engineering projects and practices and experience prepping structured and unstructured data for data products.</li> <li>Familiarity with containerization and orchestration technologies (Docker, Kubernetes) and experience with shell scripting in Bash, Unix or windows shell is preferable. </li> <li>Demonstrated experience implementing data management life cycle, using data quality functions like standardization, transformation, rationalization, linking and matching.</li> <li>Experience leading data integration efforts of internal and external data sources.</li> <li>Design thinking and product mentality to facilitate common data requirements across multiple stakeholders and use cases.</li></ul> We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. We are committed to fostering an inclusive, accessible environment that includes both providing reasonable accommodations to individuals with disabilities during the application and hiring process as well as throughout the course of one's employment. With this in mind, should you need a reasonable accommodation during the application and selection process, please advise us so that we can provide appropriate assistance.

Data Engineer Jobs in Lake Forest, IL

Senior Data Engineer
December 19, 2024

Etl Developer Ii Sap Data Engineer Data Modeler Developer
December 17, 2024

Senior Data Engineer
December 11, 2024

Senior Data Engineer
December 5, 2024

Etl Developer Ii Sap Data Engineer Data Modeler Developer
November 27, 2024

Quick filters

Top companies

Data Engineer Jobs in Lake Forest, IL

Senior Data EngineerDecember 19, 2024

Etl Developer Ii Sap Data Engineer Data Modeler DeveloperDecember 17, 2024

Senior Data EngineerDecember 11, 2024

Senior Data EngineerDecember 5, 2024

Etl Developer Ii Sap Data Engineer Data Modeler DeveloperNovember 27, 2024