Data Warehouse Architect III

Job Type: time type Full time

Job Number: JR102720

Location:
Jacksonville

Department

Data Management Platforms

Compensation

$95,000.00 to Negotiable Annual

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.