Associate Data Engineer

UST; Frisco (TX); On-site; USD 68,880 - 82,656; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) with employer matching

Paid time off + holidays

Job summary

UST in Frisco, TX / Seattle, WA is seeking an Associate Data Engineer to learn the full HR analytics data engineering vertical, from ingestion to modeling, through to the Microsoft Fabric semantic layer and Power BI visualizations.

You will land source data into the ingestion framework, implement data models in Snowflake and Databricks, build the semantic layer in Fabric, and create Power BI reports while applying data quality checks and unit tests.

Qualifications

• Bachelor's degree in CS/SE or related field with 1+ year of work or internship experience.
• Proficiency in SQL and Python, with at least 1 year of hands-on data work.
• Familiarity with Spark (PySpark/Spark SQL) and cloud data platforms like Databricks or Snowflake.
• Experience with BI tools such as Power BI and basic data modeling concepts.

Responsibilities

• Execute components of solution designs under guidance to deliver production-grade code.
• Land source data into the ingestion framework using established patterns.
• Implement data models and transformations in Snowflake and Databricks per design.
• Apply medallion architecture and engineering standards to all work.
• Build semantic layer components in Microsoft Fabric per specifications.
• Develop Power BI visualizations and reports following BI standards.
• Implement unit tests and data quality checks for assigned work.

Skills

SQL

Python

Spark

Data modeling

ETL/ELT

Git / CI/CD basics

Communication

Problem solving

Learning mindset

Education

Bachelor's degree in CS/SE or related field

Tools

Databricks

Snowflake

Power BI

Microsoft Fabric

Job description

Associate Data Engineer

Associate Data Engineer (Developer I – Software Engineering) is an early‑career engineer learning the full HR Analytics data engineering vertical hands‑on from ingestion, through modeling and transformation, into the Microsoft Fabric semantic layer and Power BI visualizations.

Responsibilities

• Execute assigned components of solution designs handed off by Senior and Data Engineers, delivering production‑grade code under senior engineer guidance.
• Land source data into the team’s unified ingestion framework using the patterns specified in the design.
• Implement assigned data models and transformation logic in Snowflake (including Iceberg tables) and Databricks (Delta Lake, Unity Catalog) per the design.
• Apply medallion (bronze, silver, gold) architecture and the team’s engineering standards to all work, including naming conventions, documentation, and code review practices.
• Build assigned components of the semantic layer in Microsoft Fabric (Fabric IQ, OneLake) per the design specifications.
• Build assigned Power BI visualizations and reports following the design specifications and the team’s BI standards.
• Implement unit tests, data quality checks, and reconciliation for assigned work.

Qualifications

• Graduation Year: 2024, 2025 or 2026
• GPA: 3.5
• Experience: 1+ years
• Bachelor’s degree in Computer Science, Software Engineering, Information Management, or equivalent experience in the field plus 1+ years of related work experience, OR equivalent demonstrated experience through internships, bootcamps, or self‑directed project work.
• Must be located in the United States.
• 1+ years of hands‑on data engineering or software engineering experience, including internships and academic project work that demonstrate production‑quality engineering habits.
• Working proficiency in SQL and Python.
• Exposure to Spark (PySpark or Spark SQL) for distributed data transformation, or strong willingness and demonstrated ability to learn it quickly.
• Exposure to cloud data platforms Databricks, Snowflake, or comparable with a willingness to develop hands‑on depth.
• Familiarity with at least one BI tool (Power BI preferred, Tableau or similar acceptable).
• Understanding of fundamental data engineering concepts: data modeling, ETL/ELT, data quality, source‑to‑target mapping.
• Familiarity with Git, code review practices, and basic CI/CD concepts.
• Good communication skills able to ask clarifying questions, communicate progress clearly, and learn from feedback.
• Strong problem‑solving instincts, curiosity, and the discipline to deliver well‑defined work to a high standard.
• Eagerness to learn the full vertical from ingestion through visualization, and to take on broader ownership over time.

Preferred Qualifications

• Hands‑on coursework, internship, or project experience with Databricks (Delta Lake) or Snowflake at any scale.
• Hands‑on coursework, internship, or project experience with Microsoft Fabric, OneLake, or Power BI.
• Exposure to Iceberg tables or other modern open table formats.
• Exposure to HR data domains: talent acquisition, workforce analytics, compensation, learning, performance, or people analytics.
• Familiarity with Workday, ServiceNow HR, or comparable HR systems of record.
• Exposure to streaming technologies (Kafka, Azure Event Hub, Delta Live Tables, or Spark Structured Streaming).
• Exposure to AI/ML pipelines or building data products that support ML workloads.
• Azure certifications (Azure Fundamentals, Data Engineer Associate) or working toward them.
• Familiarity with data privacy concepts (GDPR, CCPA) and HR data handling considerations.

Location & Compensation

Role Location: Frisco, TX / Seattle, WA

Compensation Range: $50 to $60/hr

Visa Sponsorship

Visa sponsorship is not available for this role.

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.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other applicable characteristics protected by law. We will consider qualified applicants with arrest or conviction records in accordance with state and local laws and "fair chance" ordinances.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.