Data Analyst - Reporting

Edtech.com's Summary

University of North Texas is hiring a Data Analyst - Reporting. The role involves creating and maintaining Power BI dashboards, fulfilling data requests through Blackbaud Raisers Edge/NXT, and collaborating with University Advancement and other university partners. The analyst also supports data warehouse projects and ensures data integrity through verification and updates.

Highlights

Perform daily data reporting, dashboard creation, and maintenance using Power BI.
Generate and fulfill data requests by evaluating customer needs and querying data via Blackbaud Raisers Edge/NXT.
Assist in building and reporting on a data warehouse using Power BI or other software.
Collaborate with University Advancement and university-wide partners.
Strong mathematical, analytical skills, and familiarity with relational databases required.
Intermediate proficiency in Microsoft Office, including Access and Excel.
Preferred experience with Blackbaud Raisers Edge, SQL, Power BI, and advanced Excel.
Minimum qualification: Bachelor’s degree in a quantitative research field or equivalent experience.
Salary range: $51,744 - $55,000 with TRS retirement eligibility.
Position classified as Security Sensitive and includes typical office work with some interaction and minimal physical demands.

Data Analyst - Reporting Full Description

Title: Data Analyst - Reporting

Employee Classification: Data Analyst

Campus: University of North Texas

Division: UNT-Advancement

SubDivision-Department: UNT-Donor Relations & Advanc Servi

Department: UNT-Donor Relat & Advanc Serv-Gen-172500

Job Location: Denton

Salary: $51,744 - $55,000

FTE: 1.000000

Retirement Eligibility: TRS Eligible

About Us - Values Overview

Welcome to the University of North Texas System. The UNT System includes the University of North Texas in Denton and Frisco, the University of North Texas at Dallas and UNT Dallas College of Law, and the University of North Texas Health Science Center at Fort Worth. We are the only university system based exclusively in the robust Dallas-Fort Worth region. We are growing with the North Texas region, employing more than 14,000 employees, educating a record 49,000+ students across our system, and awarding nearly 12,000 degrees each year.

We are one team comprised of individuals who are committed to excellence, curiosity and innovation. We are transforming lives and creating economic opportunity through education. We champion a people-first values-based culture where We Care about each other and those we serve. We believe that we are Better Together because we foster an environment of respect, belonging, and access for all. We demonstrate Courageous Integrity through setting exceptional standards and acting in the best interest of our communities. We are encouraged to Be Curious about opportunities for learning, creating, discovering, and innovating, and are encouraged to learn from failure. Show Your Fire by joining our team and exhibiting your passion and pride in your work as part of our UNT System team.

Learn more about the UNT System and how we live our values at www.UNTSystem.edu.

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

This position will perform data reporting and dashboard creation and maintenance operations daily such as Power BI dashboard creation/data querying and data refresh. This position will also be responsible for generating data requests via Blackbaud Raisers Edge/NXT by evaluating customer needs and data resources. The 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 quantitative research field such as social science research, data analytics, computer science, computer/information sciences, or related field; or any equivalent combination of education, training, and experience.

Knowledge, Skills and Abilities

* Strong mathematical and technical ability.
* Strong analytical skills.
* Working knowledge of relational databases.
* Intermediate proficiency in Microsoft Office including Access and Excel.
* Ability to quickly assimilate to specific software.
* Ability to quickly assimilate how data sets impact related systems and functions.

Preferred Qualifications

* Previous experience with or certification in Blackbaud Raiserâs Edge, SQL or other programming languages, Power BI or other reporting software
* Advanced Microsoft Excel experience

Job Duties

Data Reporting: Review requests sent into the Data Team inbox. Fulfill the request by creating an export based on the criteria in the request.Â
Data Request fulfillment (writing queries): Use/create/modify existing queries based on the criteria in the data request to create an Exportable List or Excel report.Â
Dashboard Creation: Meet with other teams to learn what their data needs are. Plan and draft a dashboard model that fits their needs/requirements. Create a Dashboard based on that plan. Review existing dashboards currently being used and convert all existing dashboards to Power BI dashboards.Â
Data Health and Integrity: Use exiting process or review current records to verify and validate the contents of the records. Update records based on research done to vet the records.
Importing Data: Use existing modules to import data contained in Excel files to add/update records.

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

Yes

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.

Original Job Description