Junior Analyst, Resource Planning & Analysis

Requisition ID: req3212

Job Title: Junior Analyst, Resource Planning & Analysis

Department: Business Services

Location: Columbus Campus

Employment Type: Staff

Employment Status: Board Approved

Bargaining Unit: Non-Bargaining Unit

FLSA Status: Exempt

Compensation Type: Annual

Compensation Range: 54,399.00 - 54,399.00

Schedule: 8:00am - 5:00pm; M-F

Job Description:

The College

Community colleges are uniquely positioned to respond to workforce needs and make higher education an affordable reality. There has never been a better time to join a two-year college, and there’s no better place to do it than at Columbus State. A laser focus on student success and a partnership mindset have established Columbus State as a key talent provider in a thriving regional economy, and a premier community college that is changing the nation’s education and workforce landscapes. With more than 46,000 students across two campuses, at several regional learning centers, and online, Columbus State is the nation’s only institution recognized as an Achieving the Dream (ATD) college, an AACC Guided Pathways institution, and a participant in The Right Signals Initiative through the Lumina Foundation. Columbus State employees at all levels benefit from an engaging, collaborative, and supportive culture that rewards innovation and vision. We provide competitive compensation, comprehensive benefits, and professional development opportunities. We are dedicated to ensuring that the diversity of Columbus State faculty and staff reflects that of our students and region. We are proud to be a central part of a community that embraces differences and celebrates the many cultures, beliefs, and lifestyles that define Central Ohio.

The City

Columbus, Ohio is also home to The Ohio State University and more than 30 other colleges and universities as well as the headquarters of multiple Fortune 500 companies. Columbus is one of America’s fastest-growing cities, offering a wealth of cultural experiences, dining, entertainment, shopping opportunities, and more. That’s why Central Ohio residents find living here so fulfilling, both professionally and personally.

To perform this job successfully, an individual must be able to perform the essential job functions satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions described in this position description. Since every duty associated with this position may not be described herein, employees may be required to perform duties not specifically spelled out in the job description, but which may be reasonably considered to be incidental in the performing of their duties just as though they were actually written out in this position description.

Position Summary

The Junior Analyst is an Analyst support position in the Budget Office within Resource Planning & Analysis. The Junior Analyst assists Analysts by investigating, analyzing, and making recommendations concerning the preparation of all aspects - revenue, payroll and non-payroll - of the budget and/or projections. This position makes recommendations and, while final recommendations or decisions are subject to approval and review, independent judgment is expected within established procedures. This role creates excellent working relationships with Analysts as well as Cost Center Managers and support staff.

Core Competencies Required

Professionalism, Managing Work, Continuous Improvement, Customer/Student/Employee Focus, Collaboration, Data Exploration and Research, Communication, Critical & Analytical Thinking, Adaptability, Problem-Solving

ESSENTIAL JOB FUNCTIONS

Analytics & Reporting

Prepares monthly reports for Cost Center Managers. Updates tuition reports for review and analysis by Financial Analysts and Resource Planning & Analysis (RPA) administration. Reviews monthly financial numbers including expenses, revenues, transactional details and/or blanket purchase order reports. Pulls reports for reserve accounts and sets-up budget, as necessary. Proofreads reports prepared by Resource Planning & Analysis.

Assesses budget performance by reviewing data, identifying variances, researching, and summarizing explanations for and material variances. Supports Financial Analysts by providing needed information to and on behalf of the RPA department for analyses and research. Aggregates and summarizes data, as needed, for analyses and presentations. Facilitates and develops other special analyses or manages projects as they relate to resource planning.

Department Support

Tracks performance benchmarks for the College as well as for peer institutions. Reviews for and resolves negative account balances within the operating budget. Updates position budget utilizing Access database. Tracks State Share of Instruction (SSI) by institution for the State of Ohio. Works closely with Cost Center Managers to support budget analysis and financial transactions. Supports the development and collection of budgetary information. Supports budgetary planning and monthly financial projections.

Diversity, Equity & Inclusion

Fosters and maintains a safe environment of respect and inclusion for faculty, staff, students, and members of the community. Assists with conducting workforce analytics to identify potential inhibitors of a workplace environment that is diverse, equitable, and inclusive.

Other Duties and Responsibilities

Manages multiple assignments of varying complexity and meets tight timelines and deadlines, with the ability to adapt to changing needs of the College and business partners. Attends all required meetings and trainings. Ability to work evenings, weekends, and a varying schedule, as needed.

Usual Physical Requirements

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions described in this position description. While performing duties of this job, the employee regularly exhibits digital dexterity when entering data into computer. The employee frequently sits for periods of time, stands, and walks. Employee converses verbally or manually with others in person as well as by telephone. Vision demands include close, relatively detailed vision when focusing on a computer screen. Employee occasionally lifts up to 10 pounds.

Working Conditions

Typical office and classroom environment.

Knowledge, Skills and Abilities: Knowledge of: Microsoft Office Suite or related software at a high level, including but not limited to Excel, Access (intermediate to advanced levels); principles of public administration; general principles and methods in budgeting Skill in: self-expression, both orally and in writing; analytical and problem solving; attention to detail; maintaining documentation and records; verbal and written communications; presentations to all levels of employees within the organization; high level of skill in generally accepted accounting principles; maintaining good public relations; customer service; operating general office equipment; general typing; application of standard office practices and procedures; interpreting and implementing data involving federal, state and common policies and procedures as required. Ability to: effectively communicate and work with persons of varying cultures and backgrounds; work independently; ask questions to assist with analyzing or solving problems; make recommendations for problem-solving; comprehend and prepare data, including statistical, for presentation to others; evaluate financial data; navigate complex and multifaceted institutions/organizations/software systems; convey complex information in a clear, creative way; demonstrate initiative; develop and maintain effective working relationships with associates, supervisors, and job contacts; demonstrate flexibility; maintain confidentiality of employee and student information and other sensitive information; maintain accurate and complete work records; planning, scheduling and organization work.

Minimum Qualifications: Bachelor’s Degree in Business Administration, Finance, Accounting or closely related field; AND One (1) year of progressively responsible financial reporting and/or accounting experience. State Motor Vehicle Operator's License or demonstrable ability to gain access to work site(s).