Enterprise Data & BI Architect II

Wucf Tv; Orlando, Northern (FL, KY); Hybrid; USD 88,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

Paid time off

Retirement savings options

Employee discounts

Education assistance

Job summary

University of Central Florida is seeking an Enterprise Data & BI Architect II to design and support enterprise analytics and data engineering for the Office of Research Vienna Project. The role emphasizes scalable pipelines, data modeling, and governance in a cloud environment.

Responsibilities include modeling, SQL/ETL, and collaboration with stakeholders to deliver accurate BI solutions, with a focus on data quality and documentation. This is a visiting, renewable position based in Orlando.

Qualifications

• Bachelor's or Master's degree and 2+ years of relevant experience.
• Experience with cloud data platforms (Azure, Fabric) and Power BI in enterprise analytics.
• Strong SQL, Python/PySpark, and DAX for complex datasets.

Responsibilities

• Design, develop, and support scalable data pipelines and analytics solutions.
• Maintain data models and semantic layers using star schemas for reporting.
• Ensure data quality, governance, and compliance across platforms.
• Collaborate with stakeholders to translate requirements into technical data solutions.
• Document data flows, transformation logic, and runbooks.

Skills

Data architecture

SQL

Python/PySpark

Power BI

DAX

Microsoft Fabric

Azure

Education

Bachelor's or Master's degree

Tools

Microsoft Fabric

Power BI

Azure

SQL

Job description

## Enterprise Data & BI Architect IIApply: Orlando, FL (Main Campus): Full time: Posted Today: End Date: September 28, 2026 (10 days left to apply): R114189**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. 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 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.**Additional Application Materials Required:** In addition to your applications, please provide your most up-to-date resume.**Special Instructions to the Applicants:*** All applicants must be authorized to work for any U.S. employer. Visa sponsorship is not available for this position, and the university cannot accommodate H‐1B transfers or employment-based visa processing for individuals currently sponsored by another employer.* The anticipated salary range for this position is $87,500-$95,000. The final salary will be determined based on the candidate's qualifications, experience, and internal equity considerations.* 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.**Are you ready to unleash YOUR potential?** As a next-generation public research university and Forbes-ranked top employer in Florida, we are a community of thinkers, doers, creators, innovators, healers, and leaders striving to create broader prosperity and help shape a better future. No matter what your role is, when you join Knight Nation, you’ll play an integral role at one of the most impactful universities in the country. You’ll be met with opportunities to connect and collaborate with talented faculty, staff, and students across 12 colleges and multiple campuses, engaging in impactful work that makes a positive difference. Your time at UCF will provide you with many meaningful opportunities to grow, you’ll work alongside talented colleagues on complex projects that will challenge you and help you gain new skills, and you’ll have countless rewarding experiences that go well beyond a paycheck.**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