Data Engineer - Compensation Systems

Sunbelt Rentals, Inc.

Fort Mill (SC)

On-site

USD 113,000 - 156,000

Full time

15 hours ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, Dental and Vision plans

401(k) Match

Volunteer time off

Disability insurance

Life and Travel insurance

Tuition Reimbursement Options

Employee Assistance Program (EAP)

Length of Service Awards

Job summary

Sunbelt Rentals, Inc. is seeking a data engineer to own end-to-end data pipelines for compensation and HR datasets.

You will work across SQL Server, Oracle ICM, Workday, and Azure, building robust Bronze/Silver/Gold layers and ensuring data accuracy for sensitive compensation data. Ideal candidates bring 3+ years in data engineering, expert SQL Server and Databricks skills, and a strong ability to model complex business rules into reliable data structures.

Qualifications

3+ years of data engineering experience with strong SQL Server (T-SQL) skills.
Proficient in Databricks, Delta Lake, and medallion architecture patterns.
Strong Python and SQL for pipeline development.
Experience with Azure cloud services (e.g., Data Factory, Blob Storage).
Ability to translate complex business rules into robust data models.
Comfort handling sensitive data with auditability and compliance.

Responsibilities

Support day-to-day data ingestion, transformation, and pipeline maintenance across Databricks using Python and SQL.
Lead redesign of compensation calculation model within Oracle ICM; model data and migrate 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 for compensation and HR datasets.
Collaborate with Finance, HR, and Compensation to translate business rules into pipelines.
Integrate data from Workday and payroll systems where relevant to reporting and reconciliation.
Monitor pipeline health, troubleshoot data discrepancies, and implement fixes for accuracy.
Document data lineage and transformation logic for compliance and audits.
Partner with analysts and platform engineers to ensure accurate downstream reporting.

Skills

SQL Server

Databricks

Python

SQL

Azure

Data modeling

Data pipelines

Data quality

Attention to detail

Education

Bachelor's Degree in CS/IT/Data Eng

Tools

Delta Lake

dbt

Workday integration

Varicent

Oracle ICM

Azure Data Factory

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. Please visit https://www.sunbeltrentals.com/careers/ for more information on our benefits and to join our Talent Network.

Sunbelt also provides a comprehensive benefits package to its full-time employees. This package includes:

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

You will become eligible for benefits on the first of the month following 30 days from your start date. Sunbelt offers team members the following paid time off from work, subject to Sunbelt’s policies (unless specified in a collective bargaining agreement):