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
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.
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.
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
ESSENTIAL JOB FUNCTIONS
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.
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.
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.
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).