Enterprise Application & Data Services Specialist

University of Dubuque; Dubuque (IA); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Tuition remission

Paid holidays

Vacation and sick time

Retirement match

Job summary

The University of Dubuque is seeking an Enterprise Application and Data Services Specialist to optimize data quality, support system integrations, and improve reporting and analytics across campus.

You will collaborate with departments, write and maintain SQL procedures, develop reports with Power BI and SSRS, and drive data-driven process improvements to help faculty and staff focus on students.

Qualifications

• Undergraduate degree required; Computer emphasis preferred or related business experience.
• Experience using report writers, preferably SQL Server Reporting Services and Power BI.
• Strong understanding and experience of relational database applications.
• Experience with TSQL in developing SQL scripts, procedures and functions.

Responsibilities

• Identify, develop and correct procedures for monitoring accuracy and quality of data.
• Work with stakeholders to educate, assist and update data and processes.
• Write and maintain stored procedures and functions to extract, transform and report on data.
• Provide recommendations and technical expertise regarding the use of all University systems and the data within said systems.
• Design, develop and generate reports to meet the needs of users across campus in a timely, efficient and accurate manner.

Skills

Strong technical aptitude

Analytical skills

Project management

Communication skills

Team collaboration

Education

Bachelor's degree

Tools

SQL Server

Power BI

SSRS

T-SQL

Job description

The University of Dubuque is a growing faith-based University thatis seeking an Enterprise Application & Data Services Specialist. The University of Dubuque offers acompetitive wage and an excellent benefits package includingtuition remission, paid holidays, vacation and sick time, and aretirement match.

Position Summary:

The Enterprise Application and Data Services Specialist will play a key role in helping the University of Dubuque to optimize dataquality and workflow processes, assist with system integrations, and improve reporting and analytical support. This role willcollaborate closely with and support individuals and departmentsacross campus to strengthen our use of technical systems andimprove efficiencies related to technology, data andprocesses.

Primary Responsibilities:

• Identify, develop and correct procedures for monitoringaccuracy and quality of data
• Work with stakeholders to educate, assist and update data andprocesses
• Write and maintain stored procedures and functions to extract,transform and report on data
• Provide recommendations and technical expertise regarding theuse of all University systems and the data within said systems
• Design, develop and generate reports to meet the needs of usersacross campus in a timely, efficient and accurate manner
• Provide data-driven insights by collecting, analyzing andreporting on trends to support strategic decision making
• Create forms and workflows to assist in improving processes anddata flow between and within departments across campus
• Automate processes to allow faculty and staff to spend moretime interacting with students versus performing arduous tasks andunneeded paperwork
• Be a partner that others across campus can rely upon to providehigh-quality assistance and insight regarding needs related tosystems, data and processes
• Understand proper integration and documentation of the use ofall software tools used to manage the University of Dubuque'sdata
• Keep abreast of upgrades to all systems and how these will helpdeliver the best data and most efficient process improvement to endusers
• Research and have knowledge of new technologies as well asinvestigate unused modules of current systems as potential ways to improve processes
• Document all procedures so they can be understood and supportedby other team members as well as end users
• Perform other duties as assigned in support of the University'smission

Position Skills and Abilities:

• Strong technical aptitude
• Proficient in problem-solving project management and analyticalskills
• Strong understanding of process improvement and workflowdevelopment
• Ability to manage several high-priority projects simultaneouslywhile producing quality work in a timely and accurate manner
• Excellent communication and collaboration skills
• Ability to develop, build and strengthen relationships tocreate partnerships with stakeholders from all areas of theuniversity
• Strong attention to detail
• Ability to investigate and understand processes to delivertimely, accurate and actionable solutions
• Strong problem solving and analytical skills
• Self-motivated and highly responsible
• Ability to work alone as well as collaborate with others

Requirements:

• Undergraduate Degree Required; Computer emphasis preferred orrelated business experience
• Experience using report writers, preferably SQL ServerReporting Services and Power BI
• Strong understanding and experience of relational databaseapplications
• Experience with TSQL in developing SQL scripts, procedures andfunctions

Affirmative Action/Equal Employment Opportunity Employer.

For moreinformation regarding the Jeanne Clery Act, please go to https://www.dbq.edu/SafetySecurity/JeanneCleryAct/