The Business Intelligence / Data Warehouse Lead Architect will be responsible for assisting with all aspects of BI and DW implementations to include distinct tasks around planning, implementation, stabilization and enhancements. The candidate should be deeply familiar with BI and DW implementation methodologies and technologies and have prior experience delivering full suite implementations. Reporting to the Assistant Vice President of Enterprise Applications, the ideal candidate understands the value of data and can communicate that value to end users, as well as lead a technical team with ETL, database design and report writing. The ideal candidate will also be able to collaborate effectively with business users, use project management skills while executing projects and leverage hands-on data warehouse experience to successfully manage data warehouse related activities.
Bachelor’s degree in Information Technology/Computer Science or related field.
5 years of experience as a Data Applications Developer/Engineer or Database Administrator.
Proven experience in managing and executing data warehouse initiatives along with providing project management/process support to IT team.
Experience leading a small technical team.
Expert-level knowledge of data architecture principles, approaches, best practices and emerging technologies.
Knowledge of master data management best practices and the ability to lead in their implementation and maintenance.
Knowledge to produce conceptual, logical and physical data models.
Knowledge of data governance processes and structures.
Knowledge of application, data development and data discovery methodologies.
Knowledge of metadata management-maintenance as well as design and implementation of metadata-driven enterprise solutions.
Knowledge of data classification, business ownership/stewardship definition and developing role-based data access.
Knowledge of data privacy, compliance and security principles.
Skill in analysis, problem solving and troubleshooting.
Strong written and verbal communication skills.
Strong interpersonal skills to work with a diverse group of individuals at all levels of the university.
Ability to learn and interpret university policies and procedures.
Experience in a Higher Education institution Experience in PeopleSoft or other ERP applications.
Advanced knowledge of relational databases.
Experience with data warehouse systems, ETL processes, and visualization software, preferably Microsoft Sql Server, SSAS, Blackboard Analytics, Pyramid Software, SSRS.
Applicants for Staff positions must be currently authorized to work in the United States on a full-time basis. Chapman University does not sponsor applicants for work visas.
Any offer of employment is contingent upon satisfactory completion and outcomes of a criminal background screening, credit check, DMV driving clearance, and signed original acceptance of the Chapman University Agreement to Arbitrate.
Internal Number: 18527
About Chapman University
Chapman University is one of California's oldest and most respected private universities, offering distinguished undergraduate and graduate degrees in the context of a liberal arts and sciences university. For more than 150 years, Chapman University has served as a symbol of educational access and excellence in the state of California. Founded as Hesperian College in 1861 in Woodland, California by members of the Christian Church (Disciples of Christ), we admitted men and women and people of color from our earliest days. Endowed by the Valencia orange magnate Charles Clarke Chapman, the institution changed its name to Chapman College in 1934, and by 1954 had moved to the former campus of Orange Union High School in Orange, California. The college again extended higher educational access when it began offering classes to military personnel at El Toro Marine Base.In 1965, Chapman took undergraduate education to the high seas when it began running World Campus Afloat, the program that would eventually become Semester at Sea, a tradition that continues at Chapman through our world-wide study abroad programs.Since our founding, Chapman has grown into a highly regarded university that at...tracts high-achieving undergraduate and graduate students from all over the United States, and more than 60 nations around the world.Our mission statement: To provide personalized education of distinction that leads to inquiring, ethical and productive lives as global citizens.