Data Analyst at The Ohio State University
Posting DateMarch 26, 2019
Location of Position
For 144 years, The Ohio State University's campus in Columbus has been the stage for academic achievement and a laboratory for innovation. It's where friendships are forged. It's where rivalries and revelry are born.
The university's main campus is one of America's largest and most comprehensive. As Ohio's best and one of the nation's top-20 public universities, Ohio State is further recognized by a top-rated academic medical center and a premier cancer hospital and research center. As a land-grant university, Ohio State has a physical presence throughout the state, with campuses and research centers located around Ohio.
Duties and Responsibilities
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 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 an inclusive culture that inspires an exceptionally diverse and talented team and are measured on their adherence to the following core competencies: leadership, continuous improvement, teamwork and collaboration, and communication/interpersonal effectiveness.
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 TAS database. 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.
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 Data Acquisition to analyze new TAS data projects. Serves as liaison to internal customers to the University.
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.
Serves as Project Manager to create project scope, ensuring timeline and specifications are met for assigned TAS data projects. Serves as business analyst to gather requirements, create and facilitate test cases and work with business users and application developers. Exercises independent decision making while being responsible for analyzing data for accuracy, completeness and consistency.
Bachelor’s degree in Computer Information Systems or equivalent combination of education and experience; two years of experience writing complex Microsoft T-SQL queries to extract data from multiple data systems, integrate and analyze data; two years of experience working with data warehouses and large data sets.
3+ years working with Microsoft T-SQL, experience researching, analyzing, and interpreting information; general knowledge of relational databases; experience with Microsoft SQL Management Studio;
In accordance with the Disaster Preparedness and University State of Emergency Policy 6.17 this position has been designated as a standby position.
Also, please visit http://advancement.osu.edu/to learn more about the Ohio State University Office of Advancement.
The Ohio State University is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation or gender identity, national origin, disability status, or protected veteran status.