The University of North Carolina at Chapel Hill Chapel Hill, NC, USA
May 17, 2018Full-time
The Data Warehouse Architect reports to the Manager of the Enterprise Reporting and Departmental Systems team. This position will design and implement dimensional data models as well as the implementation strategy for an institutional data warehouse. A successful candidate understands enterprise data warehouse architecture, industry standards and data governance. The candidate will also identify and implement master data management in areas of need, to facilitate the combination of disparate data from multiple systems. The candidate must understand underlying warehouse technology, including setup, tuning and administration, identify necessary security and audit controls, and have a deep understanding of relational and dimensional data modeling as it crosses all areas of the enterprise. The Following Experience is Required: Understand master data management Understand function and operation of ETL tools and processes Ability to write complex SQL Experience using Oracle databases Knowledge of current industry standards Ability to collaborate effectively with a diverse team Excellent written and oral communication skills The Following Experience is Preferred: 5+ years’ experience in higher education enterprise data warehouse design Experience working with PeopleSoft data structures Experience with Oracle OEM Educational Requirements Bachelor’s degree in Computer Science, Computer Information Systems, Computer Engineering, or Engineering or closely related degree from an appropriately accredited institution and five years of experience in operations analysis and design, systems programming or a closely related area; OR Bachelor’s degree from an appropriately accredited institution and six years of experience in operations analysis and design, systems programming or a closely related area; OR Associate’s degree in Computer Information Technology, Computer Engineering Technology, or Networking Technology from an appropriately accredited institution and and six years of experience in operations analysis and design, systems programming or a closely related area; OR Equivalent combination of education and experience. Bachelor’s Degree preferred Interested? Interested applicants must click on the "I'm Interested" button on this page and go to the UNC-CH job search page to apply for this position. Learn more about our Information Technology Services at: http://its.unc.edu/ Equal Opportunity Employer The University of North Carolina at Chapel Hill is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or status as a protected veteran.