Senior GCP Data Engineer

RXO, Inc. • Chicago, IL

3d • $130,000 - $150,000 • Onsite

About The Position

Accelerate your career at RXO RXO is a leading provider of transportation solutions. With cutting-edge technology at the center, we're revolutionizing the industry with our massive network and commitment to finding solutions for every challenge. We create more efficient ways for shippers and carriers to transport goods across North America. The role may also be eligible for bonus or commission pay. Actual compensation may vary due to factors such as experience and skill set. As a Senior GCP Data Engineer at RXO, you’ll play a role in accomplishing the following team goals: data centralization, data governance and data integrity. You’ll lead component design and development, work with data science, development and business analytics teams to design scalable data solutions ensuring quality and performance. You’ll use your data engineering expertise to enable our company to derive insights, perform analytics and make decisions on the modern data solutions you’ll help design, build and maintain. Please note this position is fully onsite at our Chicago, IL office, located at 2545 West Diversey, Chicago, IL 60647.

Requirements

• Bachelor of Science in Information Technology, Computer Science or a related technical field or equivalent related work or military experience
• 7 years of experience as a data engineer or comparable business intelligence role
• 5 years of experience of Datalake architecture and implementation experience
• 5 years of experience with relational databases such as MS-SQL, Postgres or Oracle
• 4 years of experience with NoSQL databases such as Capella or MongoDB
• 5 years Python experience or similar
• Proficiency with Cloud offerings primarily with GCP (Azure or AWS is acceptable)

Nice To Haves

• 1 year of logistics or transportation experience
• A Professional Data Engineer certification with Google Cloud

Responsibilities

• Design and build large-scale automated and cost-efficient data pipelines that are integrated across multi-platform and disparate data sources using GCP native services (e.g., BigQuery, Dataflow, Dataproc)
• Make key architectural decisions related to data modeling, storage, real-time processing and orchestration
• Work with multi statement complex queries and enhance performance or able to troubleshoot issues related to performance
• Implement scalable, reusable and efficient data frameworks that ensure data quality, data integrity and performance consistently
• Assist in establishing data governance, quality and lineage practices using tools like Data Catalog, Data Loss Prevention (DLP) or Cloud Audit Logs.
• Create and maintain intermediate to advanced terraform scripts
• Mentor junior and mid-level engineers, conduct code reviews and provide technical guidance on best practices
• Translate business requirements into technical design documents and implementation plans
• Participate in support rotation and proactively identify issues while implementing issue resolutions as appropriate
• Monitor and optimize GCP resources to manage costs effectively
• Stay updated with latest GCP services and features
• Evaluate and recommend new tools and technologies to improve data engineering practices

Benefits

• Competitive pay
• Paid time off includes: up to 8 holidays, up to 2 floating Diversity Days, Hourly: Earn up to 13 days PTO/ Salary: Earn up to 15 days PTO, up to 40 hours bereavement leave, up to 16 hours volunteer time, jury duty, at least 2 weeks family bonding leave, up to 40 hours prenatal care leave
• 401(k) retirement plan with up to 5% company match
• Insurance: health, prescription, dental, vision, basic and supplemental life, short and long-term disability, accidental death and personal loss, business travel, legal services, ID theft, accident, critical illness, hospital indemnity
• Employee Assistance Program (EAP)
• Tuition reimbursement, adoption assistance
• Tax-Advantaged Accounts: Health Savings Account, Health Care Flexible Spending Account, Dependent Care Flexible Spending Account, Commuter Spending Account
• Health Reimbursement Arrangement

What This Job Offers

• Job Type: Full-time
• Career Level: Senior