Data Engineer

Hub Group•Oak Brook, IL

About The Position

Responsible for the preparation, creation, and delivery of operational and analytical data solutions for our business users/partners. Interpret various requests, map data, and create/develop necessary data pipelines to ensure that data is accessible in our Business Intelligence and Data Warehouse (BI/DW) environment. Support and partner with data analysts and business users to understand/interpret their business reporting and analytic needs and align Data Warehouse and Business Intelligence solutions to meet those needs. Contribute to all phases of system delivery, including requirements, design, development, training, data conversion, testing and maintenance to achieve the successful development and implementation of the customer's business need. Work within the Enterprise Data Warehouse delivery team which includes architects, other developers, and Bl administrators to build, test and roll-out Data Warehouse projects and enhancements in an agile environment. Independently create deliverables such as functional requirements, logical data models and supporting data mapping documentation that are easily understood, thorough, and accurate. Work closely with other IT teams and subject matter experts regarding source system applications to better understand the business functionality and data content for utilization downstream in the Data Warehouse. Work closely Business Intelligence/Data Warehouse experts (such as ETL and Bl architects) to translate data requirements into logical data models that provide optimal Bl solutions. Provide quality assurance support for Data Warehouse projects and enhancements to ensure that Data Warehouse provides reliable data. Investigate, diagnose, and resolve any data quality issues reported by the business.

Requirements

Bachelor’s degree in Data Engineering, Computer Science, or related discipline and 2 years of relevant experience as a Data Engineer or similar role working in a Data Warehouse or similar environment OR a Master’s degree in Data Engineering, Computer Science, or related discipline.
Experience with programming languages such as Python, Scala, and SQL.
Experience with data warehousing solutions like Amazon Redshift, Google BigQuery, or Snowflake.
Knowledge of relational (e.g., SQL Server, Oracle) and non-relational databases (e.g., MongoDB).
Experience with ETL tools like dbt, SSIS, Coalesce, or Informatica.
Experience with cloud services like AWS, Azure, or Google Cloud Platform.
Experience with operating systems like Linux and Windows.

Responsibilities

Preparation, creation, and delivery of operational and analytical data solutions.
Interpreting requests, mapping data, and creating/developing data pipelines for BI/DW.
Supporting and partnering with data analysts and business users to understand reporting and analytic needs.
Contributing to all phases of system delivery: requirements, design, development, training, data conversion, testing, and maintenance.
Working within the Enterprise Data Warehouse delivery team in an agile environment.
Independently creating deliverables like functional requirements, logical data models, and data mapping documentation.
Collaborating with IT teams and subject matter experts to understand source system applications and data content.
Translating data requirements into logical data models with BI/DW experts.
Providing quality assurance support for Data Warehouse projects and enhancements.
Investigating, diagnosing, and resolving data quality issues.