D&H Distributing · 4 days ago
Cloud Data Warehouse Architect
United States
Full-time
Remote
Senior Level
7+ years expD&H Distributing is a 100+ year old Employee-Owned technology distributor seeking a Cloud Data Warehouse Architect to design and deliver their next-generation enterprise analytics platform. This highly technical role involves building a cloud-native architecture that supports analytics and advanced machine learning, while modernizing the current BI and data warehouse environment.
Hardware
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 systems
Develop a reference architecture that leverages Azure Data Lake Storage (ADLS) and Databricks 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 (naming conventions, metadata, lineage, data quality)
Partner with InfoSec 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 engineers and visualization teams to deliver governed, high-performance datasets consumable in Tableau, Power BI, SAC, and SAP Fiori
Serve as the technical SME for architects, engineers, and analysts, ensuring alignment to best practices in cloud-native data warehouse design
Drive knowledge transfer from legacy platforms (Netezza, Cognos) into the new ecosystem
Qualification
Required
Bachelor's degree in Computer Science, Engineering, or related field
7+ years in data engineering, data warehouse architecture, or cloud data architecture
Expertise in Azure (ADLS, Synapse, Purview, Databricks, networking, 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 both cloud and traditional RDBMS (Netezza, SQL Server, Progress OpenEdge)
Understanding of SAP S/4HANA integration and familiarity with SAP Datasphere
Preferred
Prior experience migrating from on-prem Netezza or other MPP systems to cloud-native platforms
Familiarity with Cognos to Tableau/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)
Benefits
Employee Stock Ownership Plan
401k
Paid Time Off
Medical
Prescription
Dental and Vision benefits
Gym Reimbursement
Work from Home Reimbursement
Employee Purchase Program
Tuition Assistance
Company
D&H Distributing
D&H Distributing is a leading technology distributor of IT and electronics offering end-to-end solutions for today's reseller and retailer.
1001-5000 employees
H1B Sponsorship
D&H Distributing has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (3)
2022 (3)
2021 (4)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Izzy Schwab
CEO
Matt Nolan
Chief Financial Officer
Recent News
2025-11-03
Company data provided by crunchbase