Data Engineer, Zoro
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 450+ working out of a 60,000+ square foot building, offering more than 3,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 Dictionary
- Tool Standards
- Best Practices
- Data Lineage
- User Training
Skills & Responsibilities:
- Strong ELT/ 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 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
- 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/ELT 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.