Sql data analyst [h1.location_city]

Title : Reporting Analyst

Employee Classification : Reporting Analyst

Campus : University of North Texas

Division : UNT-VP Finance & Admin

SubDivision-Department : UNT-UNT Controller's Office

Department : UNT-Controller's Office-151120

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 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 UNT Controller's Office oversees daily accounting and financial reporting for the UNT campus in Denton. The controller office also oversees capital asset accounting, cash and state appropriation management and all external reporting.

Position Overview

The Controller's Office at the University of North Texas is seeking to hire a Reporting Analyst to join our team. The Reporting Analyst performs highly complex (senior level) financial analysis and regulatory work.

Minimum Qualifications

Bachelor's degree in accounting, finance or a related field related field and four years of accounting experience.

Knowledge, Skills and Abilities

Knowledge of generally accepted accounting principles and procedures affecting the maintenance of accounting records and automated accounting systems. Ability to interpret and apply accounting theory; to work accurately with numerical detail; to analyze, consolidate, and interpret accounting data; and to communicate effectively. Experience working in one or more functional areas of accounting. Effective communications skills both orally and in writing. Skill in using office computer information systems to organize, store, manipulate and retrieve data. Strong working knowledge of applicable federal and state laws, and accounting practices. Strong problem solving and analytical skills. Ability to analyze, consolidate, and present accounting data in clear concise form. Ability to plan, organize and effectively manage multiple assignments. Ability to work in a fast paced environment, with frequently changing priorities. Ability to prepare reports and correspondence regarding findings. Focused on providing a high level of customer service and followthrough.

Preferred Qualifications

Prior experience in state accounting, higher education accounting, and / or payroll accounting.

Required License / Registration / Certifications

Job Duties

• Performs monthly accounting close procedures and deliverables such as journal entries, reconciliations, and reports in compliance with GAAP / GASB
• Prepares and timely records accurate asset, liability, revenue, and expense entries by compiling and analyzing account information.
• Reconciles assigned general ledger accounts, maintain and balance subledgers to general ledger activities by validating and resolving discrepancies
• Performs fluctuation analysis and obtains a detailed understanding of transactions or activities recorded to accounts, ensuring proper GAAP accounting is being applied and providing explanations for year over year variances on financial statements
• Analyzes and reviews financial statements, schedules, data compilations, information, and applicable business, financial, and / or regulatory plans
• Assists in administering financial processes, policies, procedures, and systems developed to oversee regulated entities.
• Ensures compliance with established procedures, requirements, laws, and regulations; completeness of data; and presence of documentation
• Effectively and efficiently communicates researched findings, error causations, discrepancies, fluctuations, or irregularities in the organization's financial data to necessary parties. These parties can include colleagues that do not have a formal accounting background.
• Prepares reports and schedules related to external audits, internal audits, public information requests, and annual reporting requirements.
• Other duties as assigned.

Physical Requirements

Communicating with others to exchange information.

Repeating motions that may include the wrists, hands and / or fingers.

Sedentary work that primarily involves sitting / standing.

Environmental Hazards

No adverse environmental conditions expected.

Work Schedule

M-F, 8am-5pm CST

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, 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.