Data Engineer - Compensation Systems

sunbeltrentals; 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

Volunteer time off

Short-term and long-term disability

Job summary

Sunbelt Rentals is seeking a data engineer to support day-to-day data ingestion, transformation, and pipeline maintenance across Databricks using Python and SQL. You will design and maintain Bronze/Silver/Gold data layers sourced from SQL Server, Oracle ICM, and other enterprise systems.

This role collaborates with Finance, HR, and Compensation teams to translate business rules into auditable pipelines, monitor data quality, and ensure accuracy of compensation data.

Qualifications

• 3+ years of data engineering experience with SQL Server (T-SQL, stored procedures, performance tuning).
• Hands-on Databricks experience with Delta Lake and medallion architecture patterns.
• Proficient in Python and SQL for pipeline development.
• Experience with Azure cloud services (Azure Data Factory, Blob Storage, Key Vault).
• Able to translate complex, rules-based business logic into technical data models.
• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field.

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, incl. 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 across compensation datasets.
• Collaborate with Finance, HR, and Compensation to translate rules into auditable pipelines.
• Integrate data from Workday and payroll systems where relevant to reporting and reconciliation.
• Monitor pipeline health and troubleshoot discrepancies with attention to sensitive data.
• Document data lineage and transformation logic for compliance and audits.

Skills

SQL

Python

Databricks

SQL Server

Azure

Education

Bachelor's Degree in CS/IT/Data Engineering

Tools

Azure Data Factory

Blob Storage

Key Vault

Varicent

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.

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-