Data Warehouse Architect III

University of North Florida Alumni Association•Jacksonville, FL

23h•$95,000

About The Position

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.

Requirements

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).
Data Processing: Spark, Delta tables
Programming: SQL, Python
Advanced Analytics: Machine Learning integration
Cloud Platforms: Azure (Data Factory, Synapse, Databricks)
Deployment: Containers (Docker/Kubernetes)
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.
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

Responsibilities

Oversee enterprise data architecture, including medallion layers (Bronze → Silver → Gold).
Define standards for semantic models and star schemas in gold layers.
Develop and maintain ETL/ELT pipelines to populate Bronze → Silver → Gold layers.
Implement transformations, incremental loads, and performance optimizations for analytics.
Build semantic layers that unify business logic, metrics, and hierarchies.
Ensure consistency across BI tools and reporting platforms.
Design conceptual, logical, and physical data models.
Translate business requirements into structured schemas for reporting.
Enforce data quality, lineage, and compliance standards.
Collaborate with governance teams to maintain metadata and security policies.
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.