Share this Job

Sr Data Engineer, Zoro

Date: Aug 4, 2019

Location: CHICAGO, IL, US, 60603-4013

Company: ZORO

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.

 


Job Segment: Database, Information Systems, Computer Science, SQL, Quality Assurance, Technology

Find similar jobs: