Azure Data Warehouse Architect AND Workday Prism Integration

Hi,

Hope you are doing well.

Job Title: Azure Data Warehouse Architect"

Location: MD (Location: Hybrid Remote with periodic onsite meetings in [State Capital]

Position Overview:
The agency is seeking a contract Data Warehouse Architect / Engineer to lead the design and implementation of a modern Azure data warehouse, including the migration of SAP data, planning for Workday Prism Analytics integration, and knowledge transfer to agency IT staff. The ideal candidate will bring strong cloud architecture experience, a track record of delivering secure and scalable data platforms, and the ability to collaborate across functional and technical teams in a public sector environment.

Key Responsibilities:

• Assess the existing on-prem SQL Server/SAP environment
  
  Design and implement an Azure-based data warehouse solution (Synapse, Azure SQL, or Data Lake)
  
  Build ETL/ELT pipelines for the migration of historical SAP data to the cloud
  
  Design and implement local backup/replication strategies to meet continuity requirements
  
  Develop a roadmap for integrating Workday Prism Analytics datasets
  
  Collaborate with business teams to define unified data models (HR, Payroll, Finance)
  
  Enable Power BI and Prism-based analytics and reporting
  
  Implement role-based access controls, auditability, and retention policies
  
  Align with state cybersecurity requirements and agency data governance protocols
  
  Produce documentation including architecture diagrams, data dictionaries, and process flows
  
  Deliver structured knowledge transfer sessions to internal agency staff
  
  Provide technical runbooks and best practice guides for ongoing support
  
  Support post-deployment transition and hand-off

Qualifications:

• 7+ years of experience in data warehouse architecture or data engineering
  
  Deep experience with Azure cloud services (Azure SQL, Synapse, Data Factory, Data Lake)
  
  Proven expertise in migrating on-prem SQL Server environments to Azure
  
  Familiarity with SAP data models and reporting use cases
  
  Experience integrating or supporting Workday Prism Analytics (strongly preferred)
  
  Knowledge of SFTP, API-based integrations, and hybrid architecture planning
  
  Strong communication, documentation, and collaboration skills

Deliverables:

• Azure data warehouse architecture and implementation plan
  
  Migrated SAP dataset with backup/replication strategy
  
  Workday Prism Analytics data integration plan
  
  Metadata documentation, ETL workflows, and data dictionary
  
  Knowledge Transfer Plan and training sessions
  
  Post-implementation support and stabilization checklist