Senior Data Analyst - Reporting

About Us - Values Overview

Department Summary

The Division of University Advancement strives to transform lives and unlock potential through the power of philanthropy and engagement by awakening and stewarding pride and loyalty for the University of North Texas.

Established in 1890, the University of North Texas is a place where students transform their lives through education and opportunity. With more than 46,000 students from across the state, nation, and world, UNT offers 240 academic programs — many nationally and internationally recognized. A Tier One research university and designated a Hispanic- and Minority-Serving Institution, UNT has a legacy of excellence in education, music, the arts, business and social sciences, with growing strengths in science and engineering. Last year, students earned nearly 13,000 degrees and joined UNT's network of 480,000 alumni, fueling progress and innovation.

Position Overview

The Senior Data Analyst - Reporting will serve as a cornerstone of our Advancement Data Management team, responsible for ensuring the accuracy of reporting, consistency in reporting delivery times, and overall integrity of reporting engagement data through various means. They will design and lead a comprehensive dashboard creation and maintenance program, including but not limited to conversion of existing dashboards, campaign dashboards, and data refresh schedules. Review existing queries and exports, create recommendations for Templated/canned reporting, partnering across teams to resolve issues and implement process fixes. he position will assist with projects regarding the building of a data warehouse and subsequent reporting involving Power BI or other software. This Position collaborates with University Advancement, as well as University wide partners.

Minimum Qualifications

Bachelor's degree in related field and two years of data analysis work experience; or any equivalent combination of education, training and experience.

Knowledge, Skills and Abilities

* Advanced mathematical and technical ability
* Advanced analytical and reasoning skills
* Advanced knowledge of statistical packages and relational database design and logic
* Advanced proficiency in Microsoft Office including Access and Excel
* Proficiency in specific software and programming languages required.

Preferred Qualifications

The ideal candidate will possess the following additional qualifications:
* Experience with Power BI or Tableau
* Experience with SQL and writing queries
* Experience with Blackbaud Raiser’s Edge/NXT
* Familiarity with CASE standards or peer benchmarks like EAB or VSE reporting
* Prior experience developing or managing data governance frameworks or data stewardship initiatives

Job Duties

• 4Dashboard Creation and Maintenance * Design and lead a comprehensive dashboard creation and maintenance program, including but not limited to conversion of existing dashboards, campaign dashboards, and data refresh schedules. * Review existing queries and exports, create recommendations for templated/canned reporting, partnering across teams to resolve issues and implement process fixes.
• Reporting & Analytics * Manage daily data request queue and assign requests accordingly. * Fulfill ad hoc and recurring data requests, prepare clean donor and giving lists, and assist with segmentation and campaign targeting.
• Training & Documentation * Create and maintain procedural documentation, data dictionaries, and user guides to standardize data-entry practices and improvements. * Conduct training sessions for Advancement teams to promote understanding and adherence to quality standards.
• System Implementation & Change Management * Collaborate on system enhancements and CRM configuration changes, testing new features to ensure data consistency and integrity. * Help design and enforce data governance policies, documentation, and training to support sustainable data standards. 

Physical Requirements

• Communicating with others to exchange information.
• Sedentary work that primarily involves sitting/standing.
• Repeating motions that may include the wrists, hands and/or fingers.

Environmental Hazards

• No adverse environmental conditions expected.

Work Schedule

Monday through Friday 8 am to 5 pm; typical 40-hour work week with possible flex and hybrid work opportunities.

Driving University Vehicle

No

Security Sensitive

This is a Security Sensitive Position.

Special Instructions

Applicants must submit a minimum of two professional references as part of their application. If needed, additional references can be added after the application has been submitted. 

Benefits

For information regarding our Benefits, click here.

EEO Statement

The University of North Texas System is firmly committed to equal opportunity and does not permit -- and takes actions to prevent -- discrimination, harassment (including sexual violence, domestic violence, dating violence and stalking) and retaliation on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, genetic information, or veteran status in its application, employment practices and facilities; nor permits race, color, national origin, religion, age, disability, veteran status, or sex discrimination and harassment in its admissions processes, and educational programs and activities, facilities and employment practices. The University of North Texas System promptly investigates complaints of discrimination, harassment and related retaliation and takes remedial action when appropriate. The University of North Texas System also takes actions to prevent retaliation against individuals who oppose any form of harassment or discriminatory practice, file a charge or report, or testify, assist or participate in an investigative proceeding or hearing.