Data Warehouse Architect

VIVA USA Inc

United States

Remote

USD 120,000 - 180,000

Full time

Just now
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

VIVA USA Inc. is seeking a Data Warehouse Architect to define future-state analytics architecture for the University transition to Workday. The role will shape data warehouse, data lake services, and legacy data strategies to support reliable reporting and analytics across the institution.

Working with IT and stakeholders, you will set design standards, document a phased roadmap, and ensure data quality and governance throughout the implementation. Remote work options are available.

Qualifications

  • 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.

Responsibilities

  • 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.
  • 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.
  • 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.
  • 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.

Skills

Data architecture
Data warehousing
Data lake patterns
Data governance
Metadata management
Privacy & access control
Reliability & scalability
Analytical skills
Documentation
Communication
Cross-team collaboration
Future-state design

Job description

Remote

Supervises the coordination of design and security for computer databases to store, track, and maintain a large volume of critical business information.

The Client 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 the client 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.

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.
Skill - Required / Desired - Amount of Experience
  • Experience designing enterprise data warehouse, data lake, or analytics architectures - Required - 5 Years
  • Experience with cloud data platforms, data integration patterns, and enterprise reporting environments - Required - 5 Years
  • Experience establishing data governance, metadata, security, and data access practices - Required - 5 Years
  • Experience with Workday data and reporting, higher education, or large public-sector environments - Required - 5 Years
  • Ability to translate business reporting needs into scalable technical architecture and roadmaps - Required - 5 Years
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.

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Architect
Data Warehouse Architect

BuzzClan • Athens (GA)

On-site
USD 120,000 - 170,000
Senior Data Warehouse Architect
Senior Data Warehouse Architect

Skywalk Global • Athens (GA)

On-site
USD 117,000 - 165,000
UGA Database Architect(816574)
UGA Database Architect(816574)

infini-tek • United States

Remote
USD 120,000 - 180,000
GA-UGA Database Architect (816574)
GA-UGA Database Architect (816574)

AiQualTest LLC • United States

Remote
USD 140,000 - 190,000
GA-UGA Database Architect (816574)
GA-UGA Database Architect (816574)

AiQualTest LLC • Ohio

Remote
USD 140,000 - 190,000
Datawarehouse Architect, Remote, GA, US
Datawarehouse Architect, Remote, GA, US

Intellibee Inc • United States

Remote
USD 130,000 - 180,000
Long-Term Stability
Health Coverage
Future Planning
+1
Database Warehouse Architect
Database Warehouse Architect

Conflux Systems • Georgia

On-site
USD 140,000 - 190,000
Database Architect – Data Warehouse & Workday Reporting
Database Architect – Data Warehouse & Workday Reporting

MaxIT Consulting - Max Corporate Group • Athens (GA)

Remote
USD 124,000 - 179,000
Data Architect / Data Warehouse Architect – Remote Contract
Data Architect / Data Warehouse Architect – Remote Contract

MaxIT Consulting - Max Corporate Group • Athens (GA)

Remote
USD 96,000 - 165,000
Remote Data Warehouse Architect for Enterprise Analytics
Remote Data Warehouse Architect for Enterprise Analytics

VIVA USA Inc • United States

Remote
USD 120,000 - 180,000