Database Architect
Atlanta, GA - USA
Job Summary
Position Summary
The Data Warehouse Architect will establish the future-state reporting and analytics architecture for UGAs 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.
Knowledge Skills and Abilities
Knowledge 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
Duties/Responsibilities
Architecture and Strategy (40%)
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 (30%)
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.
| Required / Desired |
|
|
| Experience designing enterprise data warehouse data lake or analytics architectures | Required |
|
|
| Experience with cloud data platforms data integration patterns and enterprise reporting environments | Required | ||
| Experience establishing data governance metadata security and data access practices | Required | ||
| Experience with Workday data and reporting higher education or large public-sector environments | Required | ||
| Ability to translate business reporting needs into scalable technical architecture and roadmaps | Required |