Enterprise Data & BI Architect II

University of Central Florida; Orlando (FL); On-site; USD 68,000 - 83,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Paid time off

Retirement savings

Employee discounts

Education assistance

Job summary

University of Central Florida is hiring an Enterprise Data & BI Architect II to design and support enterprise analytics and data engineering for the Office of Research Vienna Project. This visiting, renewable role focuses on scalable data pipelines, data models, and semantic layers across university reporting needs.

The ideal candidate will have Azure/Fabric/Power BI expertise, strong SQL/Python skills, and a background in enterprise cloud environments.

Qualifications

• Bachelors or masters with 2+ years of relevant experience or equivalent.
• Experience with modern cloud data platforms (Azure, AWS).
• Hands-on Fabric and Power BI in an enterprise analytics environment.
• Strong SQL, Python/PySpark, and DAX skills for data modeling.
• Experience delivering BI solutions, including pipelines and semantic models.
• Education sector experience is desirable.
• Certification: Microsoft Fabric DP-700 is preferred.

Responsibilities

• Designs, develops, and maintains scalable data pipelines and analytics using Azure and Fabric.
• Builds data models with relational, dimensional, and star schemas for reporting.
• Develops SQL queries and ETL/ELT logic across multiple data sources.
• Maintains Fabric environments, access configs, and deployment practices.
• Implements analytics standards, governance, and documentation.
• Collaborates with stakeholders to translate requirements into data solutions.
• Creates validation tests and runbooks for operational readiness.

Skills

Data architecture

SQL

Python / PySpark

DAX

ETL / ELT

BI solutions design

Education

Bachelor's or Master's degree and 2+ years of relevant experience

Tools

Microsoft Fabric

Power BI

Microsoft Azure

AWS

Job description

Analytics & Integrated Planning:

The Analytics and Integrated Planning (AIP) division brings expertise in strategic data planning, advanced analysis, reporting, and institutional research to the university, with the explicit purpose of leveraging institutional data and enhancing analytics to enable robust decision-making across the institution.

The Opportunity

UCF's Analytics & Integrated Planning (AIP) team is hiring an Enterprise Data & BI Architect II to design the data and analytics in support of the Office of Research Vienna Project. This position is responsible for designing, developing, and supporting enterprise analytics and data engineering solutions that enable institutional and departmental reporting, analysis, and decisionmaking across the university.

This is a visiting and renewable position. Visiting positions are based on circumstances, such as funding sources, which control the length of time for which the position is available. Visiting positions are renewable for up to four years. This project is estimated to last two years.

Responsibilities:

Data Engineering and Analytics Development:

• Designs, develops, and implements scalable data pipelines and analytics solutions using Microsoft Azure and Microsoft Fabric platforms.




• Builds, optimizes, and maintains data models utilizing relational, dimensional, and star schemas to support reporting, analytics, and semantic layers.




• Develops and optimizes SQL queries and transformation logic to support ETL and ELT processes across multiple data sources.

Platform Support and Standards Adherence:

• Supports and maintains Microsoft Fabric environments, including workspace organization, access configurations, and deployment practices across development, test, and production environments.




• Implements and follows established analytics standards, development best practices, and architectural guidelines to ensure consistency and maintainability.




• Works closely with architects and other engineers to align solutions with institutional platform standards.

Performance Optimization and Troubleshooting:

• Monitors and tunes performance of data pipelines, models, and analytics workloads to ensure reliability and efficiency.




• Troubleshoots and resolves data pipeline failures, data model issues, and integration problems to maintain platform stability and data reliability.




• Provides data-related technical support and troubleshooting for user-reported issues.

Data Quality and Compliance:

• Performs data profiling, validation, and data quality assessments to ensure accuracy, consistency, and adherence to business rules and compliance with UCF data policies.




• Supports performance tuning, metadata management, data lineage, data security, and governance controls across analytics platforms.




• Contributes to metadata documentation, data lineage artifacts, and governance.

Business Collaboration and Solution Delivery:

• Collaborates with business stakeholders to gather, define, document, and refine requirements for analytics and business intelligence solutions.




• Translates business requirements into technical data solutions, including semantic models and reporting datasets.




• Develops and executes testing strategies and validation criteria to ensure data accuracy and functional correctness of deliverables.

Documentation and Project Support:

• Supports analytics projects through task estimation, development activities, and milestone tracking.




• Creates and maintains technical documentation, including data flow diagrams, transformation logic, and operational runbooks.

Minimum Qualifications

Bachelor's or Master's degree and 2+ years of relevant experience; or an equivalent combination of education and experience pursuant to Fla. Stat. 112.219(6).

Preferred Qualifications

• 2+ years of experience as a data architect or data engineer, preferably within enterprise cloud environments.




• Experience with modern cloud data platforms, especially Microsoft Azure, AWS, or other enterprise cloud environments.




• Hands-on experience with Microsoft Fabric and/or Power BI in an enterprise analytics environment; Fabric experience is strongly preferred.




• Strong command of SQL, Python/PySpark, and DAX for querying, modeling, and validating complex datasets.




• Demonstrated experience designing and delivering data analytics or BI solutions, including data pipelines, semantic models, and dimensional data structures.




• Experience working in higher education is highly desirable.




• Certifications: Microsoft Certified: Fabric Analytics Engineer Associate (DP-700).

The most successful candidates may possess the following qualities:

• Excellent communicator with the ability to collaborate effectively with technical and nontechnical stakeholders, including consultants and internal partners.




• Proactive, self-directed contributor who can take initiative in a fast-moving project environment.




• Strong attention to detail and accuracy, with the ability to validate complex datasets and ensure high-quality, consistent outputs across analytics and documentation.

Working at UCF has its perks!UCF offers:

• Benefit packages, including Medical, Dental, Vision, Life Insurance, Flexible Spending, and Employee Assistance Program




• Paid time off, including annual and sick time off and paid holidays




• Retirement savings options




• Employee discounts, including tickets to many Orlando attractions




• Education assistance




• And more...For more benefits information, view the UCF Employee Benefits Guide.

Dive into our Total Rewards Calculator to discover the diverse selection available to you, giving you a glimpse into the benefits that together shape your comprehensive rewards package at UCF.

Unless explicitly stated on the job posting, it is UCF's expectation that an employee of UCF will reside in Florida as of the date the employment begins.

Department

Analytics & Integrated Planning

Work Schedule

Monday - Friday 8:00AM - 5:00PM

Type of Appointment

Fixed Term (Fixed Term)

Expected Salary

$75,809.00 to Negotiable

Job Posting End Date

09-28-2026-12-00-AM

The University of Central Florida is an equal opportunity employer that does not discriminate against any employee or applicant for employment based on any characteristic protected by law. The University maintains programs for protected veterans and individuals with disabilities in accordance with all applicable federal and state laws.

As a Florida public university, the University of Central Florida makes all application materials and selection procedures available to the public upon request.

UCF is proud to be a smoke-free campus and an E-Verify employer.

For general application or posting questions, please email [e-mail].

If an accommodation due to a disability is needed to apply for this position, please email [e-mail].