Data Warehouse Specialist

Center for Distributed Learning:

The Center for Distributed Learning (CDL) serves as the central agent for online learning at UCF, providing leadership in distance learning policies, strategies, and practices. Our teams consist of motivated developers, creators, and dreamers dedicated to exploring new technology to enhance teaching and learning at UCF.

The Opportunity:

The Data Warehouse Specialist at UCF's Center for Distributed Learning helps design, build, and maintain the cloudbased data systems that power digital teaching and learning. This role develops secure and highperforming 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 datawarehouse 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.

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.

Minimum Qualifications:

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

Preferred Qualifications:

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

• Handson experience designing and managing cloudbased 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, problemsolving, and communication skills, with the ability to collaborate effectively across technical and nontechnical teams.

• Familiarity with machine learning concepts is a plus.

Additional Application Materials Required:

In addition to your application, please include a cover letter, your most up-to-date resume, and a link to your digital portfolio.

Special Instructions to the Applicants:

Applicant must be authorized to work for any U.S. employer, as sponsorship is not available for this position now or in the future.

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.

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 13 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

Work Schedule

Type of Appointment

Expected Salary

Job Posting End Date

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.

If an accommodation due to a disability is needed to apply for this position, please call 407-823-1336 or email onac@ucf.edu.

For general application or posting questions, please email talent@ucf.edu.