Business Data Analyst II

University of North Texas System Administration; Denton (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

University of North Texas System Administration in Denton, TX seeks a Business Data Analyst II to create reports, dashboards, and metrics that illuminate business decisions. The role uses SQL and scripting (R or Python) along with Power BI, Tableau, SAS, and Excel to produce actionable insights.

The candidate will collaborate with HR stakeholders to design relevant reports, validate data, and communicate findings clearly for strategic decisions.

Qualifications

• Bachelor's degree in a related field with at least one year of professional experience or equivalent.
• Ability to analyze data and present findings clearly to varied audiences.

Responsibilities

• Create and maintain reports, visualizations, dashboards, and metrics for business insight.
• Build SQL and functions to locate data from EIS systems.
• Manage ad-hoc reports and projects as assigned.
• Work with Data Warehousing, ETLs, de-normalization and tuning techniques.
• Use SQL, R or Python, and tools like Tableau or Excel to analyze and present data.
• Perform analyses and provide actionable recommendations to stakeholders.
• Ensure data quality and accuracy in reports and dashboards.

Skills

SQL

R or Python

Data visualization

Analytical thinking

Communication

Cross-functional teamwork

Education

Bachelor's degree

Tools

Power BI

SAS

Oracle SQL Server

Tableau

Excel

Job description

Title: Business Data Analyst II

Employee Classification: Business Data Analyst II

Campus: University of North Texas - System Administration

Division: SYS-Human Resources

SubDivision-Department: SYS-Human Resources

Department: SYS-Human Resources-910600

Job Location: Denton

Salary: Commensurate with experience

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 University of North Texas Health 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 UNT System Human Resources Department is one department made of a team of teams that supports various constituencies and component institutions within our UNT System Enterprise while working together to achieve the vision of becoming an enterprise that is values-driven and customer-focused with an emphasis on excellence, curiosity, and innovation. There are exciting things on the horizon, and we are looking for experienced and innovative HR professionals to join our journey.

Position Overview

A Business Data Analyst is responsible for creating reports, visualizations, dashboards, and metrics that provide business insight and aid business decision-making. The analyst uses querying languages like SQL, scripting languages like R or Python, and other tools like Power BI Desktop, Power BI Report Builder, SAS, Oracle & Microsoft SQL Server database clients, Tableau or Excel to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions. The analyst also combines these reports with subject-matter expertise to deliver coherent, insightful takeaways and advice. The analyst collaborates with project stakeholders to better understand valuable objectives and KPIs and to design relevant reports and dashboards.

Minimum Qualifications

Bachelor's degree in related field and one year of professional experience in a related field; or any equivalent combination of education, training, and experience.

Knowledge, Skills and Abilities

• Ability to analyze data, including numerical detail, identify patterns or trends, and draw valid conclusions.
• Ability to present various data in clear concise forms to a variety of audiences.
• Basic working knowledge of economic and accounting principles and practices, legal statutes, and analysis and reporting of financial data.
• Proficiency in querying languages like SQL and scripting languages like R or Python.
• Proficiency in data visualization and reporting tools like Tableau or Excel.
• Strong analytical and problem-solving skills.
• Ability to communicate complex data and concepts in a clear and concise manner.
• Ability to work independently and collaboratively with cross-functional teams.
• Attention to detail and quality.

Preferred Qualifications

Required License/Registration/Certifications

Job Duties

• Create and maintain reports, visualizations, dashboards, and metrics that provide business insight and support decision-making.
• Build and develop SQL and functions to help locate data from the EIS systems.
• Manages ad-hoc reports and projects as assigned.
• Experience with Data Warehousing, ETLs, De-normalization, and tuning techniques.
• Use querying languages like SQL, scripting languages like R or Python, and other tools like Tableau or Excel to manipulate, analyze, and present data.
• Perform quantitative or qualitative analyses to address business issues or questions and provide actionable recommendations.
• Apply subject-matter expertise and business acumen to interpret and communicate the results of the analyses.
• Collaborate with project stakeholders to understand their objectives and KPIs and to design relevant reports and dashboards.
• Ensure data quality and accuracy in the reports and dashboards.
• Document the data sources, methodologies, and assumptions used in the reports and dashboards.
• Demonstrating business awareness, critical analysis, and integration of information as well as the ability to develop action-oriented plans.
• Stay updated on the latest trends and best practices in business intelligence and data analysis.

Physical Requirements

• Communicating with others to exchange information.

Environmental Hazards

• No adverse environmental conditions expected.

Work Schedule

Generally, Mon-Fri, 8am-5pm

Driving University Vehicle

No

Security Sensitive

This is a Security Sensitive Position.

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, 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. UNT System Administration promptly investigates complaints of discrimination, harassment, and related retaliation and takes remedial action when appropriate. System Administration 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 a related investigation or proceeding.