The University of Tennessee System Administration (UTSA) Information Technology Services (ITS) is seeking applications for the position of IT Software Developer within the Business Intelligence (BI) team with a focus on data modeling. The BI team facilitates the use of information for improved decision making throughout the University system.  An overview of the responsibilities and qualifications for the IT Software Developer position are listed below.

 

JOB SUMMARY: This position will require the successful candidate to engineer business intelligence systems with particular focus on ETL and data warehouse modeling. The candidate will employ technical, analytical, project management, and customer service skills to specify, design, implement, test, deploy, and maintain information systems that support business intelligence efforts. The candidate will also interact with, train, provide technical support to, and resolve issues for end users.

 

Additionally, the position will require learning about data and processes in various functional areas of the university such as student, finance, HR, research, facilities, alumni & development, and outreach & engagement.  It will require constant learning of both technical and non-technical tools, techniques, and processes.

 

We seek an individual who is capable of utilizing Microsoft tools to build ETL packages (using SSIS) as well as data warehouse models (using SSAS Tabular Models).  The ideal candidate is familiar with SAP (ECC and BW) and with Ellucian Banner.

 

Duties and Responsibilities:

·         Specifying, designing, implementing, testing, deploying, and maintaining business intelligence related information systems with large (e.g. enterprise/university-­‐wide) user bases.

·         Learning to use new tools and techniques such as new programming languages, new applications, new statistical methods, etc.

·         Supporting teammates by contributing ideas and perspectives, utilizing project management techniques, being flexible to changes in plans, and respecting the value of others and their contributions.

·         Providing training and service to technical and non-technical staff.

·         Seeking to improve the quality, impact, and efficiency of technologies and processes that contribute to the use of information in decision making.

·         Working on multiple projects and priorities simultaneously, meeting deadlines and communicating issues.

·         Being trustworthy with confidential information and working to ensure information security.

·         Earning the trust and confidence of colleagues and constituents by exhibiting professional behavior.

 

JOB SPECIFICATIONS:

 

Level

Education (minimum)

Related Experience (minimum)

I

Associate’s degree in a related field or equivalent relevant experience

One year of relevant experience

II

Associate’s degree in a related field or equivalent relevant experience

Two years relevant experience

III

Bachelor’s degree in a related field OR equivalent relevant experience

Four Years of relevant experience

 

 

 

 

 

 

 

 

 

 

 

Required Knowledge:

·         Strong understanding of relational database concepts, including schemas, tables, views, stored procedures, functions, and triggers.

·         Ability to read, understand, and write SQL, including DML (select, insert, update, delete statements) and DDL (create, alter, drop statements).

·         Ability to design and implement Kimball-style data warehouse models, preferably using Microsoft SQL Server Analysis Services.

·         Ability to design and implement extract-transform-load packages, preferably using Microsoft SQL Server Integration Services.

·         Ability to read, understand, and write at least one programming language besides SQL.

·         Understanding of software engineering concepts, including software development life cycle, requirements gathering, design methodologies (e.g., object oriented design), and programming languages and methodologies (e.g., DAX, ABAP, PL/SQL, Javascript, .Net, etc.).

·         Basic understanding of project management concepts.

·         Ability to learn and understand business processes employed in functional areas of the university.

·         Ability to utilize common productivity software such as Microsoft Office applications.

·         Organization, communication, analysis, and troubleshooting skills.

 

Preferred Knowledge:

·         Knowledge of and experience supporting SAP BW, including workflows, process chains, DSOs, BEX queries, cubes, portal, etc.

·         Knowledge of SAP’s plans regarding HANA.

·         Knowledge of Ellucian Banner.

·         Experience writing Microsoft DAX expressions.

·         Solid understanding of Microsoft SQL Server security.

·         Experience working in higher education, non-profit, or government, particularly in large organizations with multiple sites.

·         Experience working with large enterprise information systems (particularly Banner and SAP).

·         Knowledge of data discovery, data governance, and/or data stewardship concepts.

·         Understanding of business processes in one or more of the following areas: student, finance, HR, research, outreach & engagement, alumni & development, or facilities.

·         Knowledge of reporting systems

·         Knowledge of matrix algebra, set theory, discrete mathematics, graph theory, or statistics, particularly as applied to data analysis.

·         College level education preferred but not necessarily required.

 

 

 

Jay Eckles

Director of Business Intelligence

University of Tennessee

[log in to unmask]

865-974-3592