Press ENTER to skip to the job description.
Sr. Data Engineer

Sr. Data Engineer
IL, Buffalo Grove & Chicago

Job Description

Sr. Data Engineer

Position:              Senior Data Engineer
Location:             Chicago (primary), Buffalo Grove (secondary)
Reports To:         Director – Data Engineering

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. S/he will also provide direction to, and oversee various service providers and junior engineers’ activities.

Job Responsibilities Include:

  • Primary responsibility for 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 platform
    • 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 platform
    • Design Data Pipelines: wrk with other Data Engineering personnel on an overall design for flowing data from various internal and external sources into the platform
    • Build Data Pipelines: leverage standard tolset and develop ETL/ELT code to move data from various internal and external sources into the platform
  • Support Data Quality Program: work with Data QA Engineer to identify automated QA checks and associated monitoring & alerting to ensure enterprise 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


Apply Now