Data Engineer

Hub Group; Oak Brook (IL); On-site; USD 87,000 - 107,000; Full time

Job summary

Hub Group in Oak Brook, IL seeks a Data Engineer to design and deliver operational and analytical data solutions for our business users and partners. You will interpret requests, map data, and build data pipelines to ensure data is accessible in our BI and Data Warehouse environment, collaborating with analysts and IT teams.

You will participate in all phases from requirements through deployment in an agile setting, translating data needs into logical models, ensuring data quality, and

Qualifications

• Bachelor’s degree in Data Engineering, Computer Science, or related discipline; 2 years of relevant experience required.
• Master’s degree in Data Engineering, Computer Science, or related discipline preferred.

Responsibilities

• Prepare, create, and deliver data solutions for BI/DW stakeholders.
• Interpret requests, map data, and build data pipelines for BI/DW access.
• Collaborate with analysts and IT teams to align Data Warehouse solutions with business needs.
• Contribute to all phases of system delivery: requirements, design, development, testing, deployment, and maintenance.
• Work with ETL/BI architects to translate data requirements into logical data models and ensure quality.

Skills

Python

Scala

SQL

Education

Bachelor’s degree in Data Engineering, Computer Science, or related discipline

Master’s degree in Data Engineering, Computer Science, or related discipline

Tools

Amazon Redshift

Google BigQuery

Snowflake

SQL Server

Oracle

dbt

SSIS

Coalesce

Informatica

Job description

Responsibilities:

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:

This position requires a 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.

This position also requires experience with:

• Coding: programming languages such as Python, Scala, and SQL is essential.
• Data Warehousing: Experience with data warehousing solutions like Amazon Redshift, Google BigQuery, or Snowflake.
• Database Systems: Knowledge of relational (e.g., SQL Server, Oracle) and non-relational databases (e.g., MongoDB).
• ETL Tools: ETL (Extract, Transform, Load) tools like dbt, SSIS, Coalesce, or Informatica.
• Cloud Platforms: Experience with cloud services like AWS, Azure, or Google Cloud Platform
• Operating Systems: operating systems like Linux and Windows.

Annual Base Salary: $96,928 / year + bonus eligibility

Hub Group is the premier, customer-centric supply chain company offering comprehensive transportation and logistics management solutions. Keeping our customers’ needs in focus, Hub Group designs, continually optimizes and applies industry-leading technology to our customers’ supply chains for better service, greater efficiency and total visibility. As an award-winning, publicly traded company (NASDAQ: HUBG) with $5 billion in revenue, our 6,000 employees and drivers across the globe are always in pursuit of "The Way Ahead" - a commitment to service, integrity and innovation. We believe the way you do something is just as important as what you do. For more information, visit www.hubgroup.com.