Data Warehouse Architect III

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. At the University of North Florida, we believe in empowering our employees to thrive both professionally and personally. Whether you’re advancing research, supporting students, or driving innovation, you’ll be part of a dynamic community that values collaboration, growth, and meaningful impact. Discover a career that makes a difference—right here in Jacksonville. Start searching our current job opportunities and find your next career move at UNF! NOTICE: At this time, UNF cannot consider candidates who require H‑1B visa sponsorship, regardless of current visa status. Current UNF employees (Faculty & Staff) should view opportunities via the Workday UNF Jobs Hub. Current UNF students should view opportunities via the Workday UNF Student Jobs Hub. Visit our Employment Opportunities page to learn more about UNF and how you can enjoy more with UNF employment.