Sr Data Engineer, Zoro
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 3 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 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
- Conceptual, logical and physical design (database, ODS, aggregates, etc.)
- Database administration
- Capacity analysis & management
- MDM Lead
- Identify key domains that’d benefit from an MDM approach (e.g. Product, Customer), along with best data sources & necessary attributes, and integrate into the ZDP
- Define governance strategy with associated roles & responsibilities (e.g. Data Steward, Quality Specialist)
- Define & implement Policies & SOPs
- Monitor operations, develop and report quality metrics to key stakeholders
- Data Pipeline development:
- 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
- Define Best Practices and Guidelines for other Data Engineering team members
- Lead the team in developing new technical skills necessary for cloud-native data engineering platform
- Explores new tech
- Shares and documents learnings
- Productionalizes proof of concepts
Skills & Responsibilities:
- Expert-level data modeler (back-end and semantic layer)
- Expert-level ETL/ELT 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)
- Excellent verbal and written communications
- Strong team player
- Working knowledge of eCommerce data a plus
- Prior experience with Git, Terraform, GCP Deployment Manager, CICD, Docker, Kubernetes, Apache Airflow, Apache Beam, Apache Spark experience is 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 with a high degree of autonomy, ownership and responsibility
- 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
- 10+ years hands-on data warehouse-data modeling experience
- 10+ years hands-on database admin/ops experience
- 10+ years hands-on ETL/ELT design/development experience
- Key resource on team(s) that have delivered successful enterprise-level analytics platforms
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.