Data Engineer III

Grainger Businesses; Lake Forest (IL); On-site; USD 104,500 - 174,200; Full time

Benefits offered by this job

Medical, dental, vision, and life insurance

18 paid time off (PTO) days annually

6% 401(k) company contribution

Employee discounts and tuition reimbursement

Maternity support programs

Job summary

Grainger Businesses is seeking a Data Engineer for their Data and Analytics team in Lake Forest, Illinois. The position supports building scalable data solutions through analytics by integrating trusted corporate data in a performant cloud platform.

The ideal candidate possesses 3+ years of experience with data engineering tools and practices, including Airflow and Snowflake. This role requires a hybrid work model with onsite presence at corporate offices.

Compensation ranges from $104,500 to $174,200, with additional benefits such as medical insurance and paid time off.

Qualifications

• 3+ years hands-on experience with Modern Data Engineering practices like Airflow and Kafka.
• Experience in developing high-performance data engineering systems.
• Ability to mentor junior team members in cloud-based development.

Responsibilities

• Design and build scalable data models in Snowflake.
• Develop end-to-end data pipelines using Apache Airflow.
• Write optimized SQL for large-scale data processing.

Skills

Data Pipeline Design

Apache Airflow

SQL

Python

Snowflake

Kafka

Spark

Docker/Kubernetes

Education

Bachelor's Degree or equivalent experience

Tools

AWS

CI/CD

Git

dbt

Job description

Work Location Type

Hybrid

Req Number

331071

Compensation

The anticipated base pay compensation range for this position is $104,500.00 – $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.

Rewards and Benefits

With benefits starting on day one, our programs provide choice and flexibility to meet team members' individual needs, including:

• 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.
• 18 paid time off (PTO) days annually for full-time employees (accrual prorated based on employment start date) and 6 company holidays per year.
• 6% company contribution to a 401(k) Retirement Savings Plan each pay period, no employee contribution required.
• Employee discounts, tuition reimbursement, student loan refinancing and free access to financial counseling, education, and tools.
• 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.

For additional information and details regarding Grainger’s benefits, please click on the link below:

https://experience100.ehr.com/grainger/Home/Tools-Resources/Key-Resources/New-Hire

Grainger Benefits

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.

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.

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.

Position Details

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.

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.

You Will

• Pioneer a new way of thinking about Data Pipelines, Orchestration and Configuration at Grainger.
• Design and build scalable data models in Snowflake to support analytics, reporting, and data science use cases
• Develop and manage end-to-end data pipelines using Apache Airflow for orchestration, scheduling, and monitoring workflows
• Write optimized, maintainable SQL for large-scale data processing, transformation, and validation
• 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
• Build product features to allow self‑service analytics
• Work with partners including data, design, product and executive teams and assisting them with data‑related technical issues

You Have

• Bachelor's Degree or equivalent experience required
• 3+ years hands‑on experience with Modern Data Engineering projects and practices (Airflow, Kafka, Spark, and python) required
• 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.
• Experience with advanced analytics and machine learning
• Technology Experience Required: AWS, SQL, Python, Docker/Kubernetes, CI/CD, Git, Snowflake, dbt, Airflow

Equal Employment Opportunity

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.

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.