Data Architect - 12832BR
Leadership (45%): Oversee a technical team of ETL and Essbase developers that extract and model data from various source systems. Provide leadership, analytical, technical, and web-based support using a variety of tools to support the reporting and analytical needs of units reporting to the Vice Provost for Administration and Finance. Serve as a key member representing the BIC with university data governance. Ensure teams are adhering to basic development principles (e.g. change control and separation of duties). Communicate frequently with campus leadership providing status updates on projects. Help promote the concept and importance of data warehousing and business intelligence, educating the campus on available data and toolsets to meet end user needs.
Infrastructure Planning and Support (5%): Ensure the data warehouse, ETL tools, etc. are maintained by Information Technology and/or Data Modelers. Take a lead role in developing a university data warehousing strategy and infrastructure. Work with the Network Operations Center (NOC) to ensure extract jobs are monitored and that issues are appropriately escalated, communicated, and ultimately resolved.
Development (5%): Develop and maintain ETL processes and/or SOL from various source systems. Participate in an Agile environment and complete assigned sprint tasks. Adhere to basic development principles (e.g., change control, separation of duties, etc.). Provide feedback from a technical perspective on requirements documents. Additionally, create data flows, and process models to help document the technical approach to meeting end user needs.
- Bachelor's degree in Computer Science, Mathematics, Statistics, Business Administration with a concentration in Finance or related field.
- 3 years of data modeling and analytics, including 2 years in a university environment, including experience with Oracle Business Intelligence tools (OBIEE, BICS, or OAC), Oracle Data Integrator and SAS DI Studio Extract-Transform-Load (ETL) tools, SAS and Tableau server administration, security, Oracle database and SQL programming experience.
Additional Candidate Instructions
Applicant review will begin October 15 and continue until filled.