Associate Data Engineer, Zoro at Zoro

| Chicago
Sorry, this job was removed at 6:30 a.m. (CST) on Saturday, May 1, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago

Company Summary:
Zoro.com is an eCommerce company that sells business supplies, equipment, and tools—but we’re much more than just a website. We’re a team of people who win and lose together (we prefer winning!). Since 2011, Zoro has been working hard to make it easy for our customers to purchase everything they need to make their businesses go. Zoro currently offers over 6 million products, fast and free shipping, no-hassle returns, and exceptional customer service. We’ve grown quickly in a short time, recently surpassing 400 team members and reaching annual revenue of over $500 million. Add to that our award-winning culture—we were named a Great Place to Work for 2019-20, among other accolades—and we think Zoro is a pretty amazing place to work and grow.


Primary Function:
Imagine what you could help us achieve as an Associate Data Engineer! 


The Associate Data Engineer will work under the guidance of other data professionals and collaborate with various IT groups, business partners and external service providers to design, develop, operationalize and support critical components of our cloud-native data platform, the “Zoro Data Platform (ZDP)”.


Duties and Responsibilities:

  • 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 ZDP
  • Design Data Pipelines: work with other Data Engineering personnel to design new data pipelines for flowing data from various internal and external sources into the ZDP using standard and other pre-established frameworks and interfaces
  • Build Data Pipelines: leverage standard toolset and ZDP-specific data frameworks to 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, enhancing and supporting:
    • Data Services
    • Data Dictionary
    • Tool Standards
    • Best Practices
    • Data Lineage
    • User Training

Skills & Responsibilities:

  • Competent programmer with focus on ELT/ ETL design/development using Python
  • Intermediate-level proficiency in SQL with demonstrable expertise in analytical data management tasks using SQL
  • Familiarity with Cloud environment development & operations (e.g. AWS, GCP)
  • Preference for candidates with prior working knowledge in:
    • Google Cloud Platform (GCP) and associated services; e.g. BigQuery, GCS, Cloud Composer, Dataproc, Dataflow, Dataprep, Cloud Pub/Sub, Data Catalog, Datalab other
    • Other important Zoro tools: Apache Airflow (scheduler), Bitbucket and git (version control), Stackdriver (ops monitoring), Opsgenie (alert notification), Docker
    • Real-time data replication/streaming tools
    • Data Modeling
  • Excellent verbal and written communications
  • Strong team player

Success Criteria

  • Strong analytical thinking and problem solving skills
  • Superior communication and business-technical interaction skills
  • Positive, “get it done” attitude with a high degree of ownership and responsibility
  • Ability to work with a high level of autonomy on critical tasks within an agile framework

To qualify, you must possess the following skills:

  • Bachelor’s degree in computer science, management information systems, or a related discipline
  • 2+ years hands-on ETL/ELT design/development experience or Masters degree on a related field
  • Key resource on team(s) / projects that have delivered successful analytics platforms / products


Final note: We share a commitment to our Zoro values – Win & Lose Together (We prefer winning!), Take Ownership, We Are Transparent, and Aspire to be Customer-Obsessed. Everything we do at Zoro is centered around delighting our customers. It's a natural extension of our company culture and how we care for each other. We believe when we act in ways that are consistent with these values, we can solve any technical challenge that lies ahead of us. As a Zoro employee, you can expect to work with smart, energetic people, learn something every day, and be valued for your perspective.


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
    • JavascriptLanguages
    • PythonLanguages
    • 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

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

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

Sr. Financial Analyst

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 sync
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
Unconscious bias training
Through period live trainings and webinars, it is important for all of our Zoro team members to collaborate, ideate, operate without bias!
Someone's primary function is managing the company’s diversity and inclusion initiatives
Mean gender pay gap below 10%
Diversity Employee Resource Groups
Zoro has an Inclusion Council comprised of a diverse group of team member volunteers across all levels within the organization to build awareness and strategize on DEI initiatives.
Hiring Practices that Promote Diversity
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!
Team workouts
We've offered yoga, kickboxing, mindfulness, walk-a-thons, and other sessions for our team members to explore ways to strengthen physical, emotional and spiritual wellness.
Mental Health Benefits
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
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
Beer on Tap
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 Zoro22 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Northwest Suburbs
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Northwest Suburbs
Data + Analytics
new
Northwest Suburbs
Product
new
Chicago
Operations
new
Northwest Suburbs
Developer
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Content
new
Chicago
Operations
new
Northwest Suburbs
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago