Job Description POSITION SUMMARY Responsible for data design, database architecture, metadata and repository creation. Designs and develops complex Extract-Transform-Load (ETL) processes for the data warehouse. Reviews data loaded into the data warehouse for accuracy. Responsible for troubleshooting and tuning existing data warehouse applications. Develops, maintains, and supports complex enterprise data warehouse systems and corresponding data marts. Creates new or enhanced components of the data warehouse.
DUTIES AND RESPONSIBILITIES The duties of this position are performed with full competency and under minimal supervision of management personnel. A majority of assignments will be completed independently, subject to periodic review and approval of managers.
Minimum Education Required Bachelor's Level Degree or equivalent combination of education and experience
Required Qualifications -A college degree in Computer Science or equivalent combination of education and experience -Typically has 4-8 years of experience in Information Technology (preferably experience in Data Warehousing) -Ability to manage complex projects with a medium to large scope -Ability to develop and apply innovative approaches to data warehousing problems and opportunities -Experience interacting with customers to gather and understand their business and technical requirements -Experience with data modeling tools (Erwin preferred) and RDBMS (Oracle 9i and above preferred) -Work experience in developing technical and user documentation -Strong project and process management skills
Our Comprehensive Employee Benefits Include:
An array of retirement plan options, each with a generous employer contribution.
Affordable health insurance options, including dental, vision and prescription coverage that begin on day one.
Paid vacation and sick leave, including short and long-term disability and paid parental leave.
Get the most out of the Public Service Loan Forgiveness program.
The Ohio State University is a dynamic community of diverse resources, where opportunity thrives and where individuals transform themselves and the world. Founded in 1870, Ohio State is a world-class public research university and the leading comprehensive teaching and research institution in the state of Ohio. With more than 63,000 students (including 57,000 in Columbus), the Wexner Medical Center, 14 colleges, 80 centers and 175 majors, the university offers its students tremendous breadth and depth of opportunity in the liberal arts, the sciences and the professions.