Data Engineer - Compensation Systems

Sunbelt Rentals

Fort Mill (SC)

On-site

USD 113,000 - 156,000

Full time

5 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Health benefits

401(k) match

Volunteer time off

Disability insurance

Life & travel insurance

Tuition reimbursement

EAP

Service awards

Paid time off

Job summary

Sunbelt Rentals in Fort Mill, SC is seeking a data engineer to build and maintain robust data pipelines across Databricks, SQL Server, and Oracle ICM.

You will collaborate with Finance, HR, and Compensation teams to model and implement data flows, ensure data quality, and support compensation reporting with auditable processes.

A strong focus on data governance, security, and timely delivery is essential.

Qualifications

3+ years data engineering experience with SQL Server (T-SQL, stored procedures, performance tuning).
Databricks experience including Delta Lake and medallion architecture.
Python and SQL for pipeline development.
Experience with Azure cloud services (Azure Data Factory, Blob Storage, Key Vault).
Ability to translate complex rules into data models with attention to detail.
Comfort with sensitive data and governance considerations.

Responsibilities

Support day-to-day data ingestion, transformation, and pipeline maintenance across Databricks using Python and SQL.
Lead redesign of compensation calculation model in Oracle ICM, including data modeling and migration to medallion architecture.
Build and maintain Bronze/Silver/Gold pipelines sourcing from SQL Server, Oracle ICM, and other systems.
Design and manage Delta Lake tables ensuring data quality and performance.
Collaborate with Finance, HR, and Compensation to translate business rules into pipelines.
Integrate data from Workday and payroll systems for compensation reporting.
Monitor pipeline health, troubleshoot discrepancies, and implement fixes with accuracy.
Document data lineage and transformation logic for compliance and audits.
Partner with analysts and platform engineers to ensure accurate downstream reporting.

Skills

SQL (T-SQL)

Databricks

Python

Azure cloud

Data modeling

Data quality

Education

Bachelor's degree in CS/IT/Data Eng

Tools

Oracle ICM

Workday integration

Delta Lake

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.

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.

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):