"Alerted.org

Business Systems Analyst, Development

Wayne State University is searching for an experiencedBusiness Systems Analyst, Developmentat its Detroit campus location.

Wayne State is a premier, public, urban research university located in the heart of Detroit, Michigan where students from all backgrounds are offered a rich, high-quality education. Our deep-rooted commitment to excellence, collaboration, integrity, diversity and inclusion creates exceptional educational opportunities which prepare students for success in a global society.

Essential functions (job duties):

Job Purpose

Responsible to design and develop reports to extract data from the administrative system using various reporting tools, based on end-user requirements and specifications. Validate and verify accuracy of reports, ensuring that reports are presentation ready. Identify, troubleshoot, and resolve system related issues. Participate in the analysis of business reporting needs and the implementation of data hygiene strategies in the Division of Development and Alumni Affairs. This position to the Associate Director, Analytics and Reporting.

Essential Functions

(Essential functions are the primary duties/major job responsibilities that an employee must be able to perform, with or without reasonable accommodation. The essential functions are listed in order of importance.)

Write ad-hoc reports based on approved user requests using a variety of reporting tools, including SQL, Excel, R, and Power BI. Analyze business needs and track ad-hoc report usage to assess and recommend report development priorities for the division. Design, develop, validate, and verify new standard reports. 45%

Prepare and maintain inventory of existing standard certified reports from various sources (such as SQL, R, Power BI, SSRS). Document report specifications including input, output, filters, conditions and styles. 25%

Work with end-users within the division to ascertain desired report contents, determine report parameters and perform required analysis to ensure accurate extraction of data from the enterprise data repository to meet the business needs of the end-users. 15%

Troubleshoot and facilitate problem resolution for the division's administrative database(s), often in partnership with colleagues from the university's Computing & Information Technology (C&IT) division and the division’s Data Integrity team. 10%

Other duties and special projects as assigned. 5%

WORK CONTEXT

This grid characterizes the position scope.

Job Reports to: Associate Director

Leadership Accountability: Implements operating plans

Supervisory Accountability: None

Organizational Accountability: None

Financial Accountability: None

Customer Accountability: Interfaces with customers outside the S/C/D

Freedom to Act: Subject to general input from supervisor

Unique duties:

Qualifications:

MINIMUM QUALIFICATIONS

Education Bachelor's degree

Graduation from an accredited college or university with a degree in information technology, computer science or related field.

Experience Experienced (minimum 2 years of job-related experience)

Minimum of three (3) years of experience working with relational data and database management systems, preferably in a higher education advancement or nonprofit fundraising environment.

SQL programming experience required.

Experience working with data utilizing R, Python, Excel, Power BI or other data processing tools.

Knowledge, Skills and Abilities

ANALYTICAL AND PRESENTATION SKILLS: Ability to evaluate, interpret, and present complex information effectively in professionally prepared documents or presentations. Must possess a demonstrated attention to detail in order to achieve a high degree of accuracy. Proposes and evaluates alternative solutions to achieve organizational goals.

COLLABORATION: Exhibit a willingness to partner with units across the university with integrity and high character to reach unified goals. Possess the ability to navigate difficult situations with grace and understanding.

COMMUNICATIONS SKILLS: Ability to communicate clearly, concisely and professionally both orally and in writing. Strong interpersonal skills are a must. Demonstrates the ability to plan and deliver oral and written communications that are impactful and persuasive including presentations to university management and committees.

LEARNING AGILITY: Independent and innovative self-starter who displays an ability to learn quickly and easily adapts to changing situations. Experience researching topics to gain knowledge and understanding when information gaps exist.

PLANNING AND ORGANIZATION: Ability to manage several projects simultaneously, prioritize and plan work activities while meeting respective deadlines. Strong organizational and time-management skills required. Maturity, sound judgment and ability to handle multiple tasks simultaneously in a deadline-oriented environment.

TEAMWORK: Ability to collaborate effectively with colleagues within the division and other units to gain full understanding of the project and desired outcome; ability to produce high quality and consistent results with assistance of team members; provide support to teammates when tackling complex projects.

TECHNICAL SKILLS: Proficient in the use of complex administrative systems software, preferrably in the higher education environment or nonprofit environment. Proficient with Microsoft Office suite, especially Word, Excel and Teams. Demonstrated ability to translate user requirements into technical specifications and systems.

Working Conditions

Normal office environment.

Adhere to confidentiality and data usage policy for the division.

Preferred qualifications:

School/College/Division:

H86 - Development & Alumni Affairs

Primary department:

H8605-Development

Employment type:

+ Regular Employee

+ Job type: Full Time

+ Job category: Staff/Administrative

Funding/salary information:

+ Compensation type: Annual Salary

+ Hourly rate:

+ Salary minimum: $55,000

+ Salary hire maximum: $58,000

Working conditions:

Job openings:

+ Number of openings: 1

+ Reposted position: No

+ Reposted reason: None (New Requisition)

+ Prior posting/requisition number:

Background check requirements:

University policy requires certain persons who are offered employment to undergo a background check, including a criminal history check, before starting work. If you are offered employment, the university will inform you if a background check is required.