Role description

Data Engineer

Developer III - Software Engineering

The Data Engineer is a hands-on builder who executes against decomposed deliverables across the same end-to-end vertical owned by Senior Data Engineers on the team from ingestion, through modeling and transformation, into the Microsoft Fabric semantic layer and Power BI visualizations.

The opportunity:
• Lands data from authoritative sources into the team's unified ingestion framework using the patterns specified in the design.
• Implements the data contracts, models, and transformations sometimes independently and sometimes as specified by the Senior Data Engineer.
• Builds pipelines in Snowflake (including Iceberg tables) and/or Databricks (Delta Lake) per the storage pattern in the design.
• Implements testing, data quality checks, and reconciliation.
• Builds the Fabric semantic layer assets and Power BI visualizations called for in the design.
• Operates and maintains the data products after delivery.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:
• Bachelor's degree in Computer Science, Software Engineering, Information Management, or equivalent experience in field plus 4+ years of related work experience.
• Must be located in the United States.
• 4+ years of hands-on data engineering experience delivering production data pipelines in enterprise environments.
• Strong proficiency in SQL and Python, including PySpark and Spark SQL for distributed data transformation.
• Hands-on experience with Databricks including Delta Lake, Unity Catalog, and workflow orchestration.
• Hands-on experience with Snowflake at production scale.
• Working experience with Microsoft Fabric including OneLake; familiarity with Fabric IQ semantic layer concepts.
• Working experience building data visualizations and reports in Power BI.
• Experience implementing data ingestion pipelines using batch, CDC, API, or streaming patterns within a unified ingestion framework.
• Solid data modeling skills, including dimensional modeling and lakehouse modeling patterns at the physical implementation level.
• Experience implementing pipeline testing unit tests, integration tests, data quality checks, and reconciliation.
• Experience with DevOps practices for data pipelines Git, CI/CD, and automated testing.
• Good communication skills, with the ability to convey technical progress and ask clarifying questions of both technical leads and business stakeholders.
• Strong problem-solving skills and the ability to execute independently on well-defined technical work in a fast-paced, agile environment.
• PREFERRED QUALIFICATIONS
• Experience with Iceberg tables or other modern open table formats.
• Experience with HR data domains talent acquisition, workforce analytics, compensation, learning, performance, or people analytics.
• Familiarity with Workday, ServiceNow HR, or comparable HR systems of record as authoritative sources for analytics.
• Exposure to real-time streaming technologies including Kafka, Azure Event Hub, Delta Live Tables, or Spark Structured Streaming.
• Exposure to AI/ML pipelines or building data products that support ML workloads.
• Familiarity with legacy data platforms such as Teradata, Oracle, or SQL Server.
• Azure certifications or demonstrated experience with Azure-native data platform services.
• Familiarity with data privacy and regulatory compliance for HR data (GDPR, CCPA, employee data protection).

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Role Location: Washington

Compensation Range: $68,000-$102,000

Benefits

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), 10 paid holidays, and are eligible for paid bereavement leave and jury duty. They are eligible to participate in the Company's 401(k) Retirement Plan with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance, as well as the following Company-paid Employee Only benefits: basic life insurance, accidental death and disability insurance, and short- and long-term disability benefits. Regular employees may purchase additional voluntary short-term disability benefits, and participate in a Health Savings Account (HSA) as well as a Flexible Spending Account (FSA) for healthcare, dependent child care, and/or commuting expenses as allowable under IRS guidelines. Benefits offerings vary in Puerto Rico.

Part-time employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company's 401(k) Retirement Plan with employer matching.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company's 401(k) program with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance.

Part-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All US employees who work in a state or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.