Cloud Data Warehouse Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Bayforce · 11 hours ago

Cloud Data Warehouse Architect

positionUnited States
timeContract
remoteRemote
senioritySenior Level
date7+ years exp

Bayforce is seeking a Cloud Data Warehouse Architect to design and deliver a next-generation enterprise analytics platform. This highly technical role focuses on building a cloud-native, SAP-integrated, AI-ready architecture that supports analytics, reporting, and advanced machine learning at scale.

Information TechnologyMarketing
check
Comp. & BenefitsbadNo H1Bnote
Hiring Manager
Ginette (Miller) Koeck
linkedin

Responsibilities

Lead the design of a cloud data warehouse and data lakehouse architecture capable of ingesting large-scale transactional and operational data
Define integration strategies for core enterprise systems
Develop a reference architecture leveraging Databricks and Delta Lake as core components
Implement semantic modeling to unify reporting across Tableau, Power BI, and SAP Analytics Cloud (SAC)
Oversee ingestion pipelines for batch (Netezza extracts, flat files, nightly jobs) and near real-time (APIs, streaming) data sources
Optimize query performance through partitioning, clustering, caching, and Delta Lake / warehouse design
Establish reusable ETL/ELT patterns across Databricks notebooks, SQL-based orchestration, and integration with ActiveBatch scheduling
Define and enforce data governance standards including naming conventions, metadata, lineage, and data quality
Partner with Information Security on identity management (Azure AD), encryption, and RBAC/ABAC models
Implement governance tooling such as Azure Purview, SAP metadata catalogs, Databricks Unity Catalog, and Glasswing
Partner with data engineering and visualization teams to deliver governed, high-performance datasets for Tableau, Power BI, SAC, and SAP Fiori
Serve as the technical SME for architects, engineers, and analysts, ensuring alignment with cloud-native best practices
Drive knowledge transfer from legacy platforms (Netezza, Cognos) into the modern analytics ecosystem

Qualification

Cloud data architectureData modelingAzure servicesDatabricksSQL expertiseSAP S/4HANA integrationData governanceMachine learning workflowsCognos to Tableau migrationEmbedded analytics

Required

Bachelor's degree in Computer Science, Engineering, or a related field
7+ years of experience in data engineering, data warehouse architecture, or cloud data architecture
Expertise in Azure services including ADLS, Synapse, Purview, Databricks, networking, and security
Strong proficiency in Databricks (Delta Lake, PySpark, SQL) and/or Snowflake (warehouse design, scaling, security)
Proven experience in data modeling (3NF, star schema, semantic layers)
Deep SQL expertise across cloud and traditional RDBMS platforms (e.g., Netezza, SQL Server, Progress OpenEdge)
Understanding of SAP S/4HANA integration and familiarity with SAP Datasphere

Preferred

Experience migrating from on-prem MPP platforms (such as Netezza) to cloud-native architectures
Familiarity with Cognos to Tableau or Power BI migrations and dashboard optimization
Hands-on experience with SAP Analytics Cloud (SAC) and embedded analytics
Knowledge of machine learning workflows and integration with Databricks MLflow or Azure ML
Strong knowledge of data governance frameworks and tooling (Purview, Unity Catalog, SAC governance)

Company

Bayforce

twittertwittertwitter
company-logo
Bayforce is an information technology company that provides ERP, CRM, and cloud solutions.
dateFounded in 1996
location
Chicago, Illinois, USA
people-size201-500 employees
web-link
http://bayforce.com

Funding

Current Stage
Growth Stage

Recent News

Dayforce, Inc.
Hubexo Selects Dayforce for Workforce Transformation
2025-05-17
GlobeNewswire
Dayforce Reports First Quarter 2025 Results¹
2025-05-07
Dayforce, Inc.
Dayforce Now Available in the Microsoft Azure Marketplace
2025-04-23
Company data provided by crunchbase