Data Engineer Job Northern Kentucky USA,Software Development

Location: Northern

UDR, Inc. is now hiring a Data Engineer to join our team.

This is a hybrid position. GENERAL SUMMARY OF DUTIES

Builds and operates the data pipelines and conformed data models that bring source data into UDR’s enterprise data platform. Primary accountability is ingestion through the conformed layer: source system connectivity, pipeline build and reliability, raw data landing, and the conformed models that downstream analytics depend on. Also contributes to curated modeling and semantic layer work under standards set by Analytics Engineering, providing overlap and coverage across a small team.

Works within the platform architecture, engineering, and deployment standards established by the Senior Data Platform Engineer, and partners with the Senior Snowflake Administrator, business analysts, software engineers, and quality assurance to deliver reliable, well-modeled data in support of UDR’s digital transformation applications.

ESSENTIAL FUNCTIONS

1--Build, operate, and maintain data ingestion pipelines that move data from internal systems, vendor systems, and third-party sources into the platform, including batch and incremental loads.

2--Develop and maintain source system connectivity and integrations, including file-based loads and API-based interfaces in both real-time and batch contexts.

3--Land and preserve raw source data in the platform so that original records remain traceable and reprocessable.

4--Design, build, and maintain conformed data models, including schema design, cleansing, deduplication, and standardization logic that produce a reliable foundation for curated modeling.

5--Implement and maintain orchestration, scheduling, and dependency management so that pipelines run in the correct order and downstream consumers receive data on time.

6--Triage and resolve pipeline failures, monitor pipeline and data health, and implement alerting that identifies issues before downstream consumers are affected.

7--Manage source schema changes, assessing downstream impact and coordinating updates with affected consumers before they break.

8--Write advanced SQL for complex transformations and optimize query and pipeline performance, including cost-aware design of transformation logic.

9--Implement automated data quality tests embedded in pipelines and models so that issues are surfaced before they reach curated layers.

10--Contribute to curated dimensional models and semantic layer development under standards set by Analytics Engineering, providing overlap and coverage across the team.

11--Contribute business context to entity definitions and conformance rules, working with Analytics Engineering, which owns those definitions.

12--Maintain documentation of data definitions, lineage, and transformation logic sufficient for another engineer or an auditor to trace a reported number back to its source.

13--Work within the platform architecture, coding, testing, and deployment standards established by the Senior Data Platform Engineer and help establish best practices for pipeline development and data modeling within those standards.

14--Provide code reviews on pipeline, transformation, and model code, applying established standards consistently and giving actionable feedback.

15--Support the Senior Snowflake Administrator on environment promotion, platform performance monitoring, and cost-aware workload design.

16--Apply version control practices to all pipeline, transformation, and model code, including branching, pull request workflows, and peer review.

17--Partner with business analysts on requirements, source to target mapping, and acceptance criteria for data work.

18--Support quality assurance on reconciliation and pipeline validation testing and resolve defects identified during release validation.

19--Participate in engineering design sessions and elevate design questions and platform gaps rather than working around them.

20--Ensure data accuracy, quality, and security across all pipeline, modeling, and documentation work.

21--Perform other duties as assigned or as necessary.

EDUCATION AND EXPERIENCE

1--Bachelor’s degree in computer science, data science, information systems, business with an information systems…