Cloud Data Warehouse Architect
This is a fully remote role.
D&H is growing! Join 100+ year old Employee-Owned technology distributor, offering end-to-end solutions for today's resellers, retailers, and the clients they serve across the SMB and Consumer markets.
- We are empowered by our employee Co-Owners who provide the industry's best service, and we promote a collaborative culture.
- We offer an Employee Stock Ownership Plan, 401k, Paid Time Off, Medical, Prescription, Dental and Vision benefits as well as Gym Reimbursement, Work from Home Reimbursement, Employee Purchase Program, Tuition Assistance and much more!
- As a D&H Co-Owner you receive numerous discounts on services.
- We feel strongly about giving back to the community and promoting sustainable, eco-friendly business practices.
SUMMARY
The Cloud Data Warehouse Architect will design and deliver the next-generation enterprise analytics platform. This position is highly technical and will focus on building a cloud-native, SAP-integrated, AI-ready architecture that supports analytics, reporting, and advanced machine learning at scale.
The architect will modernize D&H's current BI and data warehouse environment, anchored today in IBM Netezza, Cognos, and Tableau into a cloud-based architecture.
This role will require deep technical expertise in data modeling, cloud-native design, and hybrid architectures that bridge legacy on-prem systems with cloud-first capabilities.
The Data Science & Insights group is at the center of D&H's analytics transformation. Our mission is to :
Consolidate legacy BI systems (Netezza, Cognos) into a modern cloud architecture.Support the SAP S / 4HANA migration with tight integration into futrestate.Deliver governed, high-performance datasets for self-service analytics in Tableau, Power BI, and SAC.Enable AI / ML use cases through Databricks and Azure ML.Extend analytics capabilities to our partners and vendors via embedded reportingThis is an opportunity to be the hands-on architect shaping D&H's future-state data strategy, working in a fast-paced, hybrid cloud environment that balances innovation with enterprise stability.
ESSENTIAL DUTIES AND 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 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).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 (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.Collaboration & Enablement
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.EDUCATION and / or EXPERIENCE
Education
Bachelor's degree in Computer Science, Engineering, or related field.Experience
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).