Work Arrangement: Remote
Location Preference: Local candidates strongly preferred
Interview Type: Webcam or In-Person
Employment Type: Contract
Contract Duration: Initial contract through the end of the current fiscal year, with anticipated renewal effective July 1, 2027, subject to budget approval.
Job Overview
We are seeking an experienced Data Warehouse Architect to support a large-scale Enterprise Resource Planning (ERP) modernization initiative involving the transition from legacy enterprise systems to a unified Software as a Service (SaaS) solution.
The Data Warehouse Architect will be responsible for establishing the future-state reporting and analytics architecture, ensuring continuity of operational and analytical reporting throughout the transition to Workday.
The ideal candidate will bring expertise in enterprise data architecture, data warehousing, data lake technologies, data governance, and system integration. This role requires close collaboration with technical teams, business stakeholders, vendors, and reporting teams to develop scalable, reliable, and sustainable data solutions.
Required Knowledge, Skills, and Abilities
Strong knowledge of enterprise data architecture, data warehousing, and modern data lake patterns.
Experience with Workday reporting architecture and enterprise data integration.
Understanding of data governance, data quality, metadata management, privacy, and access control principles.
Ability to evaluate data integration and consumption approaches for reliability, scalability, and maintainability.
Strong analytical, problem-solving, documentation, facilitation, and communication skills.
Ability to collaborate effectively with technical teams, reporting teams, vendors, and business stakeholders.
Ability to balance immediate system transition requirements with long-term architectural objectives.
Key Responsibilities
1. 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 architecture and the role of data lake services in supporting enterprise reporting and analytics.
Establish architecture documentation, technical design standards, and best practices.
Develop a phased technical roadmap to support successful implementation and long-term scalability.
Ensure alignment between Workday reporting capabilities, legacy data systems, and downstream analytics platforms.
2. Data Governance and Legacy Data Planning – 30%
Recommend data governance standards covering data ownership, definitions, quality, metadata, access controls, and appropriate usage.
Develop strategies for retaining, integrating, and accessing legacy data required for historical, operational, and analytical reporting.
Evaluate architectural alternatives and document technical assumptions, dependencies, risks, and design decisions.
Ensure data architecture recommendations align with organizational security, privacy, and compliance requirements.
Support consistent and reliable data access across enterprise reporting environments.
3. Technical Design and Implementation Guidance – 20%
Provide architectural guidance for data integration, warehouse design, and reporting solutions.
Review technical designs to ensure compliance with approved architectural standards.
Collaborate with data integration engineers and report development teams to ensure data structures and feeds support prioritized reporting requirements.
Recommend best practices for data quality validation, testing, deployment, and production support.
Identify opportunities to improve data integration performance, reliability, and maintainability.
4. Stakeholder Collaboration and Knowledge Transfer – 10%
Facilitate architecture discussions with business stakeholders, technical teams, project leadership, and vendors.
Communicate technical recommendations, architectural decisions, and implementation strategies effectively.
Maintain comprehensive architecture documentation and technical decision records.
Provide knowledge transfer to internal technical teams responsible for ongoing system operations and maintenance.
Support cross-functional collaboration to ensure successful implementation of enterprise data solutions.
Project Overview
This position supports a major enterprise modernization initiative focused on replacing legacy human capital management and financial systems with a unified cloud-based ERP platform.
The initiative aims to streamline business processes, improve reporting capabilities, enhance data accessibility, and establish a scalable technology foundation for future analytics and business intelligence requirements.
The selected candidate will play a critical role in defining the enterprise data architecture, maintaining reporting continuity, and supporting successful integration between Workday, legacy systems, and modern data platforms.
Work Environment
Primarily remote work arrangement.
Extended periods of computer-based work may be required.
Occasional in-person meetings with project stakeholders may be necessary.
Local candidates are strongly preferred.