Capital & Data Planning Analyst

The Ohio State University • Columbus, OH

1d

About The Position

The Capital & Data Planning Analyst plays a key role in supporting university capital planning efforts within the Office of Planning, Architecture, and Real Estate. This role facilitates the development and implementation of the university’s annual Capital Improvement Plan (CIP) within the Workday/Adaptive software environment as well as through coordination/facilitation of meetings with college/business units and multi-unit Technical Team for review. The position provides comprehensive project and data analytical support to the Director of Facility Planning, the planning and design team, and other university leadership. Also, the planning analyst coordinates and collaborates with facility and financial representative across the enterprise to understand and assess near and long-term capital priorities. Coordination with university business units/departments, such as Administration and Planning, Business and Finance, and Facilities Design and Construction is required. Key responsibilities include conducting advanced data analysis utilizing Excel or similar software, developing Tableau dashboards to support decision-making, and applying AI‑enhanced analytical tools to improve forecasting, reporting, and strategic planning. Experience with managing complex processes for a public entity is desired. The position collaborates with university leadership to develop fiscal strategies aligned with Framework, the university’s campus master plan, principles, institutional priorities, and long‑term planning goals. The planning analyst also coordinates all duties related to the state-assigned community projects, as part of the biennial state capital bill. This includes serving as the main liaison between Ohio State University and community organizations that receive funding from the state, by ushering community projects through the entire Joint Use Agreement (JUA) process and then coordinating with Facilities Design and Construction (FDC) to implement the project.

Requirements

• Bachelor’s degree in planning or related field (or equivalent combination of education and experience) and 2 years of relevant experience required.
• Advanced computer skills, including strong proficiency in Excel, data management, and data analysis.
• Experience developing Tableau dashboards and applying AI‑enhanced tools to support planning, reporting, and decision-making.
• Strong analytical, written, and verbal communication skills.
• Ability to work independently and collaboratively on complex projects.
• Strong time management, workload prioritization, and problem‑solving skills.
• Experience presenting to large, diverse groups.
• Flexible, positive, and proactive team attitude; strong conflict resolution skills.
• Self-starter able to research and problem solve a range of planning-related topics based on team need.

Nice To Haves

• 2-4 years of relevant experience preferred.
• Experience working in an office environment.
• Experience with Excel beyond basic functionality (data modeling, advanced formulas, Power Query, etc.).
• Experience with capital planning in a state university setting
• Experience with university capital planning software and database systems.

Responsibilities

• Conducts research and data analysis on topics such as classroom utilization, capital spending by college/unit, and other areas as assigned.
• Prepares and delivers formal presentations, trainings, written summaries, dashboards, and visual analytics.
• Manages datasets to ensure accuracy and usability across capital planning processes and develops graphics, charts, tables, and reports that synthesize complex data into clear insights that support the annual capital plan and other planning initiatives.
• Supports leadership decision making by contributing to recommendations on project prioritization, scheduling, and funding for the Capital Improvement Plan (CIP).
• Oversees the maintenance of annual capital submissions and facilitating the biennial submission for state capital submissions and reappropriations.
• Performs core services including data management, proposal review, consulting with project teams, and responding to information requests.
• Assists in the development of the university’s long-range capital plan.
• Supports office operations, coordinating internal initiatives, and mentoring student workers, as well as serving as backup for team members when needed.
• Assists the planning team with project execution, ensuring high‑quality customer service while meeting scope and schedule expectations.
• Develops detailed work plans, proactively communicating project status, maintaining accurate records and datasets, and leveraging tools such as Tableau, Excel, and AI‑driven solutions to enhance reporting, visualization, and workflow efficiency.

Benefits

• Medical, dental and vision coverage, with Ohio State paying a significant portion of the cost.
• Paid time off, including sick and vacation time and 11 holidays.
• State retirement plan or an alternative retirement plan, both with generous employer contributions.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees