Data Warehouse Architect
Location: Remote – USA
Duration: 6+ Months (Contract)
Employment Type: W2 / C2C
Job Description
We are seeking an experienced Data Warehouse Architect to lead the design and development of an enterprise reporting, analytics, and data warehouse architecture as part of a large-scale transition to Workday.
The client is replacing legacy Human Capital Management (HCM), Financial Management, and Student Information Systems with a unified SaaS-based Workday solution. This initiative requires maintaining existing operational and analytical reporting capabilities while establishing a scalable, secure, and future-ready data warehouse and integration architecture.
The architect will define how Workday reporting, enterprise data warehouses, data lakes, legacy data repositories, and downstream analytics platforms integrate within the future-state enterprise data ecosystem.
The ideal candidate will have strong expertise in enterprise data architecture, cloud data platforms, data governance, data integration, reporting solutions, and preferably Workday data and reporting in higher education or public-sector environments.
Key Responsibilities
Data Architecture & Strategy
Design and establish the future-state enterprise data warehouse and analytics architecture.
Define Workday reporting architecture, data flows, integration patterns, and data consumption strategies.
Establish data lake and data warehouse design standards to support enterprise reporting and analytics.
Develop architecture documentation, technical standards, and phased implementation roadmaps.
Data Governance & Legacy Data Management
Define data governance standards covering data ownership, metadata, data definitions, data quality, security, and access controls.
Develop strategies for retaining and accessing legacy data for historical, operational, and analytical reporting.
Evaluate architectural solutions and document technical assumptions, dependencies, risks, and decisions.
Ensure data privacy, compliance, and appropriate data usage across enterprise systems.
Technical Design & Implementation
Provide architectural guidance for data integration, warehouse development, and reporting solutions.
Collaborate with data engineers and report development teams to ensure data structures and feeds meet reporting requirements.
Review technical designs and ensure alignment with enterprise architecture standards.
Guide data quality validation, testing, deployment, and production support strategies.
Stakeholder Collaboration
Facilitate architecture discussions with IT teams, business stakeholders, vendors, and reporting teams.
Translate business reporting requirements into scalable technical architecture and implementation roadmaps.
Maintain architecture documentation and provide knowledge transfer to internal technical teams.
Required Skills & Qualifications
5+ years of experience designing enterprise Data Warehouse, Data Lake, or Analytics architectures.
5+ years of experience with cloud data platforms, data integration patterns, and enterprise reporting environments.
5+ years of experience in Data Governance, Metadata Management, Data Security, and Data Access Controls.
5+ years of experience with Workday data and reporting, Higher Education, or large Public-Sector environments.
Strong understanding of enterprise data architecture, modern data warehousing, and data lake design patterns.
Experience with data integration, ETL/ELT processes, and enterprise reporting ecosystems.
Knowledge of data quality, data privacy, metadata management, and access control principles.
Ability to evaluate data integration and consumption approaches for scalability, reliability, and maintainability.
Strong analytical, technical documentation, communication, and stakeholder management skills.
Ability to balance immediate migration and reporting requirements with long-term enterprise architecture goals.
Preferred Qualifications
Experience with Workday HCM, Workday Financial Management, and Workday Student.
Experience supporting higher education institutions or large public-sector organizations.
Experience with legacy system modernization and SaaS transformation initiatives.
Experience with cloud-based data warehouse and data lake platforms.
Experience developing enterprise data architecture roadmaps and governance frameworks.