Data Engineer — Delta Lake & Databricks for Compensation

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

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

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.