Sr Data Engineer, Zoro

| Chicago

Position: Senior 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 Senior Data Engineer! 

The Senior Data Engineer will collaborate within Data Engineering and with other IT groups, business partners and external service providers, to play a key role in building, maintaining and supporting our new analytics platform, the “Zoro Data Platform (ZDP)”. S/he will also provide direction to, and oversee various service providers and junior engineers’ activities.

Job Responsibilities Include:

  • Primary responsibility for Zoro Data Platform (ZDP) data model ongoing design & development
    • Cnceptual, logical and physical design (database, ODS, cubes, etc.)
    • Metadata/semantic layer
    • Database administratin
    • Capacity analysis & management
  • MDM Lead
    • Identify key dmains that’d benefit from an MDM approach (e.g. Product, Customer), along with best data sources & necessary attributes, and integrate into the ZDP
    • Define gvernance strategy with associated roles & responsibilities (e.g. Data Steward, Quality Specialist)
    • Define & implement Plicies & SOPs
    • Mnitor operations, develop and report quality metrics to key stakeholders
  • Data Pipeline development:
    • Participate in Requirements Gathering: wrk 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: wrk 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 tolset 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 data modeler (back-end and semantic layer)
  • Expert-level ETL designer/developer
  • Strong database administration and operations experience & proficiency
  • Strong SQL
  • Structured & unstructured data expertise
  • Cloud environment development & operations experience (e.g. Google Cloud Platform/GCP experience a plus)
  • Experience developing in and using modern BI front-end tools
  • Excellent verbal and written communications
  • Strong team player
  • Working knowledge of eCommerce data a plus
     

Success Criteria:

  • Expert knowledge of data modeling concepts and data relationships
  • Advanced Analytical Thinking and Problem Solving skills
  • Solid experience in architecture, advanced reporting and dashboards
  • Strong SQL skills and experience with performance tuning are required
  • “Get it done” attitude
  • Superior Communication and Business-Technical Interaction skills

To qualify, you must possess the following skills:

  • Bachelor’s degree in computer science, management information systems, or a related discipline
  • 15+ years hands-on data warehouse-data modeling experience
  • 15+ years hands-on database admin/ops experience
  • 10+ 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!

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Someone's primary function is managing the company's diversity and inclusion initiatives
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.
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
We've won a Dave Thomas award for having a solid adoption assistance program - that's pretty cool!
Company sponsored family events
Acme co. sponsors family oriented events Semi-annually.
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.
Paid Sick Days
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!
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications
More Jobs at Zoro24 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Project Mgmt
new
Chicago
Product
new
Northwest Suburbs
Finance
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Internships
new
Chicago
Finance
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Marketing
new
Chicago
Project Mgmt
new
Northwest Suburbs
Project Mgmt
new
Chicago
Design + UX
new
Chicago
Sales
new
Northwest Suburbs
Operations
new
Northwest Suburbs
Operations
new
Chicago
Operations
new
Northwest Suburbs
Sales
new
Northwest Suburbs