Enterprise Application & Data Services Specialist

University of Dubuque; Asbury (IA); On-site; USD 55,000 - 75,000; Full time

Job summary

University of Dubuque seeks an Enterprise Application and Data Services Specialist to optimize data quality, improve workflows, and support system integrations. You will work with many campus units to enhance reporting, analytics, and data-driven decision making.

Responsibilities include developing data procedures, building reports in Power BI/SSRS, and automating processes to save time. Strong communication and collaboration with stakeholders across campus are essential.

Qualifications

• Undergraduate degree required; computer emphasis preferred or related business experience.
• Experience with report writers (SQL Server Reporting Services) and Power BI.

Responsibilities

• Identify, develop and correct procedures for monitoring data quality.
• Collaborate with stakeholders to educate and update data and processes across campus.
• Write and maintain stored procedures and functions to extract, transform and report on data.
• Provide recommendations on the use of university systems and data.
• Design and generate reports to meet campus needs in a timely, accurate manner.
• Provide data-driven insights by analyzing trends to support decision making.
• Create forms and workflows to improve processes and data flow across departments.
• Automate processes to save time and reduce paperwork.
• Document procedures for team and end users.

Skills

Technical aptitude

Problem solving

Analytics

Process improvement

Project management

Communication

Collaboration

Relationship building

Attention to detail

Independent work

Education

Undergraduate degree

Tools

SQL Server Reporting Services

Power BI

Job description

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