Enterprise Data Warehouse Architect

  • University of North Carolina at Chapel Hill
  • Chapel Hill, NC, United States
  • Jan 11, 2018
Full-time Computer Science Data Governance Data Management Data Modeling Data Science Data Warehouse ETL Information Technology (IT) Oracle SQL

Job Description

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

Education

  • 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 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

Learn more about our Information Technology Services: http://its.unc.edu/

Interested applicants must click the 'Apply For Job' button on this page to visit the UNC-CH job search page and apply for this position.

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.

Job ID

20025727

Salary

$100,000 - $110,000