This position will work with a Senior Data Analyst to convert our existing Argos reporting platform to Power BI, architect and secure Azure data lakes for Power BI reporting, use Github for deployment and version control.
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.
Assist 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.
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.

Associate’s degree with 10 years of Application Development experience
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
Applicants must be legally authorized to work in the United States on a full-time basis without need now or in the future for sponsorship for employment-based visa status.

Senior Software Analyst – Office of Innovative Technologies

Key skills