Capital & Data Planning Analyst

Job Title: Capital & Data Planning Analyst Department: Administration and Planning | Planning Architecture and Real Estate Physical Space and Capital Planning 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 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. Data Analysis and Research This position conducts research and data analysis on topics such as classroom utilization, capital spending by college/unit, and other areas as assigned. The planning analyst prepares and delivers formal presentations, trainings, written summaries, dashboards, and visual analytics. The role also 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. Leadership and Capital Planning Support This role supports leadership decision making by contributing to recommendations on project prioritization, scheduling, and funding for the Capital Improvement Plan (CIP). It 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. Working closely with the Office of Business and Finance, this role assists in the development of the university’s long‑range capital plan. Additional responsibilities include supporting office operations, coordinating internal initiatives, and mentoring student workers, as well as serving as backup for team members when needed. Team and Project Support The position assists the planning team with project execution, ensuring high‑quality customer service while meeting scope and schedule expectations. Responsibilities include developing 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. Other duties may be assigned. Successful completion of a criminal background check is required. Minimum Education Required Bachelor’s degree or equivalent combination of education and experience. Required Qualifications 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. Desired Qualifications 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. Additional Information The target hiring range for this job profile is $64,900 - $84,850 annually. The actual salary paid to an individual will vary based on multiple factors, including but not limited to, education, years of experience, internal equity, etc. This position is in‑person and requires regular on‑site attendance in Columbus, Ohio. Function - Facilities, Engineering and Acquisition Sub Function - Campus Planning Band - Individual Contributor - Specialized Level - S2 Location: Gateway D (0865) Position Type: Regular Scheduled Hours: 40 Shift: First Shift Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process. Benefits Ohio State benefits give you options to take care of what matters most to you — and opportunities to make adjustments as your life and needs change, including: 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. As Buckeyes, we accomplish more together. No matter your role, you’ll be part of creating what people need now: pathways to education, research and health care. Working at Ohio State means you’re part of a team with a strong sense of community and an unwavering commitment to excellence — and, of course, incomparable Buckeye spirit. We bring out the best in people, help each other succeed and learn together. By joining Ohio State, you become part of a top‑20 public university with one of America’s leading academic health centers. We’re a team of dedicated colleagues with access to boundless resources that support you. The university is an equal opportunity employer, including veterans and disability. The university is an equal opportunity employer, including veterans and disability. Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. For answers to additional questions please review the frequently asked questions. Review the Frequently Asked Questions for details on using Workday and submitting your application. #J-18808-Ljbffr Ohio State University