Senior GCP Data Engineer

Senior GCP Data Engineer RXO, Inc. - 3.2 Chicago, IL Job Details Full-time $130,000 - $150,000 a year 4 hours ago Benefits Paid jury duty Health savings account Paid holidays Disability insurance Dental insurance Flexible spending account Tuition reimbursement Paid time off Adoption assistance Employee assistance program Vision insurance Bereavement leave Life insurance Qualifications Data lake Full Job Description 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. Compensation for this role is $130,000-$150,000 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. What your day-to-day will look like: 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 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 What you'll need to excel: At a minimum, you'll need: 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) It'd be great if you also have: 1 year of logistics or transportation experience A Professional Data Engineer certification with Google Cloud Does this sound like you? Check out what else RXO has to offer.

Why Join Us:

Our 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 Our Culture Our values are the key to our unique culture and our ability to deliver for everyone we serve. We do great things when we are inclusive and work together. To perform with excellence, we learn from one another, value diverse perspectives, operate safely and build strong relationships. The Next Step Ready to join our team? We'd love to hear from you. Fill out an application now and join our talent community to learn about future opportunities. We are proud to be an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. All applicants who receive a conditional offer of employment may be required to take and pass a pre-employment drug test. The above statements are not an exhaustive list of all required responsibilities, duties, and skills for this job classification.