> job detail
G
⚙️Data Engineer
Data Engineer III (LAKE FOREST, IL, US, 60045-5201)
Grainger · LAKE FOREST, IL, US, 60045-5201
// classified as
Data Engineer (Pipelines, infra, ingestion, ETL.)
posted
2d ago
location
LAKE FOREST, IL, US, 60045-5201
languages
python, sql
tools
aws, dbt, kafka
> stack
pythonsqlawsdbtkafkasnowflakesparkairflowdbt
> description
<p><span style="font-size:12.0px"><span style="font-family:Arial, Helvetica, sans-serif"><strong> </strong></span></span></p>
<p><span style="font-family:verdana, geneva, sans-serif;font-size:12.0pt"><span style="color:indianred"><strong>Work Location Type: </strong></span><span style="color:indianred"><strong><strong><strong><strong>Hybrid</strong></strong></strong></strong></span><span style="color:indianred"> </span></span></p>
<p><span style="font-size:12.0pt;color:indianred;font-family:verdana, geneva, sans-serif"><strong>Req Number</strong> 331071</span></p>
<p><span style="color:indianred;font-family:verdana, geneva, sans-serif;font-size:12.0pt"><strong>About Grainger</strong></span></p>
<p><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">W.W. Grainger, Inc. is a leading broad line distributor with operations primarily in North America and Japan. At Grainger, We Keep the World Working® by serving more than 4.6 million customers worldwide with maintenance, repair and operating (MRO) products and value-added solutions delivered through innovative technology and deep customer expertise. Known for its commitment to service and purpose-driven culture, the Company reported 2025 revenue of $17.9 billion. For more information, visit<a href="http://www.grainger.com"> www.grainger.com. </a></span></p>
<p> </p>
<p><span style="color:#b22222;font-family:verdana, geneva, sans-serif;font-size:12.0pt"><strong><span style="color:indianred">Compensation</span></strong></span></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">The anticipated base pay compensation range for this position is $104,500.00<strong> – </strong>$174,200.00. This role is eligible for an incentive target of up to 10 % or $ , based on the achievement of individual and company performance objectives in accordance with the current terms of the incentive program which are subject to change.</span></p>
<p> </p>
<p style="margin-bottom:11.0px;text-align:justify"><span style="font-size:12.0pt;color:indianred;font-family:verdana, geneva, sans-serif"><strong>Rewards and Benefits</strong></span></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">With benefits starting on day one, our programs provide choice and flexibility to meet team members' individual needs, including:</span></p>
<ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc">
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">Medical, dental, vision, and life insurance plans with coverage starting on day one of employment and 6 free sessions each year with a licensed therapist to support your emotional wellbeing.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">18 paid time off (PTO) days annually for full-time employees (accrual prorated based on employment start date) and 6 company holidays per year.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">6% company contribution to a 401(k) Retirement Savings Plan each pay period, no employee contribution required.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">Employee discounts, tuition reimbursement, student loan refinancing and free access to financial counseling, education, and tools.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">Maternity support programs, nursing benefits, and up to 14 weeks paid leave for birth parents and up to 4 weeks paid leave for non-birth parents.</span></li>
</ul>
<p style="margin-bottom:11.0px;text-align:justify"> </p>
<p style="margin-bottom:11.0px;text-align:justify"><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif">For additional information and details regarding Grainger’s benefits, please click on the link below:</span></p>
<p style="margin-bottom:11.0px;text-align:justify"> </p>
<p style="margin-bottom:11.0px;text-align:justify"><span style="font-size:12.0pt;font-family:verdana, geneva, sans-serif"><a style="color:#467886;text-decoration:underline" href="https://experience100.ehr.com/grainger/Home/Tools-Resources/Key-Resources/New-Hire">https://experience100.ehr.com/grainger/Home/Tools-Resources/Key-Resources/New-Hire</a></span></p>
<p style="margin-bottom:11.0px;text-align:justify"> </p>
<p style="margin-bottom:11.0px;text-align:justify"><span style="font-family:verdana, geneva, sans-serif;font-size:12.0pt"><strong><span style="color:indianred">Grainger Benefits</span></strong></span></p>
<p style="margin-bottom:11.0px;text-align:justify"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">The pay range provided above is not a guarantee of compensation. The range reflects the potential base pay for this role at the time of this posting based on the job grade for this position. Individual base pay compensation will depend, in part, on factors such as geographic work location and relevant experience and skills. </span></p>
<p style="margin-bottom:11.0px;text-align:justify"> </p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">The anticipated compensation range described above is subject to change and the compensation ultimately paid may be higher or lower than the range described above. </span></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;line-height:115%;font-family:verdana, geneva, sans-serif">Grainger reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion at any time, consistent with applicable law.</span></p>
<p> </p>
<p> </p><p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:verdana, geneva, sans-serif">This position is not eligible for any form of sponsorship now or in the future. Individuals requiring sponsorship (e.g. OPT or H1B visa status) should not apply. Only individuals authorized to work in the United States now and for the foreseeable future will be considered for this position.</span><br><br></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:verdana, geneva, sans-serif"><span style="color:#ee0000">Position Details</span></span></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Grainger is looking for a Data Engineer for our Data and Analytics team. The Data Engineer will report to a Manager of Data Engineering. The Data and Analytics team's primary mission is to develop analytics by centralizing and integrating high-quality, trusted corporate data in a performant and scalable cloud platform. The Data Engineer will design and develop data pipelines and products in a modern-day, cloud environment. You will work with SMEs, architects, analysts, data scientists and others to build solutions that integrate data from many of our enterprise data sources. This is a Hybrid position requiring 50% of time onsite at either the Chicago, IL or Lake Forest, IL corporate offices. </span><br><br></p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:verdana, geneva, sans-serif"><span style="color:#ee0000">You Will</span></span></p>
<ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc">
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Pioneer a new way of thinking about Data Pipelines, Orchestration and Configuration at Grainger.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Design and build scalable data models in Snowflake to support analytics, reporting, and data science use cases</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Develop and manage end-to-end data pipelines using Apache Airflow for orchestration, scheduling, and monitoring workflows</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Write optimized, maintainable SQL for large-scale data processing, transformation, and validation</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Identify and design internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Build required tools for extraction, transformation and loading of data from data sources</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Build product features to allow self-service analytics</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Work with partners including data, design, product and executive teams and assisting them with data-related technical issues</span></li>
</ul>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:verdana, geneva, sans-serif"><span style="color:#ee0000">You Have</span></span></p>
<ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc">
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Bachelor's Degree or equivalent experience required</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">3+ years hands-on experience with Modern Data Engineering projects and practices (Airflow, Kafka, Spark, and python) required</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Successful track record in developing and automating large-scale, high-performance data engineering systems (batch and streaming).</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience with both scripting and system programming languages (Python and Scala).</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience with microservices including defining and testing APIs</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience architecting, developing, and deploying both offline and online feature stores</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience leading data integration efforts of data sources</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience partnering with internal departments (Supply Chain, Marketing, Finance, and HR) to establish requirements.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Develop junior team members through modern cloud-based development</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Translate requirements into technical requirements and produce required source-to-target data mappings.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Bring complex concepts into our organization and mentor others.</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Experience with advanced analytics and machine learning</span></li>
<li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:8.0pt;line-height:115%;font-size:12.0pt;font-family:verdana, geneva, sans-serif"><span style="font-family:verdana, geneva, sans-serif">Technology Experience Required: AWS, SQL, Python, Docker/Kubernetes, CI/CD, Git, Snowflake, dbt, Airflow</span></li>
</ul>
<p style="margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p> </p>
<p><span style="font-family:verdana, geneva, sans-serif;font-size:12.0pt"><em>We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex (including pregnancy), national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, protected veteran status or any other protected characteristic under federal, state, or local law. We are proud to be an equal opportunity workplace.</em></span></p>
<p style="margin-bottom:12.0px;margin-top:12.0px"> </p>
<p><span style="font-family:verdana, geneva, sans-serif;font-size:12.0pt"><em>We are committed to fostering an inclusive, accessible work 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, should you need a reasonable accommodation during the application and selection process, including, but not limited to use of our website, any part of the application, interview or hiring process, please advise us so that we can provide appropriate assistance.</em></span></p>