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.
·
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.
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.
·
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
865-974-3592