Enterprise Data & BI Architect II

University of Central Florida • Orlando, FL

9d • $80,000 - $92,000

About The Position

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 decision‑making 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. Position will be renewable up to a period of four years.

Requirements

• 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).

Nice To Haves

• 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.
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
• Excellent communicator with the ability to collaborate effectively with technical and non‑technical 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.

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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level