Enterprise Application & Data Services Specialist

Workable; Dubuque (IA); On-site; USD 70,000 - 95,000; Full time

Job summary

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

You will collaborate with departments to design efficient data workflows, automate processes, and deliver timely, actionable insights to support strategic decisions.

The role requires strong technical skills, robust communication, and the ability to manage multiple high-priority projects.

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 T-SQL 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.
• Provide data-driven insights by collecting, analyzing and reporting on trends to support strategic decision making.
• Create forms and workflows to assist in improving processes and data flow between and within departments across campus.
• Automate processes to allow faculty and staff to spend more time interacting with students versus performing arduous tasks and unneeded paperwork.

Skills

Technical aptitude

Analytical skills

Process improvement

Project management

Communication

Stakeholder relations

Attention to detail

Self-motivation

Education

Undergraduate degree

Tools

SQL Server Reporting Services

Power BI

SQL (T-SQL)

Job description

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

Primary 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
• Provide data-driven insights by collecting, analyzing and reporting on trends to support strategic decision making
• Create forms and workflows to assist in improving processes and data flow between and within departments across campus
• Automate processes to allow faculty and staff to spend more time interacting with students versus performing arduous tasks and unneeded paperwork
• Be a partner that others across campus can rely upon to provide high-quality assistance and insight regarding needs related to systems, data and processes
• Understand proper integration and documentation of the use of all software tools used to manage the University of Dubuque’s data
• Keep abreast of upgrades to all systems and how these will help deliver the best data and most efficient process improvement to end users
• Research and have knowledge of new technologies as well as investigate unused modules of current systems as potential ways to improve processes
• Document all procedures so they can be understood and supported by other team members as well as end users
• Perform other duties as assigned in support of the University’s Mission

Position Skills and Abilities:

• Strong technical aptitude
• Proficient in problem-solving project management and analytical skills
• Strong understanding of process improvement and workflow development
• Ability to manage several high-priority projects simultaneously while producing quality work in a timely and accurate manner
• Excellent communication and collaboration skills
• Ability to develop, build and strengthen relationships to create partnerships with stakeholders from all areas of the university
• Strong attention to detail
• Ability to investigate and understand processes to deliver timely, 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 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