Resource Planning Analyst
About The Position
The Resource Planning Analyst, based in the Extension Administration office on The Ohio State University’s Columbus campus, manages data analysis, extraction, and integration across disparate systems in the OSU Extension system to provide insights into customers, processes, and decision-making. The role implements processes and logic to extract, transform, and distribute data from a wide variety of sources across one or more data stores, and develops integration designs that meet organizational needs. The analyst designs and manages data dashboards using Tableau, particularly with data extracted from Qualtrics. The position also participates in implementing and maintaining a customer relationship management system in OSU Extension and supports users of the Engage: Extension Data Portal Salesforce Platform. The analyst develops data quality standards, translates reporting requirements into database design and use, builds data acquisition and integration solutions, and develops data integration standards in accordance with organizational information services policies and best practices.
Requirements
- Bachelor's degree or equivalent experience.
- At least 4 years of relevant experience.
Nice To Haves
- An advanced degree in a relevant field may be desirable.
- 4–8 years of relevant experience preferred.
Responsibilities
- Manage data analysis, extraction, and integration across disparate systems in the OSU Extension system.
- Implement processes and logic to extract, transform, and distribute data from a wide variety of sources across data stores.
- Develop integration designs that address organizational needs.
- Design and manage Tableau dashboards, particularly using data extracted from Qualtrics.
- Participate in implementing and maintaining a customer relationship management system in OSU Extension.
- Support users of the Engage: Extension Data Portal Salesforce Platform.
- Develop quality standards to ensure data quality and integrity across database systems.
- Translate reporting requirements into database design and use.
- Build data acquisition and integration solutions to meet organizational requirements.
- Develop data integration standards aligned with information services policies and best practices.
Benefits
- Comprehensive benefits package, available from the first day and subject to position type and eligibility.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
