Data Engineer

Arc Energy Services•Rock Hill, SC

10d•$90,000 - $120,000•Hybrid

About The Position

ARC Energy Services is seeking a Data Engineer to join its Technology team in Rock Hill, South Carolina. The role builds and maintains the data platform and internal applications used by recruiting, payroll, operations, and quality teams to staff projects, track time and pay, and maintain field-worker qualifications and compliance. It reports to the head of Technology. The work is roughly split between data engineering and internal application development. The data foundation includes pipelines, data models, and integrations with systems such as QuickBooks, Salesforce, and HR, recruiting, and payroll platforms, using Databricks and PostgreSQL in Microsoft Azure. The role also develops features for an internal web portal using TypeScript and React; application development experience is a plus, and training will be provided. The Data Engineer works directly with colleagues who use the systems, takes ownership of systems relied on across the company, and uses AI coding assistants as part of daily development. The role requires reviewing, testing, and verifying work before it is released. The position follows a hybrid schedule, with regular in-office days at the Rock Hill office and remote work the rest of the week.

Requirements

Bachelor's degree in computer science, information systems, engineering, or a related field, or equivalent practical experience.
At least 2 years of professional experience in data engineering, analytics engineering, or software development.
Strong SQL skills, including complex joins, window functions, and query performance tuning.
Working proficiency in Python.
Experience designing relational data models and working with a relational database such as PostgreSQL.
Experience with at least one cloud data platform, such as Databricks, Snowflake, BigQuery, or Redshift.
Experience with Git and code review workflows.
Interest in learning front-end and back-end application development.
Strong written and verbal communication skills, including the ability to explain technical issues to non-technical users.
Ability to work on-site in Rock Hill, South Carolina, on a hybrid schedule.

Nice To Haves

Hands-on Databricks experience, including Delta Lake, Unity Catalog, and Databricks SQL.
Experience with PySpark or other distributed data processing.
Experience with TypeScript or JavaScript, React, or other web application development.
Experience with Microsoft Azure.
Experience integrating business systems through APIs, such as QuickBooks, Salesforce, or HR and payroll platforms.
Experience using AI coding assistants, such as Claude Code or GitHub Copilot, in day-to-day development.
Experience working with people, time, or pay data, such as HR, payroll, or workforce systems.
Background in energy, utilities, construction, manufacturing, or staffing.

Responsibilities

Build and maintain Databricks data pipelines that bring in data from business systems, including QuickBooks, Salesforce, and HR, recruiting, and payroll platforms.
Design and maintain data models and SQL views supporting reporting, analytics, and the internal portal.
Build and improve internal web portal features, including database queries, server logic, and user-facing screens.
Maintain data accuracy for hours, pay, worker qualifications, and matching individuals across multiple systems.
Investigate and resolve data and application issues reported by users, including time-sensitive payroll problems.
Make database and schema changes carefully, with testing and peer review before production release.
Use AI coding assistants in daily development and review, test, and verify their output before release.
Work with recruiting, payroll, operations, and quality teams to understand needs and develop working tools.
Document data sources, pipelines, and application features to support others.
Follow company security practices for sensitive employee and payroll data.