Today
Top Secret/SCI
Unspecified
Unspecified
Baltimore, MD (On-Site/Office)
Job Description: Azure Data Warehouse Architect & Workday Prism Integration Lead
Location: Hybrid - Remote with periodic onsite meetings in [State Capital]
Engagement Type: Contract (approx. 6-12 Months with extension)
Project Summary:
A state government agency is undergoing a modernization effort to transition from its legacy SAP system to Workday. SAP
is currently hosted locally on a Microsoft SQL Server with limited integrations, including SFTP to at least two downstream systems. As part of the
broader transformation effort, the agency seeks to establish a cloud-native data warehouse on Azure, with support for future-state analytics via Workday
Prism Analytics.
With SAP scheduled to be sunset, the agency intends to preserve historical data for reporting, auditing, and decision-making purposes. In addition to cloud
deployment, the agency has expressed a requirement to replicate and/or store data locally as a backup to ensure business continuity and compliance with
internal retention policies.
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
Contract Duration:
3-6 months, with potential for extension based on scope and downstream projects
Reports To:
Agency CIO / Program Sponsor
Location: Hybrid - Remote with periodic onsite meetings in [State Capital]
Engagement Type: Contract (approx. 6-12 Months with extension)
Project Summary:
A state government agency is undergoing a modernization effort to transition from its legacy SAP system to Workday. SAP
is currently hosted locally on a Microsoft SQL Server with limited integrations, including SFTP to at least two downstream systems. As part of the
broader transformation effort, the agency seeks to establish a cloud-native data warehouse on Azure, with support for future-state analytics via Workday
Prism Analytics.
With SAP scheduled to be sunset, the agency intends to preserve historical data for reporting, auditing, and decision-making purposes. In addition to cloud
deployment, the agency has expressed a requirement to replicate and/or store data locally as a backup to ensure business continuity and compliance with
internal retention policies.
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
Contract Duration:
3-6 months, with potential for extension based on scope and downstream projects
Reports To:
Agency CIO / Program Sponsor
group id: 10290999
