EngineerJobs.io
← Back to all jobs

Job Description

Design and develop data integration pipelines that turn business needs into reliable data lake and data warehouse solutions.

Responsibilities

  • Develop data pipelines to integrate and transform data for analysis
  • Develop and sequence jobs and processes to move transformed data into data lake and data warehouse
  • Perform data profiling to understand source data characteristics and downstream impacts
  • Create and maintain data documentation
  • Measure and enforce data quality, including manual verification and development of automated data quality tests
  • Develop data models to represent business information
  • Support applied use of data through exploratory analysis and applied analytics work
  • Support scheduling, alerts, and ongoing use of data products and insights
  • Support analytic projects and data extracts to test and prove capabilities and evaluate usability
  • Demonstrate how analysts can use data to meet defined objectives
  • Run business meetings to understand data and business needs, capture agreement on business rules, and generate consensus on data product direction
  • Learn new technical concepts and software languages as needed
  • Provide support to other data users to enable solutions to business problems
  • Perform other duties as assigned

Requirements

  • Bachelor’s degree in Computer Science, Computer Information Systems, or a business degree with focus on data transformation or analysis; or equivalent work experience
  • Basic understanding of programming design and coding techniques
  • Familiarity with the systems development life cycle
  • Understanding of database technologies and query semantics
  • Experience with public cloud database technology, including one or more of: RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery
  • Experience programming in ETL or ELT technology
  • Understanding of data warehouse data model theory and techniques
  • Experience with Python
  • Minimum 2+ years professional experience developing software to solve business problems
  • Experience with data engineering system design and software implementation
  • Experience with all parts of the systems development life cycle
  • Experience leading and coordinating technical initiatives

Technologies

  • RedShift
  • SnowFlake
  • DataBricks
  • Azure Synapse
  • BigQuery
  • ETL
  • ELT
  • Python

Location & Work Setup

  • Cleveland, OH (hybrid)
  • Hybrid position with three-day per week onsite requirement
  • Candidates must be located in the Cleveland/Brooklyn area

Similar Jobs