job summary:
The University System of Georgia (USG) Unified ERP Program is replacing legacy systems for human capital management, financials, and student information with a unified Software as a Service (SaaS) solution. The transition requires University of Georgia (UGA) to sustain operational and analytical reporting while establishing a future-state data warehouse and integration foundation. The Data Warehouse Architect will provide dedicated expertise for this work, reducing reporting disruption and supporting reliable access to institutional data during and after implementation.
location: Union City, California
job type: Contract
salary: $90.34 - 100.34 per hour
work hours:
education: Bachelors
responsibilities:
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.
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.
qualifications:
Position Summary
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.
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.
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.
Physical Demands
Work 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.
Impact and Influence
The 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.
skills:
computer use,enterprise data architecture,data governance,data governance standards,data integration,data lake,data access,data flows,data structures,data warehouse,data warehousing,data warehouse architecture,information technology,legacy systems,metadata,Software as a Service (SaaS),student information,Workday,Workday reporting,analytical,communication skills,reliability,Collaboration,access control,architecture,architecture documentation,Advise,data quality,analytical reporting,report development,design recommendations,Technical Design,ERP,human capital management,financials,production support,project leadership,risks,scalability,set design,project stakeholders,state reporting,testing,warehouse design
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
We use AI tools to support our recruiters and interviewers with tasks like note-taking, summarization, and documentation of interviews to ensure they can be fully focused on your conversation. All hiring decisions are made by people.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.