Azure Data Warehouse Architect & Workday Prism Integration Lead

Overview

On Site
Full Time

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Partnership
Auditing
Decision-making
Business Continuity Planning
Regulatory Compliance
Cloud Architecture
Public Sector
Data Warehouse
ELT
Roadmaps
Payroll
Finance
Microsoft Power BI
Access Control
Cyber Security
Data Governance
Process Flow
Data Engineering
Cloud Computing
SQL Azure
Data Lake
Migration
Microsoft SQL Server
Reporting
Use Cases
SFTP
API
Communication
Collaboration
Microsoft Azure
Data Warehouse Architecture
SAP
Backup
Replication
Workday
Prism
Analytics
Data Integration
Meta-data Management
Documentation
Extract
Transform
Load
Workflow
Data Dictionary
Knowledge Transfer
Training
Technical Support

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech