Data Warehouse Architect III

General Description/Primary Purpose

The Data Warehouse Architect III is a strategic and technical role responsible for designing, implementing, and optimizing enterprise data solutions. This position combines data engineering, database development, and data model design responsibilities to deliver a robust, scalable, and governed data platform that supports advanced analytics and reporting.

Job Function

Enterprise Data Architecture

Oversee enterprise data architecture, including medallion layers (Bronze → Silver → Gold).

Define standards for semantic models and star schemas in gold layers.

ETL/ELT Development

Develop and maintain ETL/ELT pipelines to populate Bronze → Silver → Gold layers.

Implement transformations, incremental loads, and performance optimizations for analytics.

Semantic Layer & BI Consistency

Build semantic layers that unify business logic, metrics, and hierarchies.

Ensure consistency across BI tools and reporting platforms.

Data Modeling

Design conceptual, logical, and physical data models.

Translate business requirements into structured schemas for reporting.

Governance & Quality

Enforce data quality, lineage, and compliance standards.

Collaborate with governance teams to maintain metadata and security policies.

Core Skills

Star/Snowflake schema design for gold layers.

Dimensional modeling and aggregation for reporting.

Defining business-friendly metrics, hierarchies, and relationships.

Building pipelines for medallion architecture (Bronze → Silver → Gold).

Core Technologies

Data Processing: Spark, Delta tables

Programming: SQL, Python

Advanced Analytics: Machine Learning integration

Cloud Platforms: Azure (Data Factory, Synapse, Databricks)

Deployment: Containers (Docker/Kubernetes)

Marginal Functions

Advises higher management on current trends in information technology that affect the direction and scope of online education systems. 

Frequent and moderate level of internal business contact with personnel in functional areas for the purpose of determining system functional requirements. 

Attends meetings of Information Technology Services staff; utilizes staff resources when situations require additional expertise.

Assist in the preparation & delivery of workshops and training programs.

During declared campus emergencies, this position may be required to perform specific job-related duties at a designated off campus location or place of residence.  

Required Qualifications

Master's and 4+ years of relevant experience or Bachelor's degree and 6+ years of relevant experience. Or an equivalent combination of education and experience pursuant to Fla. Stat. 112.219.

Statement(s) of Understanding

This position requires a background check. In conjunction with the University's policy, this position may also require a credit check.

The holder of this position is designated as a “Responsible Employee” pursuant to their role under Title IX. Therefore, the incumbent must promptly report allegations of sexual misconduct, sexual violence, and child sexual abuse by or against any student, employee, contractor, or visitor to the University’s Title IX Administrator or any divisional Title IX Coordinator

 Equal Opportunity

The University of North Florida (UNF) is committed to providing an inclusive and welcoming environment for all who interact in our community. In building this environment, we strive to attract students, faculty and staff from a variety of cultures, backgrounds and life experiences. The University of North Florida does not commit or permit discrimination or harassment on the basis of genetic information, race, color, religion, age, sex, disability, marital status, national origin, or veteran status in any educational, employment, social, recreational program or activity that it offers. In addition, UNF will not commit or permit retaliation against an individual who reports discrimination or harassment or an individual who cooperates in an investigation of an alleged violation of university regulation.

Carnegie

UNF is a Carnegie Community Engaged Institution. This designation celebrates the University’s collaboration with community partners from the local to the global level. It reflects UNF’s mission to contribute to the public good and prepare educated, engaged citizens.