Press ENTER to skip to the job description.
Data Engineer

Data Engineer
IL, Buffalo Grove & Chicago

Job Description

Data Engineer

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

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, our own propriety platform.

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 platform.
  • Design Data Pipelines: work 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 toolset 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 our 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 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 tools: Apache Airflow (scheduler), Bitbucket (version control), NewRelic (ops monitoring), Opsgenie (alert notification)
    • Real-time data replicatin/streaming tools
    • Data Mdeling
    • BI front-end tool development
  • 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 design/development experience
  • Key resource on team(s) that have delivered successful enterprise-level analytics platforms


Apply Now