Type: Regular Exempt Staff. Permanent position starting as soon as possible. Pay grade 38, 40, or 42 depending on qualifications (see Job Specifications) Review of applications will begin on 7/12/2017 and continue until the position is filled. H1-B visa sponsorship not available for this position. Please provide a cover letter, resume, and names of references. 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.
Qualifications 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.
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. All qualified applicants will receive equal consideration for employment and admissions without regard to race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, or covered veteran status. Eligibility and other terms and conditions of employment benefits at The University of Tennessee are governed by laws and regulations of the State of Tennessee, and this non-discrimination statement is intended to be consistent with those laws and regulations. In accordance with the requirements of Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990, The University of Tennessee affirmatively states that it does not discriminate on the basis of race, sex, or disability in its education programs and activities, and this policy extends to employment by the University. Inquiries and charges of violation of Title VI (race, color, and national origin), Title IX (sex), Section 504 (disability), ADA (disability), Age Discrimination in Employment Act (age), sexual orientation, or veteran status should be directed to the Office of Equity and Diversity (OED), 1840 Melrose Avenue, Knoxville, TN 37996-3560, telephone (865) 974-2
Our primary mission is to move forward the frontiers of human knowledge and enrich and elevate the citizens of the state of Tennessee, the nation, and the world. As the preeminent research-based, land-grant university in the state, UT embodies the spirit of excellence in teaching, research, scholarship, creative activity, outreach, and engagement attained by the nation’s finest public research institutions.