Director of Data and Analytics (326)

Position Summary

Reporting to the Assistant Vice President for Budget & Financial Planning ( AVP ), this position serves as the primary analytical support for the AVP and the Director of Financial Planning, especially as it relates to data management and analytics, budget reporting for internal and external constituents, and performance dashboard development and maintenance. The financial analysis, reporting, and research provided by this position will be used, directly and indirectly, to support the senior leadership of the University in making informed decisions and will satisfy reporting requirements to external bodies like the Illinois Board of Higher Education ( IBHE ). The position will collaborate with the AVP on the development of use cases and proposals to University leadership regarding the procurement and implementation of budget and data management and analysis systems.

Essential Duties and Responsibilities

Financial Analysis and Development

• Research and provide information about current and past year financial/budget performance and transactions, including budget-to-actuals variance reporting and research into specific financial transactions.
• Interface with partners across campus, including (Division of Information Technology (DoIT) ERP developers, Human Resources, Institutional Effectiveness to understand and improve data management and policy with the specific goal of enabling strategic decision-making.
• Create and deliver custom reports to Budget Office staff to assist with routine and special project-based financial analysis and management/policy decision-making.
• Develop tools and templates for use by campus partners. These tools may include items like formatted data reporting templates, ERP system queries, pro forma financial statements, and scenario-based projection models. Develop and provide documentation and training to assist campus partners with the use of these resources and tools.
• Create and maintain performance dashboards related to budget and financial planning for use across campus by a diversity of constituent groups.

Policy, Reporting, and Compliance

• Prepare and submit required external reports, including the State of Illinois RAMP report..
• Research and analyze financial and ERP system data to identify business problems, including transactional inefficiencies and training opportunities for departmental staff on budget and financial planning matters.
• Respond to auditor requests that concern budget or financial data matters.
• In coordination with other members of the Office of Budget & Financial Planning, assist with the planning and deployment of ERP -based budget management solutions and tools.

Perform Other Related Duties as Assigned

• Assist with budget operations including the processing of cost center information forms, execution of budget overrides, and creation/posting of budget journals.
• Serve on University committees, groups, and teams focused on data and analysis matters.
• Review and approve or reject campus requests for budget and financial report and ERP system access.

Minimum Required Qualifications (Civil Service)

1. Any one of the following totaling four (4) years (48 months) from the categories below:

A. 30 semester hours of college course work comparable to that in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field AND three (3) years (36 months) of work experience in developing financial or economic analyses, research designs, strategic plans, or data models

OR

B. 60 semester hours of college course work or an Associate’s Degree in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field AND 2 years 6 months (30 months) of work experience in developing financial or economic analyses, research designs, strategic plans, or data models

OR

C. 90 semester hours of college course work comparable to that in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field AND two (2) years (24 months) of work experience in developing financial or economic analyses, research designs, strategic plans, or data models

OR

D. 120 semester hours of college course work or a Bachelor’s Degree in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field AND one (1) year (24 months) of work experience in developing financial or economic analyses, research designs, strategic plans, or data models

OR

E. Master’s Degree in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field

OR

F. Four (4) years (48 months) of work experience in developing financial or economic analyses, research designs, strategic plans, or data models.

AND

2. Two (2) years (24 months) of professional level progressively responsible financial work experience, of which one (1) year (12 months) must have included supervisory or functional oversight experience.

Knowledge, Skills, and Abilities (KSAs) (Civil Service)

1. Knowledge of economic and accounting principles and practices, and the analysis and reporting of financial data.
2. Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules and the political process.
3. Knowledge of business management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
4. Skill in identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
5. Skill in written, oral and interpersonal communication.
6. Ability to self-start, manage multiple tasks and deadlines, and prioritize tasks and functions.
7. Ability to supervise lower-level workers and projects.
8. Ability to motivate, promote teamwork, lead, make decisions based on sound judgments.

Specialty Factors (Civil Service)

None

Preferred Qualifications (Civil Service)

N/A

Minimum Required Qualifications (SPS)

N/A

Additional Requirements (SPS)

N/A

Preferred Qualifications (SPS)

N/A

Physical demands/requirements

• Regular office related duties
• Sitting for extended periods of time
• Using computer/electronic equipment for extended periods of time
• Occasional lifting and moving items weighing up to 25 lbs.

Appointment and Compensation Details

Appointment and Compensation Details

Anticipated Appointment Start Date

04/01/2023

Anticipated Appointment End Date

Percent of Staff Year

1.00

Standard Hours Per Week

37.50

Salary

$65,000.16 - $74,000.16

Hourly or Semi-monthly Pay Rate/Range

$2,708.34-$3,083.34

Earn Type

Salary

Application Procedure

Application Procedure

Application Procedure

Required Procedures:

1. Fully complete the Education and Work History sections of the application. Be specific on your entire work history, including employment dates and duties for all positions held. Applicable part-time work experience will be considered toward qualifying for this position; however, it will be converted to a full-time equivalency to determine combined length of experience. Important: Please upload any unofficial transcript(s) and/or documentation that verifies any education, experience, and/or training you have received.

• If eligible for Veteran’s Preference Points, DD214/DD215/NGB22/DD256 paperwork reflecting an Honorable Discharge MUST be uploaded to this application to receive the maximum eligible points on the Civil Service examination.

2. After the posting has closed, your submission will be reviewed to determine if you meet the minimum qualifications for the classification, including any specialty factors associated with this position. If you meet the minimum required qualifications for this position, you will receive a score based on your education and experience, and your name will be placed on the active employment register.

3. Please monitor your e-mail for further information regarding your application. Emails will be generated from jobs@niu.edu and CivilServiceTesting@niu.edu . Please add these emails to your address book to ensure timely delivery of any future communication.

4. Illinois residency required within 180 days of the hire date.

Credentials Assessment Examination:

• The examination for this position is a Credentials Assessment and is based on your application materials as submitted for this posting. A Credential Assessment is a rating by the Human Resources Office of an applicant’s/employee’s education, experience, and special credentials/qualifications (licenses, etc.). Applicants are required to upload documentation to verify the minimum qualifications for this position has been met.

• Required documentation noted in the posting, such as a driver’s license, licensures, or certifications MUST be uploaded with your application materials.

• After assessment of all qualified applicants has been completed for this position, the names with the top three (3) scores will be referred to the hiring department for interview.

Additional Details:

• Click on Financial Analyst/Planner Supervisor for more information including salary ranges, typical duties, minimum acceptable qualifications, and testing requirements.
• Please click on Human Resource Services – Benefits for detailed information about Northern Illinois University’s benefits package.
• Employment is contingent upon your passing a criminal background investigation. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.
• Applicants must be a current citizen or resident of the State of Illinois to move forward in the hiring process.

Special Instructions

Quick Link to Applicant

https://employment.niu.edu/postings/70183

Is Background Check Required?

Yes

EEO Statement Summary

In accordance with applicable statutes and regulations, NIU is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, sex, religion, age, physical and mental disability, marital status, veteran status, sexual orientation, gender identity, gender expression, political affiliation, or any other factor unrelated to professional qualifications, and will comply with all applicable federal and state statutes, regulations and orders pertaining to nondiscrimination, equal opportunity and affirmative action.

The following person has been designated to handle inquiries regarding the non-discrimination policies:

Ethics and Compliance Officer, Title IX Coordinator
Health Services 230
TitleIXCoordinator@niu.edu
815-753-5560

Visa Policy

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

ADA Accommodation

NIU remains committed to ensuring that its recruitment and application procedures include full opportunities for applicants with disabilities. Employment opportunities will not be denied to anyone because of the need to make accommodations for a person’s disability during either the application or interview process. An applicant who believes they require an accommodation to participate in the employment process due to a disability may request that accommodation through the Accommodation Request Form . For further assistance, please contact the office of Affirmative Action and Equal Opportunity ( AAEO ) at ada@niu.edu .

Safety Information

NIU provides annual reports on campus security and fire safety.

Read the Annual Safety and Security Report. Contact the Ethics and Compliance Office at 815-753-1649 for a hard copy.

Read the Fire Safety Report . Contact the Department of Environmental Health and Safety at 815-753-0404 for a hard copy.
Applicant Documents
Required Documents

1. Cover Letter
2. Resume/Curriculum Vitae
3. List of at least 3 References

Optional Documents

1. Transcripts (unofficial with official required at hire)
2. Transcripts #2 (unofficial with official required at hire)
3. Transcripts #3 (unofficial with official required at hire)
4. Certifications/Licensure #1
5. Certifications/Licensure #2
6. Military Discharge Documents ONLY (DD214/DD215/NGB22/DD256)

Supplemental Questions

Required fields are indicated with an asterisk (*).

1. * Do you have specific work experience supervising professional staff which performed financial analysis, planning, evaluation, and financial modeling projects: assigning projects to project leaders, coordinating their efforts; planning, assigning, and reviewing work activities and final products
   • No work experience directly related to the job function described
   • My work experience relevant to the job function described was performed under guidance
   • My work experience relevant to the job function described was performed independently
2. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
3. * Do you have specific work experience performing complex financial analyses, planning projects requiring the development of new techniques and applications, program evaluation studies, and computer-based modeling projects
   • No work experience directly related to the job function described
   • My work experience relevant to the job function described was performed under guidance
   • My work experience relevant to the job function described was performed independently
4. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
5. * Do you have specific work experience assisting and supporting management in determining the overall financial research agenda, assessing emerging areas of fiscal concern, and in identifying appropriate studies to assist in management of such conditions
   • No work experience directly related to the job function described
   • My work experience relevant to the job function described was performed under guidance
   • My work experience relevant to the job function described was performed independently
6. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
7. * Do you have specific work experience establishing policies, procedures, and guidelines and monitoring effectiveness of current policies and procedures and their impact on departmental financial success; ensuring compliance with all applicable federal and state regulations and institution policies and procedures
   • No work experience directly related to the job function described
   • My work experience relevant to the job function described was performed under guidance
   • My work experience relevant to the job function described was performed independently
8. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
9. * Do you have specific work experience managing contracts and providing recommendations regarding terms of renewal
   • No work experience directly related to the job function described
   • My work experience relevant to the job function described was performed under guidance
   • My work experience relevant to the job function described was performed independently
10. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
    
    (Open Ended Question)
    
    
11. * Do you have specific work experience delivering timely monthly, quarterly, and annual financial reporting materials
    • No work experience directly related to the job function described
    • My work experience relevant to the job function described was performed under guidance
    • My work experience relevant to the job function described was performed independently
12. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
    
    (Open Ended Question)