Data Management Analyst

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. If you have questions while submitting an application, please review these frequently asked questions.

Current Employees and Students:

If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process.

Welcome to The Ohio State University's career site.  We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following:

• Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.

• Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application. 

Job Title:

Data Management Analyst

Department:

Advancement | Gifts and Records

Position Overview

Responsible for data acquisition and ongoing data integrity in University Advancement systems. Works independently to analyze, compare, manipulate, and transform data sets in preparation for upload into an SQL environment using appropriate technical functionality. Assesses software and resource needs based on project; selects and adapts software to meet specific needs. Identifies problems, anticipates needs, and resolves data issues. Creates and maintains documentation for processes, exceptions, and decision-making criteria for projects and ongoing processes.

The data analyst will manage multiple small and large-scale data projects in a high-volume and complex environment. Serves as business analyst to gather requirements, create and facilitate test cases and work with business users and application developers. Develops queries and reports to monitor and maintain data quality and troubleshoot data issues. Exercises independent decision-making while being responsible for analyzing data for accuracy, completeness and consistency.

This position will require a strong attention to detail, critical thinking, analytical and problem solving skills; excellent interpersonal and organizational skills and advanced proficiency in MS office.   

All members of Advancement are part of creating a culture that inspires an exceptionally multifaceted and talented team and are expected to exhibit The Ohio State University’s Shared Values. The Office of Advancement is committed to acting with kindness, respect, and integrity at all times and welcoming our colleagues’ ideas, voices, and perspectives, acknowledging that we are better together.

Duties and Responsibilities

40%  Serves as data analyst for numerous ad-hoc projects of less than 100 hours. Serves as liaison to unit. Determines appropriate tool set and approach to analyze, clean, transform and load data into the CRM system. Lead/Manage testing efforts to assigned functional area during customization, enhancement, and service pack or upgrade processes.  Assists with documenting business processes and project requirements. Cross trains and provides assistance to others as needed.

40%  Serves as data project manager to create scope, ensuring timelines and specifications are met; gathers requirements for projects greater than 100 hours. Troubleshoots problems and determines solutions on assigned projects. Works with Senior Director and/or Associate Director and Technical Lead to analyze new data projects. Serves as liaison to internal customers to the University.

20%  Performs data integrity and error check processes; Develops queries to analyze data for accuracy, completeness and consistency. Works to acquire updated data from various vendors ensuring data is entered following established guidelines. Provides advice and consultation on records and information management procedures. Completes special projects and performs other duties as assigned.

Required Qualifications

• Bachelor’s degree in Computer Information Systems or equivalent combination of education and experience.
• Two (2) years of experience writing complex Microsoft T-SQL queries to extract data from multiple data systems, integrate and analyze data.
• Two(2) years of data management experience working with data warehouses and large data sets.

Desired Qualifications (We’re committed to building a team that reflects a variety of skills and experiences and encourage you to apply even if your experience does not align perfectly)

• Three (3+) years working with Microsoft T-SQL, experience researching, analyzing, and interpreting information and data management.
• General knowledge of relational databases.
• Experience with Microsoft SQL Management Studio and advanced proficiency in MS Office.

The Office of Advancement is committed to providing tools and resources for you to learn our business, proprietary databases, university-specific processes, and advancement practices.

You Need to Know

Aside from the unparalleled benefits of working for The Ohio State University and working in the vibrant, smart, enjoyable, and growing city of Columbus, Ohio, this opportunity will provide exceptional rewards that arise from working for an institution doing worldwide life-changing teaching and research. Learn more here: Careers at Ohio State.

In accordance with the Disaster Preparedness and University State of Emergency Policy 6.17 this position has been designated as a standby position.

Additional Information:

To learn more about the Office of Advancement, please visit advancement.osu.edu.

The budget for this position is up to $80,000. The offer for this position will be based on internal equity and the candidate's qualifications.

Function:         Quality

Sub-function: Data Management

Career Band: Individual Contributor - Specialized

Career Level: S2 Experienced

Location:

University Square North (1031)

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.

Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions.

The university is an equal opportunity employer, including veterans and disability.