This job has expired

Junior Analyst, Resource Planning & Analysis

Columbus State Community College
Columbus, OH
Closing date
Jul 28, 2021
You need to sign in or create an account to save a job.

Job Details

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 andmake higher education an affordable reality. There has never been a better timeto join a two-year college, and there’s no better place to do it than at ColumbusState. A laser focus on student success and a partnership mindset haveestablished Columbus State as a key talent provider in a thriving regionaleconomy, and a premier community college that is changing the nation’seducation and workforce landscapes. With more than 46,000 students across twocampuses, at several regional learning centers, and online, Columbus State isthe nation’s only institution recognized as an Achieving the Dream (ATD)college, an AACC Guided Pathways institution, and a participant in The RightSignals Initiative through the Lumina Foundation. Columbus State employees atall levels benefit from an engaging, collaborative, and supportive culture thatrewards innovation and vision. We provide competitive compensation, comprehensivebenefits, and professional development opportunities. We are dedicated toensuring that the diversity of Columbus State faculty and staff reflects thatof our students and region. We are proud to be a central part of a communitythat embraces differences and celebrates the many cultures, beliefs, andlifestyles that define Central Ohio. 

The City

Columbus, Ohio is also home to The Ohio State University and more than 30other colleges and universities as well as the headquarters of multiple Fortune500 companies. Columbus is one of America’s fastest-growing cities, offering awealth 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 functionssatisfactorily. Reasonable accommodations may be made to enable individualswith disabilities to perform the essential job functions described in thisposition description. Since every duty associated with this position may not bedescribed herein, employees may be required to perform duties not specificallyspelled out in the job description, but which may be reasonably considered tobe incidental in the performing of their duties just as though they wereactually written out in this position description.

Position Summary

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

Core Competencies Required

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


Analytics & Reporting

Prepares monthly reports for CostCenter Managers.  Updates tuition reportsfor review and analysis by Financial Analysts and Resource Planning &Analysis (RPA) administration.  Reviewsmonthly financial numbers including expenses, revenues, transactional detailsand/or blanket purchase order reports.  Pulls reports for reserve accounts and sets-up budget, asnecessary.  Proofreads reports preparedby Resource Planning & Analysis.

Assesses budget performance byreviewing data, identifying variances, researching, and summarizingexplanations for and material variances.  Supports Financial Analysts by providing needed information to and onbehalf 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 asthey relate to resource planning.

Department Support

Tracks performance benchmarks forthe College as well as for peer institutions.  Reviews for and resolves negative account balances within the operatingbudget.  Updates position budgetutilizing Access database.  Tracks StateShare of Instruction (SSI) by institution for the State of Ohio.  Works closely with Cost Center Managers tosupport budget analysis and financial transactions.  Supports the development and collection ofbudgetary information.  Supportsbudgetary planning and monthly financial projections.

Diversity, Equity &Inclusion

Fostersand maintains a safe environment of respect and inclusion for faculty, staff,students, and members of the community. Assists with conducting workforceanalytics to identify potential inhibitors of a workplace environment that isdiverse, equitable, and inclusive.

Other Duties andResponsibilities

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

Usual PhysicalRequirements

Reasonable accommodations may bemade to enable individuals with disabilities to perform the essential jobfunctions described in this position description.  While performing duties of this job, theemployee 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 withothers in person as well as by telephone.  Vision demands include close, relatively detailed vision when focusingon a computer screen.  Employeeoccasionally lifts up to 10 pounds. 

Working Conditions

Typical office and classroomenvironment.

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 budgetingSkill 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 orclosely 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).


About Columbus State Community College

Columbus State is one of the largest colleges in Ohio, serving approximately 45,000 students annually. Committed to equity and accessibility, and driven to innovate on behalf of our students and our community at large, Columbus State is positioned as Central Ohio’s front door to higher education. Embracing a partnership mindset, Columbus State collaborates with university partners to provide affordable bachelor’s degree options, and with the region’s major employers to develop relevant, real-world educational offerings that produce in-demand workforce talent.


Columbus State offers convenient access to classes and college services at its locations across Central Ohio. Our Columbus Campus is located in the downtown Creative Campus neighborhood of the city’s Discovery District, while our Delaware Campus serves students in the fast-growing northern part of the region. Our Regional Learning Centers are located in Dublin, Grove City, Reynoldsburg, Westerville at Otterbein University, and The Southwest Center at Bolton Field.

National Recognition

Columbus State’s commitment to diverse, equitable and inclusive outcomes for our students and a better society is reflected in our recognition as the 2019 Leah Meyer Austin Award winner by Achieving the Dream, a national network dedicated to eliminating equity gaps in community college education. Columbus State is an Achieving the Dream Leader College of Distinction and a 2021 member of its Racial Equity Leadership Academy initiative to further institutional racial equity change.

Points of Distinction

• In August 2019, Columbus State opened the new home for its School of Culinary Arts and Hospitality Management, Mitchell Hall.

• The College is a leader in The College Credit Plus Program, an Ohio Department of Education strategy aimed at increasing educational attainment.

• Thanks to its strong academic foundation, Columbus State is extremely successful in the grant-writing arena, with 98 active grants from federal and state agencies, corporations, philanthropic organizations, and other sources with a total value of $70.4 million.

• Columbus State holds an annual Day of Service, where hundreds of students, faculty, and staff volunteer at dozens of locations around the area, totaling nearly 2,500 hours of service each year.

• In 2018, Columbus State adopted Four Pillars of Student Financial Stability and is actively partnering with community organizations to help solve issues of housing and food insecurity for our students.

• In 2019, the Mid-Ohio Market at Columbus State opened on the Columbus Campus to help address food insecurity for students and the larger community.

Find Us
United States
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert