Data Engineer, Zoro

| Chicago

Position: Data Engineer
Location: Chicago (primary), Buffalo Grove (secondary)
Reports To: Director – Data Engineering

In the past six years, Zoro has grown from a group of 6 people working out of a 2,000 square foot building, offering fewer than 100,000 products to a group of 280+ working out of a 60,000+ square foot building, offering more than 2,000,000 unique products.

Imagine what you could help us achieve as a Data Engineer! 

The Data Engineer will collaborate with various other IT groups, business partners and external service providers and play a key role in the design, development and operations of our new analytics platform, the "Zoro Data Platform (ZDP)".

Job Responsibilities Include:

  • Participate in Requirements Gathering: work with key business partner groups (e.g. Product Mgt) and other Data Engineering personnel to understand department-level data requirements for the ZDP
  • Design Data Pipelines: work with other Data Engineering personnel on an overall design for flowing data from various internal and external sources into the ZDP
  • Build Data Pipelines: leverage standard toolset and develop ETL/ELT code to move data from various internal and external sources into the ZDP
  • Support Data Quality Program: work with Data QA Engineer to identify automated QA checks and associated monitoring & alerting to ensure ZDP maintains consistently high quality data
  • Support Operations: triage alerts channeled to you and remediate as necessary
  • Technical Documentation: leverage templates provided and create clear, simple and comprehensive documentation for your development
  • Key contributor to defining, implementing and supporting:
    • Data Services
    • Data Dictinary
    • Tol Standards
    • Best Practices
    • Data Lineage
    • User Training

Skills & Responsibilities:

  • Expert-level ETL designer/developer
  • Strong SQL
  • Strong Python
  • Structured & unstructured data expertise
  • Cloud environment development & operations experience (e.g. AWS, GCP)
  • Preference for candidates experienced with:
    • Google Cloud Platform (GCP) and associated services; e.g. BigQuery, GCS, Cloud Composer, Dataproc, Dataflow, Dataprep, Cloud Pub/Sub, Metadata DB, Data Studio, Datalab, other
    • Other important Zoro tools: Apache Airflow (scheduler), Bitbucket (version control), NewRelic (ops monitoring), Opsgenie (alert notification)
    • Real-time data replicatin/streaming tools
    • Data Mdeling
    • BI front-end tool development
  • Excellent verbal and written communications
  • Strong team player

Success Criteria

  • Strong analytical thinking and problem solving skillsSuperior communication and business-technical interaction skills
  • Positive, "get it done" attitude
  • Ability to multi-task and manage multiple activities with varying timelines

To qualify, you must possess the following skills:

  • Bachelor's degree in computer science, management information systems, or a related discipline
  • 5+ years hands-on ETL design/development experience
  • Key resource on team(s) that have delivered successful enterprise-level analytics platforms

 

Zoro is an Equal Opportunity Workplace and an Affirmative Action Employer.

 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Read Full Job Description

Technology we use

  • Engineering
  • Product
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • DjangoFrameworks
    • Google AnalyticsAnalytics
    • JIRAManagement

Location

One office is located in the West Loop, offering diverse eateries and steps away from nightlife! The other is in the northern suburb of Buffalo Grove.

An Insider's view of Zoro

How would you describe the company’s work-life balance?

We are driven and work hard, because we are growing like crazy! We are in this together because we want to be, not because we have to. On the flip side, I've never missed one of my kid's ball games, concerts, parent-teacher conferences, and when I take a vacation, I'm actually allowed to take it (of course, I'm available if you need me, team)! :-)

Adam

HR Leader

What does your typical day look like?

As a Financial Analyst with Zoro’s Finance team, my typical day starts with generating daily sales reports and sending it over to our headquarters. Then, I talk to business unit owners and gather information that would impact our financials. Zoro has an encouraging collaborative environment…everyone is easily approachable!

Margaret

Financial Analyst

How do you empower your team to be more creative?

Zoro has an awesome test and learn culture where you can try new things and see what works and what doesn't and, most importantly, learn from those lessons and drive improvements. We constantly look for ways to do that - whether it is tools, engagement, processes or empowerment. We share best practices, feedback and suggestions from our agents.

Dawn

Director, Customer Service

How do you collaborate with other teams in the company?

There’s a hunger for Design Thinking and making decisions based on customer feedback here at Zoro. Working on a scrum team as a UX Architect supports this directly but I’ll even get stopped in the hall by co-workers wanting to incorporate customer insights into their own projects. It comes from a culture of succeeding through collaboration.

Lex

UX Architect

What are Zoro Perks + Benefits

Zoro Benefits Overview

Very competitive package - beyond your base salary, we offer bonuses, a 401(k) match and additional 401(k) incentive contribution, a full-scope of medical/dental/vision/life insurance benefits, voluntary benefits, shuttle service, a bunch of free food (free coffee, soft drinks, snacks, and free meals from time-to-time). Our North Suburb office has a subsidized cafe inside our offices that is a breakfast/lunch spot and coffee bar, in addition to a game room, recreation area and a rock room... yes a rock room... bring your axe and rock out on a break!

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Optional Voluntary Benefit
Wellness Programs
Discount partnership with Sky Fitness.
Onsite Gym
Buffalo Grove equipped with workout bench, dumbells, free weights, a basketball court, badminton court, ping pong, air hockey, bags, golf net, outdoor volleyball, and we've even played quiddich!
Retirement & Stock Options Benefits
401(K)
401(K) Matching
3.5% contribution by Zoro on a bi-weekly basis (whether you contribute or not). Additional 3.5% target contribution based on annual company performance.
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
We've won a Dave Thomas award for having a solid adoption assistance program - that's pretty cool!
Vacation & Time Off Benefits
Generous PTO
Starting at 18 days per year with carryover option of up to 5 days.
Paid Volunteer Time
We like to give back to the local community. We have team builders focused on helping a variety of philanthropic organizations.
Paid Holidays
Zoro offers all employees paid time off to observe all major holidays.
Perks & Discounts
Casual Dress
We feature a range from shorts and t-shirts to those who embrace "Tie Tuesdays". Wear what makes you comfortable, but you may want to clean it up if you have an important customer in town!
Commuter Benefits
In our North Suburb office, we feature shuttle service to/from Buffalo Grove, Highland Park, and Deerfield stops. Also a commuter benefit program available as a voluntary benefit.
Company Outings
We've done many of these. From ball games to luaus to olympics to the zoo - Zoro finds ways to treat employees to lots of fun.
Game Room
Basketball, bags, driving range net, ping pong, badminton, video games, music room... we even played quiddich in our warehouse for our Harry Potter-themed Halloween event!
Stocked Kitchen
All offices feature coffee, soft drinks, sparkling water, tea, popcorn machine, random snacking opportunities, as well as an on-site cafe in our North Suburb office.
Some Meals Provided
Happy Hours
Sometimes happy hours provided by the company, but many team members get together outside of work because they want to, not because they have to!
Parking
Recreational Clubs
Softball, bowling, and dragon boat racing team... yes, dragon boat racing!
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
More Jobs at Zoro23 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Marketing
Operations
Product
Sales
Marketing
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Developer
new
Chicago
Finance
new
Northwest Suburbs
Data + Analytics
new
Chicago
Internships
new
Chicago
Operations
new
Northwest Suburbs
Product
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Developer
new
Northwest Suburbs
Sales
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Developer
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Finance
new
Northwest Suburbs
Product
new
Northwest Suburbs
Product
new
Northwest Suburbs
Developer
new
Chicago
Marketing
new
Chicago