Data Engineer - Orion - Onshore

A Fortune 100 retail client of Insight Global is looking to hire elite Data Engineers to join their Enterprise Data Warehouse Team. This team is responsible for supporting and providing all 12 company business units with the data they need to optimize their BUs and increase efficiency/profitability. This company has a centralized data organization and is Google's largest customer. There are over 200 people that report to this director, and his teams are responsible for working with over 170 petabytes of data within BigQuery. This Data Engineer will be responsible for legacy redesigns, net new projects within all 12 business units, and will be using cutting-edge technology for all of it. The ideal candidate for this role can vary in years of experience but must be able to think systemically about computer science instead of just being able to code. For example, there are a hundred ways to cut code, but these candidates must understand what the trade-offs are of doing it each way and be

able to explain why they would decide which way they chose to cut it. We are looking for someone with a growth mindset who is able to reflect on their prior work and think of what they would do differently next time to improve it. The overarching goal of this team is not just build a data set, but to build one that is robust using processes and techniques that will allow to work just as well on day 100 as it would on day 1., * either Retail or Supply Chain/Distribution Center domain experience

• Supply Chain/Distribution Center = Labor management, Warehouse Management Systems (WMS), Inventory, Transportation
• Retail = Workforce management, labor optimization/planning, brick & mortar retail, store attribution, building services/facilities/HVAC/maintenance tickets/work orders/etc.
• Strong written + verbal communication (will be asking these resources to work directly with project management, product management, stakeholders to gather requirements, work through testing/validations, etc. They need to be able to drive the project forward, work independently and be okay interacting with end-users and key stakeholders)

• Ability to speak to the outcomes they have driven within their domains through their queries

• SQL expert

• ETL/BI development experience
• Jenkins (ideally 2+ years working experience in data engineering)

• GCP

• BigQuery

• GCS

• Python

• Dataform and/or DBT

• Must be a systemic-thinker - Experience supporting projects tied to order fulfillment, delivery, customer experience, inventory, transactions, expenses, discounts, COGS, LTL, etc.

• Candidates coming from a newer company in the online space such as Chewy, Amazon, Wayfair, Netflix (doesn't have to be a Fortune100; a legit startup within this space is fine too)

• T.A. (Teaching Assistant) experience in grad school

• Experience working with really high streaming/high velocity/fancy technologies (seeing that in action at a decent-sized company is great background experience)

$40/hr to $60/hr. - Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.