Data Engineer - Compensation Systems

Sunbelt Rentals; Fort Mill (SC); On-site; USD 113,000 - 156,000; Full time

Benefits offered by this job

Health, Dental and Vision plans

401(k) Match

Tuition Reimbursement Options

EAP/Length of Service Awards

Job summary

Sunbelt Rentals is seeking a data engineer to support ingestion, transformation, and maintenance of enterprise data pipelines across Databricks and SQL Server. You will redesign compensation models within ICM, implement medallion architecture, and ensure data quality across HR-related datasets.

Responsibilities include collaborating with Finance and HR, translating business rules into robust data models, and integrating Workday/payroll data where relevant.

Qualifications

• 3+ years of data engineering experience with SQL Server (T-SQL, stored procedures, performance tuning).
• Expert Databricks experience including Delta Lake and medallion architecture.
• Proficiency in Python and SQL for pipeline development.
• Experience with Azure cloud services (Azure Data Factory, Blob Storage, Key Vault).
• Ability to translate complex business logic into data models and pipelines.

Responsibilities

• Support day-to-day data ingestion, transformation, and pipeline maintenance across Databricks using Python and SQL.
• Redesign compensation calculation model within Oracle Incentive Compensation Management (ICM) including data modeling and migration to medallion architecture.
• Build and maintain Bronze/Silver/Gold layer pipelines sourcing from SQL Server, Oracle ICM, and other systems.
• Design and manage Delta Lake tables ensuring data quality and performance across compensation datasets.
• Collaborate with Finance, HR, and Compensation teams to translate business rules into auditable data pipelines.

Skills

SQL

Databricks

Python

Azure

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

Delta Lake

Azure Data Factory

Workday

dbt

Job description

Join Our Team! Sunbelt Rentals strives to be the customer's first choice in the equipment rental industry. From pumps to scaffolding to general construction tools, we aim to be the only call needed to outfit a job site with the proper equipment. Not only do we offer a vast fleet that ranks among the best in the industry, we pair it all with a friendly and knowledgeable staff. Our employees are our greatest asset, and although we present a comprehensive equipment offering, our expertise and service are what truly distinguish us from the competition. We pride ourselves on investing in our workforce and offer competitive benefits, as well as extensive on-the-job training for all eligible employees. As a highly successful national company, we are constantly looking for talented individuals to support our growth. If you are interested in pursuing a rewarding career, we invite you to review our opportunities!

Job Description Summary

Key Responsibilities

• Support day-to-day data ingestion, transformation, and pipeline maintenance across Databricks using Python and SQL
• Lead the redesign of the compensation calculation model within Oracle Incentive Compensation Management (ICM), including data modeling, rule logic translation, and migration to the medallion architecture
• Build and maintain Bronze/Silver/Gold layer pipelines that source from SQL Server, Oracle ICM, and other enterprise systems
• Design and manage Delta Lake tables, ensuring data quality, consistency, and performance across compensation and HR-adjacent datasets
• Collaborate with Finance, HR, and Compensation teams to translate business rules into reliable, auditable data pipelines
• Integrate data from Workday and payroll systems where relevant to compensation reporting and reconciliation
• Monitor pipeline health, troubleshoot data discrepancies, and implement fixes with an emphasis on accuracy given the sensitivity of compensation data
• Document data lineage and transformation logic clearly, given the compliance and audit requirements of compensation systems
• Partner with analysts and platform engineers to ensure downstream reporting and dashboards reflect accurate, timely data

Required Qualifications

• 3+ years of data engineering experience, with expert-level proficiency in SQL Server (T-SQL, stored procedures, performance tuning)
• Strong hands-on experience with Databricks, including Delta Lake and medallion architecture patterns
• Solid proficiency in Python and SQL for pipeline development
• Experience with Azure cloud services (Azure Data Factory, Blob Storage, Key Vault, or similar)
• Ability to work with complex, rules-based business logic (e.g., compensation calculations, incentive structures) and translate it into technical data models
• Strong attention to detail and comfort working with sensitive, high-scrutiny data domains

Preferred Qualifications

• Experience with Oracle Incentive Compensation Management (ICM) or similar incentive/compensation platforms
• Familiarity with Varicent or other sales performance management (SPM) tools
• Experience integrating with Workday, payroll systems, or other HRIS platforms
• Exposure to Varicent OIC (Oracle Integration Cloud) or Azure-native integration services (Logic Apps, Function Apps, Azure API Management)
• Familiarity with applying LLMs to data engineering workflows (e.g., code generation, documentation, data mapping/reconciliation assistance)
• Databricks Certified Data Engineer Associate or Professional certification
• Experience with dbt or similar transformation frameworks
• Bachelors Degree in Computer Science, Information Technology, Data Engineering, or equivalent experience.

Physical Demands

Must be able to bend, squat, crouch and/or reach and lift up to 25 pounds or more, as required by the job. Some Sunbelt jobs may require driving for long periods of time, loading and unloading heavy equipment, performing work in extreme weather conditions including rain, wind, or excessive temperatures and/or night and weekend work. All duties must be performed according to Sunbelt's safety policies and guidelines. Reasonable accommodations may be made to comply with ADA/ADAAA. The above description covers the principal duties and responsibilities of the job. The description shall not, however, be construed as a complete listing of all miscellaneous, incidental or similar duties which may be required from day to day.

Sunbelt Rentals is an Equal Opportunity Employer — Minority/Female/Disabled/Veteran and any other protected ground.

Base Pay Range: $113,342.00 - 155,845.80 Starting rate of pay may vary based on factors including, but not limited to, position offered, location, education, training, and/or experience.

Benefits Package

• Health, Dental and Vision plans
• 401(k) Match
• Volunteer time off
• Short-term and long-term disability
• Accident, Life and Travel insurance, as well as flexible spending
• Tuition Reimbursement Options
• Employee Assistance Program (EAP)Length of Service Awards

Paid Time Off

• 12-25 vacation days depending on years of service
• 5 sick days
• 6 holidays
• 2 half day holidays
• 2 floating holidays
• 1 inclusion day
• 1 volunteer day

Sunbelt Rentals supports service members. Veterans encouraged to apply.

A leader in the equipment rental industry, Sunbelt Rentals is constantly advancing the idea of how a company can best serve its customers, communities and the planet. With over 1,000 locations across North America and an expansive portfolio of products and services, we deliver solutions to support any job. Sunbelt's extensive fleet exceeds and includes general construction equipment, industrial tools, pumps, power & HVAC, trench shoring, scaffolding, remediation & restoration equipment, and more. At Sunbelt Rentals, we place enormous value on the welfare and commitment of our employees as well as the superior level of service they provide for our customers. All our employees benefit from extensive on-the-job training, which is amongst the best in the industry. Our advancement opportunities are why many of our staff remain with us throughout their careers. Sunbelt Rentals means diversity, teamwork, recognition for exceptional performance, and room to grow! We are proud to offer the following benefits: Medical/Dental/Vision Insurance 401(k) Retirement Plan - US RRS Plan – CAN Paid Parental Leave Paid Holidays and Paid Time Off Tuition Reimbursement And many more Designed to serve distinct customer segments requiring a high level of technical expertise, Sunbelt Rentals offer a highly diversified product mix, as well as trained experts. Climate Control Services Industrial Services Tools & Equipment Oil & Gas Services Power & HVAC Services Pile Driving Services Pump Solutions Scaffold Services Remediation and Restoration