Senior Software Analyst: Office of Innovative Technologies - UTK

About the role

This position requires experience implementing Fabric’s Medallion architecture, row-level security, pipelines, dataflows, semantic models. Architect and implement Azure Active Directory (AAD) security and deliver access control for analytics/Power BI environments using row-level security.

Responsibilities

• Deliver scalable Power Platform + Microsoft Fabric solutions—data models, dashboards, and automation—with strong governance, performance tuning, and stakeholder partnership.
• Lead analysis and problem-solving efforts.
• Create new and modify existing database objects, analyze queries and perform tuning.
• Provide technical guidance and assistance to other staff members in my group, department, and campus user community.
• Aid in setting direction for the growth and maintenance of the campus data warehouse.
• Develop procedures for loading data from enterprise systems into the campus data warehouse, Power BI, and data marts from Oracle and SQL Server.
• Create packages, stored procedures, tables views, etc. to extract, transfer and load data into the campus data warehouse, Power BI, and data marts from Oracle and SQL Server.
• Design/Develop new programs/subsystems as directed by management within the parameters of UT standards and OIT group standards. This can include but is not limited to views, tables, programs, systems, data bases, security, and complex SQL code.

Requirements

• Education and Experience: Associate’s degree with 10 years of Application Development experience
• Knowledge, Skills, Abilities: Knowledge of Oracle, SQL Server, Power BI Platform, Excel, Word, Outlook, Sharepoint, etc.; significant knowledge of relational databases; ability to create packages, stored procedures, functions, triggers, tables, views, etc.; ability to analyze business requirements and systems to design effective automated solutions; ability to work independently, within a team and/or as an effective team lead to achieve results and meet deadlines; ability to apply effective oral and written skills to communicate with user and technical audiences; strong development skills and ability to reverse engineer source code; ability to mentor and support lower-level employees.

Preferred Qualifications

• Education: Bachelor’s degree with 8 years of Application Development experience
• Master’s degree with 6 years of Application Development experience
• Doctoral degree with 4 years of Application Development experience
• Experience: Higher Education experience
• Knowledge, Skills, Abilities: Argos, Oracle Fusion Data Intelligence, Oracle Report Writer OTBI, Oracle Data Integrator (ODI), facilitation skills to help move projects along as needed

Compensation and Benefits

UT market range: MR16
Anticipated hiring range: $90,000 - $106,000

Work Location

Location: Knoxville, TN
Hybrid - 2 days per week in Office, 3 days per week remote.

About the Department

IM&A provides data to our campus partners. We manage and maintain the data warehouse that houses Banner data. We manage and maintain college-level data marts in SQL Server, provide 14th day and end-of-term freeze events for State reporting and we provide point-in-time reporting, ad hoc, and dashboard reporting for our campus partners.