The Opportunity :

The SQL Data Engineer and BI Developer II will work in the Graduate and Research Information Technology (GRIT) office to assist the enterprise business intelligence for the College of Graduate Studies (CGS) and the Office of Research to help stakeholders improve business decisions. The candidate will provide enterprise coding, development, and support on data logic and structures from various data sources/systems, perform deep dive data analysis and visualization, and be the subject matter expert for GRIT business-related data.

Responsibilities:

• Utilize strong functional data knowledge to support GRIT business units by knowing what data is available and how to best source that data.

• Design, develop, maintain, and analyze a suite of Business Intelligence Reports & Services. This includes any ad hoc report requests. Use SQL, SSIS, SAS, SSRS, Power BI, and other available reporting, data retrieval tools, and data analytics tools.

• Debug and fix all data-related issues.

• Support Connected Data Sources and Systems, including Peoplesoft, Slate, GFS, Huron, Argis, Aurora, etc.

• Provide help for technical support for the database servers including security, maintenance, upgrades, backup, recovery, and optimization.

• Provide help with technical support and training to GRIT, as well as other departments that require the use of Online systems, including Student & Research databases, Reporting Tools, and PeopleSoft database.

Minimum Qualifications :

Bachelor’s degree and 2 years of relevant experience; or High School Diploma (or equivalent) and 6 years of relevant work experience in lieu of degree. Or an equivalent combination of education and experience pursuant to Fla. Stat. 112.219.

Preferred Qualifications :

• Ability to develop SQL stored procedures, functions, views, tables, indexes, etc., preferably using Microsoft SQL Server and SQL Server Management Studio.

• Demonstrated advanced proficiency in writing complex, highly optimized queries across large data sets.

• Experience working on large data analysis projects.

• Expertise with Big Data and SQL.

• Develop interactive visualizations and dashboards to present data insights effectively.

• Have a solid grasp of advanced SQL techniques for querying, transformation, and performance optimization.

• Ability to establish priorities, work independently, and proceed with objectives with minimal supervision.

• Experience developing, modifying, or managing Business Intelligence and Analytics tools such as Microsoft Reporting Services, Microsoft Power BI, Tableau, etc.

Special Instructions to the Applicants:

Classification Title: Business Intelligence and Analytics Specialist II

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 

• Flexible work environment 

• And more…For more benefits information, view the UCF Employee Benefits Guide

  click here
  .

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.

#LI_TP1

#LI_HYBRID

Department

Work Schedule

Type of Appointment

Expected Salary

Job Posting End Date

Equal Employment Opportunity Statement:

The University of Central Florida is an Equal Opportunity/Affirmative Action Employer including Disabled/Vets. Click on

The UCF affirmative action plans for qualified individuals with disabilities and protected Veterans are available for inspection in the Office of Institutional Equity, Monday through Friday, from 9:00 a.m. to 5:00 p.m., upon request.

As a Florida public university, UCF makes all application materials and selection procedures available to the public upon request. 

The University of Central Florida is proud to be a smoke-free campus and an E-Verify employer.