Data Warehouse Specialist

University of Central Florida • Orlando, FL

1d

About The Position

The Data Warehouse Specialist at UCF’s Center for Distributed Learning helps design, build, and maintain the cloud‑based data systems that power digital teaching and learning. This role develops secure and high‑performing data warehouses, builds data models, and integrates information from systems like the SIS, LMS, and other online learning platforms to support reliable, scalable reporting. It requires operating at the highest technical level across all phases of data and data‑warehouse engineering activities, drawing on comprehensive knowledge of data science, statistics, database technologies, and strong coding and systems skills. This position works with large, complex datasets, including mining, validating, and transforming data, while monitoring and troubleshooting data pipelines to maintain smooth operations and service level agreements. Collaboration is central to this role, as this Specialist will partner with developers, domain experts, and stakeholders to create meaningful dashboards, visualizations, and insights, while also helping identify new technologies that advance online learning and strengthen UCF’s data environment. This is an Auxiliary (AUX) funded position. Employment is subject to availability of funding and may cease at the time funding for this employment is depleted.

Requirements

• Bachelor's Degree and 2+ years of relevant work experience, or an equivalent combination of education and experience pursuant to Fla. Stat. 112.219(6).

Nice To Haves

• Master’s degree in data science, data management, computer science, or a related field; AWS or cloud engineering certifications preferred.
• Strong programming skills in Python and SQL (MySQL/PostgreSQL), with experience in Go or R a plus.
• Hands‑on experience designing and managing cloud‑based data infrastructure in AWS, Azure, or Google Cloud.
• Experience building data models, schemas, and ETL pipelines, and working with large or complex datasets.
• Familiarity with data processing frameworks such as Spark or TensorFlow, along with strong data cleaning and transformation skills.
• Proficiency with relational and noSQL databases, including database design, performance optimization, and backup/recovery practices.
• Experience developing dashboards and visualizations using tools like Tableau, Power BI, Grafana, Redash, Superset, or Plotly.
• Strong analytical, problem‑solving, and communication skills, with the ability to collaborate effectively across technical and non‑technical teams.
• Familiarity with machine learning concepts is a plus.

Responsibilities

• Develop and maintain data infrastructure, data systems, analytics platforms, and applications to provide insights to stakeholders with data from different enterprise applications such as the student information system (SIS), learning management systems (LMS), and various online learning applications in support of digital teaching and learning at UCF.
• Designs, develops, implements, and maintains data warehouses in support of data mining applications to acquire, process, and ensure data quality that is optimized for performance and scalability.
• Design, build, and implement data models, schemas, database structures, and data systems integrations to provide insights and reporting requirements.
• Mines data from multiple data sources and renders into a comprehensive secured and scalable solution.
• Utilizes data extraction applications for data retrieval, analysis, quality designs, error-checking, and development of scheduled and ad-hoc queries.
• Monitors and troubleshoots data and database systems errors and bottlenecks proactively.
• Consults, defines, and manages service level agreements (SLAs) for all data sets in allocated areas of ownership.
• Creates/assists with the creation/implementation of insights, reports, dashboards, and data visualizations of data generated in our enterprise and custom applications for consumption by the developers and other stakeholders using specialized tools, and technologies related to data engineering needs/projects.
• Collaborates and works on data engineering and data analytics initiatives/projects by working with domain experts, software developers, and other pertinent university stakeholders.
• Research and recommend technical solutions for database and data engineering in support of online learning and its operations.

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