Cloud Data Warehouse Architect

• • NO 3rd Party or Sponsorship! Duration: 6 months + contract to hire Location: Remote We are 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. The architect will modernize the current BI and data warehouse environment—currently anchored in IBM Netezza, Cognos, and Tableau—into a scalable, cloud-based architecture. This role requires deep technical expertise in data modeling, cloud-native design, and hybrid architectures that bridge legacy on-premises systems with cloud-first capabilities. Key Responsibilities Architectural Design & Modernization • 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) Data Engineering & Performance • 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 Governance, Security & Compliance • 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 Collaboration & Enablement • 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 Qualifications • 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)