The Data Warehouse Architect will establish the future-state reporting and analytics architecture for UGA's transition to Workday. The role will define how Workday reporting, the institutional data warehouse, data lake services, legacy data, and downstream analytics fit together. Working with information technology and project stakeholders, the Architect will set design standards and document a practical roadmap that supports report redevelopment, reliable data access, and long-term institutional use.
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">Knowledge, Skills, and AbilitiesKnowledge of enterprise data architecture, data warehousing, and modern data lake patterns
Knowledge of data governance, data quality, metadata, privacy, and access control principles
Ability to evaluate integration and data consumption approaches for reliability, scalability, and maintainability
Strong analytical, documentation, facilitation, and communication skills
Ability to work across technical teams, reporting teams, vendors, and campus stakeholders
Ability to balance immediate transition needs with sustainable future-state design
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">Duties/Responsibilities Architecture and Strategy ( %)Develop the Workday reporting and data warehouse architecture strategy, including data flows, integration patterns, and data consumption approaches.
Define the target-state data warehouse design and the role of data lake services in supporting reporting and analytics.
Create architecture documentation, design standards, and a phased technical roadmap for implementation.
Data Governance and Legacy Data Planning ( %)Recommend data governance standards covering ownership, definitions, quality, metadata, access, and appropriate use.
Develop an approach for retaining and accessing legacy data needed for historical, operational, and analytical reporting.
Assess architectural options and document assumptions, dependencies, risks, and decisions for project leadership.
Technical Design and Implementation Guidance (20%)Guide integration and warehouse design decisions and review technical solutions for alignment with the approved architecture.
Partner with the Feed Engineer and report development team to ensure data structures and feeds support prioritized reporting needs.
Advise on data quality validation, testing, deployment, and production support approaches.
Stakeholder Collaboration and Knowledge Transfer (10%)Facilitate architecture discussions with business and technical stakeholders and communicate design recommendations clearly.
Maintain architecture records and transfer knowledge to staff responsible for ongoing operations.
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">Physical DemandsWork is primarily performed in an office setting, involving extended periods of sitting and computer use. The position may require occasional in-person meetings with project and campus stakeholders.
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">Impact and InfluenceThe position will influence technical decisions across reporting, data integration, and analytics workstreams. It will work closely with project leadership, IT staff, business data owners, vendors, and report developers to establish a coherent architecture and guide implementation choices.
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">About the ProjectThe Unified Enterprise Resource Planning (ERP) Program intends to replace UGA's legacy systems for human capital management and financials, improve the experience for students, faculty, and staff, streamline core business processes, and unify technology in a single SaaS solution.
< style=\"color: rgba(0, 0, 0, 1); font-family: Arial, Helvetica, sans-serif; font-size: 13px\">Local Candidates strongly preferred.Required/Desired Skills Skill Required /Desired Amount Candidate Experience Experience designing enterprise data warehouse, data lake, or analytics architectures Required 5 Experience with cloud data platforms, data integration patterns, and enterprise reporting environments Required 5 Experience establishing data governance, metadata, security, and data access practices Required 5 Experience with Workday data and reporting, higher education, or large public-sector environments Required 5 Ability to translate business reporting needs into scalable technical architecture and roadmaps Required 5 Questions No. Question Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? Question2 What is your candidate&# ;s email address? Question5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement? Question6 If selected for engagement, your candidate will be expected to start no later than 2 weeks (10 business days) after the client&# ;s selection date? Do you agree to this requirement? Question7 Three professional references may be required for the role. Do you agree to this requirement?