Data Warehouse Architect

Apollo Technology Solutions LLC

Athens (GA)

On-site

USD 120,000 - 180,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Job summary

Apollo Technology Solutions LLC in Athens, GA seeks a Data Warehouse Architect to shape the future-state reporting and analytics architecture for Workday transition. You will define how Workday reporting, the data warehouse, data lake services, legacy data, and downstream analytics integrate and operate.

The role requires expertise in enterprise data architecture, data warehousing, data governance, and modern data lake patterns, with a focus on reliability, scalability, and long-term

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.
  • Experience with Workday data and reporting, higher education, or large public-sector environments.
  • Ability to translate business reporting needs into scalable technical architecture and roadmaps.

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

Skills

Enterprise data warehouse design
Cloud data platforms
Data integration patterns
Data governance & security
Workday data & reporting
Public sector experience
Roadmaps & architecture

Job description

Title: Data Warehouse Architect

Location: Athens, GA

Duration: 6+ Months

Job Description:
  • 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 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:
  • 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
Skills:
  • Experience designing enterprise data warehouse, data lake, or analytics architectures
  • Experience with cloud data platforms, data integration patterns, and enterprise reporting environments
  • Experience establishing data governance, metadata, security, and data access practices
  • Experience with Workday data and reporting, higher education, or large public-sector environments
  • Ability to translate business reporting needs into scalable technical architecture and roadmaps
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
Database Warehouse Architect
Database Warehouse Architect

Conflux Systems • Georgia

On-site
USD 140,000 - 190,000
Senior Data Warehouse Architect
Senior Data Warehouse Architect

Skywalk Global • Athens (GA)

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

AiQualTest LLC • United States

Remote
USD 140,000 - 190,000
Enterprise Data Architect
Enterprise Data Architect

eStaffing Inc. • Georgia

On-site
USD 120,000 - 180,000
UGA Database Architect (816574)
UGA Database Architect (816574)

AiQualTest LLC • Ohio

Remote
USD 140,000 - 190,000
Remote Data Warehouse Architect for Workday & Analytics
Remote Data Warehouse Architect for Workday & Analytics

AiQualTest LLC • Ohio

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

NITELINES USA, INC • Athens (GA)

Remote
USD 114,000 - 162,000
Data Warehouse Architect
Data Warehouse Architect

VIVA • United States

Remote
USD 120,000 - 180,000
Enterprise Data Warehouse & Analytics Architect (Workday)
Enterprise Data Warehouse & Analytics Architect (Workday)

Conflux Systems • Georgia

On-site
USD 140,000 - 190,000