Reporting and BI Analyst

Working Title: Reporting and BI Analyst (On-site Position)

State Role Title: N/A

Position Type: Administrative & Professional (Non-teaching Faculty)

Position Status: Full-Time

College/Division: Advancement Information Services

Department: Advancement Business Applications

Pay Rate: Other

Beginning Review Date:

Specify Range or Amount: $69,410 / annual

Is this a JMU only position? No

Is this a grant-funded position? No

Is this a Conflict of Interest designated position? No

About JMU:

Mission
We are a community committed to preparing students to be educated and enlightened citizens who lead productive and meaningful lives.

Vision
To be the national model for the engaged university: engaged with ideas and the world.

Who We Are
Located in the heart of Virginia's beautiful Shenandoah Valley, the city of Harrisonburg is approximately 120 miles from Washington, D.C. and Richmond, VA. With a population of just over 53,000, Harrisonburg is one of the most diverse communities in the Commonwealth of Virginia. JMU is a selective, public institution with a growing national reputation for offering experiences that lead to an outstanding education and inclusive environment for students, faculty and staff. The student body includes approximately 20,000 undergraduate and 1,900 graduate students, with over 1,000 full-time instructional faculty.

JMU offers thriving programs in the liberal arts, science and technology, and professional disciplines at the undergraduate, master's and doctoral levels. The university is committed to expanding diversity, fostering equity and inclusion, and supporting superlative teaching and scholarship. JMU has achieved national recognition for the high quality of its academic programs, focus on maintaining strong student/faculty interaction, and innovative faculty research.

General Information:

James Madison University is currently accepting applications for a Reporting and BI Analyst.

Duties and Responsibilities:

Develop, maintain, and improves systems and procedures related to the production, processing and delivery of analytic reports and studies. Manage deadlines, collaboration, and planning necessary to complete both Ad Hoc and Project Based analytics reports using data exploration toolsets including SQL, Oracle Data Warehouse and BI platforms such as Cognos and Tableau. Utilized external datasets for comparative and compliance reporting, develop dashboards to support data distribution and decision making within University Advancement and associated campus partners. Maintain, optimize and develop database objects (Functions, Transformation Tables, Procedures) related to the data warehouse. Work collaboratively with internal team and senior administration to continuously improve reporting resources and processes.

Qualifications:

Qualifications:

• Bachelor's degree in Computer Science, Computer Information Systems, or related discipline with at least 2 years of experience in technology and database systems.

• Relevant experience in database management and/or data warehouses with ability to program in SQL, Python, and/or R for decision support and reporting services.

• Experience in collecting requirements from stakeholders and understand their needs.

• Ability to effectively communicate, verbally and in writing, complex technical information, while providing analytical solutions that consider the intricate interactions of business processes, systems, databases, and data warehouse objects.

• Relevant experience working in a higher education setting with knowledge of student-related data.

• Understanding of data modeling and data warehousing with experience building data analytic reports and visualizations.

• Ability to work with data and people from multiple sources/departments while embracing Advancement Information Services (AIS) values of collaboration, quality, innovation and integrity.

• Demonstrated organizational skills, flexibility, good judgement, teamwork, attention to detail, problem-solving, life-long learning, and initiative.

Conditions of Employment:

Employment is contingent upon the successful completion of a criminal background check.

E-Verify Notice: After accepting employment, new hires are required to complete an I-9 form and present documentation of their identity and eligibility to work in the United States. James Madison University uses the E-Verify system to confirm identity and work authorization.