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 UCFs 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 UCFs 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:

Bachelors 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:

• Masters 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 youll play an integral role at one of the most impactful universities in the country. Youll 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 youll work alongside talented colleagues on complex projects that will challenge you and help you gain new skills and youll 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 moreFor 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 UCFs 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 or email .

For general application or posting questions please email .