Principal Data Architect at SupplyHouse

Job description

Real people. Real service. At  SupplyHouse.com , we value every individual team member and cultivate a community where people come first. Led by our core values of G enerosity, R espect, I nnovation, T eamwork, and GRIT, we’re dedicated to maintaining a supportive work environment that celebrates diversity and empowers everyone to reach their full potential. As an industry-leading e-commerce company specializing in HVAC, plumbing, heating, and electrical supplies since 2004, we strive to foster growth while providing the best possible experience for our customers. We are looking for a Principal Data Architect to join our IT Team. This individual will report into our Vice President of IT, and will be responsible for defining and driving our enterprise data architecture strategy while remaining hands-on in delivering scalable, reliable data products. This role operates at a company-wide scope, shaping long-term data platform direction, governance standards, and scalable architecture patterns that enable analytics, AI/ML, operational systems, and business intelligence. As a strategic individual contributor, the Principal Data Architect will partner with executive leadership, Engineering, Analytics, Security, and Product teams to ensure data is reliable, secure, governed, and positioned as a competitive advantage. This remote position is open to individuals who live in, or are open to relocating to, the following states:  Arizona, Delaware, Florida, Georgia, Kentucky, Nevada, New Jersey, New York, North Carolina, Ohio, Rhode Island, South Carolina, Tennessee, Texas, Virginia, and Washington. This position requires travel to our headquarters in Melville, NY 3 times per year for internal meetings and team building activities. Additional travel may be required based on department and company needs. We reimburse reasonable and necessary travel expenses, and you’re also welcome to work on-site anytime beyond these visits – our doors are always open. Role Type:  Full-Time, Exempt Location:  Remote Schedule: Monday through Friday, 8:00 a.m. to 5:00 p.m. ET Base Salary:  The expected starting salary for the position is $144,433 to $180,541 within a full position range of $144,433 to $ 216,649 annually. This range reflects the long-term earning potential for the role. Our starting pay practice is the minimum to middle portion of the range, depending on experience, qualifications, and internal equity, consistent with applicable law and it is rare for a new hire to start above the midpoint. Responsibilities: Design, build, and maintain scalable ELT/ETL pipelines into BigQuery for core domains (orders, customers, products, inventory, fulfillment, procurement, marketing) Build orchestration patterns with strong operational rigor (retries, idempotency, backfills, SLAs/SLOs, incident response) to enable reliable delivery Implement data quality and testing frameworks (freshness checks, anomaly detection, unit/integration tests) and standardize monitoring/observability Standardize CI/CD and infrastructure-as-code patterns for data systems and guide teams on best practices for ingestion, transformation, and orchestration Lead modernization initiatives such as legacy warehouse to cloud lakehouse migrations and platform upgrades Create and own curated, analytics-ready datasets and models (dimensional/conformed, semantic-ready layers) that make reporting fast, consistent, and self-serve Establish and enforce standards for conceptual, logical, and physical data modeling Oversee domain-driven modeling and data product design through reusable patterns and reference implementations Establish data architecture standards including modeling conventions, schema evolution/versioning, incremental loading strategies, and warehouse performance patterns Define and evolve the enterprise data architecture vision aligned to business strategy, including canonical data models, domain boundaries, and integration patterns Lead architecture decisions for data warehousing, lakehouse, streaming, MDM, and operational data platforms Evaluate and select strategic data technologies and vendors Partner with Security and Legal to design privacy and compliance architectures (GDPR/CCPA/SOC2-aligned approaches) and establish enterprise governance frameworks Build governance fundamentals including documentation, lineage/metadata, access controls, and PII handling Act as the escalation point for data architecture decisions and mentor senior engineers/architects through reviews, templates, and best practices Partner with application engineering and analytics stakeholders to define data contracts and ensure reliable upstream/downstream integrations Translate business capabilities into scalable data platform solutions Optimize cost and performance across BigQuery workloads (query optimization, partition pruning, clustering strategies, and workload management where applicable) Drive adoption of emerging capabilities (real-time analytics, AI enablement, semantic layers, data mesh) and develop multi-year data roadmap and maturity models Operate at enterprise scope across multiple business domains Influence strategy beyond the immediate team and set technical direction that others follow Requirements: Bachelor's degree in CS, Engineering, Information Systems, or a related field A minimum of 10 years of experience in Data Engineering, Architecture, or Platform Engineering A minimum of 5 years of experience designing enterprise-scale cloud data architectures (AWS, Azure, or GCP) Expertise in data warehousing, Lakehouse architecture, distributed processing, streaming, and enterprise data modeling (Kimball, Inmon, Data Vault, and/or domain-driven design) Strong understanding of data governance, metadata management, and security architecture Experience leading cross-functional architecture initiatives Proven ability to influence senior stakeholders and executives Preferred Qualifications: A minimum of 7 years of experience in Data Engineering, Analytics Engineering, or Data Platform roles with significant production ownership Deep experience with GCP services relevant to data engineering (e.g., Cloud Storage, Pub/Sub, Dataflow, Cloud Composer, Cloud Functions/Run, Secret Manager, IAM) Experience with BigQuery best practices (partitioning/clustering, incremental strategies, performance tuning, cost controls) Strong understanding of BI consumption needs (star schema design, incremental refresh considerations, semantic consistency/metrics definitions) Experience implementing data mesh or domain-oriented ownership models, AI/ML feature platform exposure, regulated environment experience, and strong cloud cost management acumen Industry certifications (AWS Solutions Architect, Azure Architect, GCP Professional Architect) Why work with us: We have awesome benefits – We offer a wide variety of benefits to help support you and your loved ones. These include: Comprehensive and affordable medical, dental, vision, and voluntary life insurance options 401(k) with up to 4% company match Paid vacation, sick time, and holidays Company-paid basic life insurance and long-term disability Discounted auto, home, and pet insurance programs Flexible Spending Account (FSA) Confidential mental health, financial planning, and legal support through our Employee Assistance Program (EAP) Company-provided equipment and one-time $250 work from home stipend $750 annual professional development budget $25 monthly Grubhub credit Company rewards and recognition program And more! We empower ownership – We all contribute to our success and we all share in it. Our Ownership for All program ensures each SupplyHouse team member will benefit financially from the company’s growth and accomplishments. We promote work-life balance  – We value your time and encourage a healthy separation between your professional and personal life to feel refreshed and recharged. Look out for our wellness initiatives and ask about our Flex-Time Policy! We support growth  – We encourage you to embrace continuous learning and take on new challenges. In an exciting and evolving industry, we provide opportunities for career growth through our annual merit and bonus opportunities, hands-on training, diversity and inclusion initiatives, internal mobility options, and professional development budget. We give back  – We live and breathe our core value, Generosity, by giving back to the trades and organizations around the world. We make a difference through donation drives, employee-nominated contributions, support for non-profit organizations, Volunteer Paid Time Off, and more. We listen  – We value hearing from our employees. Everyone has a voice, and we encourage you to use it! We actively elicit feedback through our monthly town halls, regular 1:1 check-ins, employee listening initiatives, and company-wide ideas form to incorporate suggestions and ensure our team enjoys coming to work every day. Check us out and learn more at:  supplyhouse.com ! Additional Details: Remote employees are expected to work in a distraction-free environment. Personal devices, background noise, and other distractions should be kept to a minimum to avoid disrupting virtual meetings or business operations. Applicants must be currently authorized to work in the U.S. on a full-time basis. SupplyHouse.com will not sponsor applicants for work visas. SupplyHouse.com is an Equal Opportunity Employer. We welcome and encourage individuals of all backgrounds, experiences, and perspectives to apply. Employment decisions are based on qualifications, merit, and business needs. To ensure fairness and trust in our hiring process, we ask that all application materials, assessments, and interview responses reflect your own thinking and perspective. You may use AI tools to assist in preparing your responses, as long as this use is clearly disclosed and you can speak authentically to your ideas and work. Our focus is on honesty, judgment, and how you approach problem-solving. We appreciate your transparency and look forward to learning more about your skills. We are committed to providing a safe and secure work environment and conduct thorough background checks on all potential employees in accordance with applicable laws and regulations. All emails from the SupplyHouse team will only be sent from an @supplyhouse.com email address. Please exercise caution if you receive an email from an alternate domain.

Requirements

Must-haves

Real people. Real service.
Role Type:  Full-Time, Exempt
Location:  Remote
Schedule: Monday through Friday, 8:00 a.m. to 5:00 p.m. ET
Design, build, and maintain scalable ELT/ETL pipelines into BigQuery for core domains (orders, customers, products, inventory, fulfillment, procurement, marketing)
Build orchestration patterns with strong operational rigor (retries, idempotency, backfills, SLAs/SLOs, incident response) to enable reliable delivery
Implement data quality and testing frameworks (freshness checks, anomaly detection, unit/integration tests) and standardize monitoring/observability
Standardize CI/CD and infrastructure-as-code patterns for data systems and guide teams on best practices for ingestion, transformation, and orchestration
Lead modernization initiatives such as legacy warehouse to cloud lakehouse migrations and platform upgrades
Create and own curated, analytics-ready datasets and models (dimensional/conformed, semantic-ready layers) that make reporting fast, consistent, and self-serve
Establish and enforce standards for conceptual, logical, and physical data modeling
Oversee domain-driven modeling and data product design through reusable patterns and reference implementations
Establish data architecture standards including modeling conventions, schema evolution/versioning, incremental loading strategies, and warehouse performance patterns
Define and evolve the enterprise data architecture vision aligned to business strategy, including canonical data models, domain boundaries, and integration patterns
Lead architecture decisions for data warehousing, lakehouse, streaming, MDM, and operational data platforms
Evaluate and select strategic data technologies and vendors
Partner with Security and Legal to design privacy and compliance architectures (GDPR/CCPA/SOC2-aligned approaches) and establish enterprise governance frameworks
Build governance fundamentals including documentation, lineage/metadata, access controls, and PII handling
Act as the escalation point for data architecture decisions and mentor senior engineers/architects through reviews, templates, and best practices

Nice-to-haves

Deep experience with GCP services relevant to data engineering (e.g., Cloud Storage, Pub/Sub, Dataflow, Cloud Composer, Cloud Functions/Run, Secret Manager, IAM)
Experience with BigQuery best practices (partitioning/clustering, incremental strategies, performance tuning, cost controls)
Strong understanding of BI consumption needs (star schema design, incremental refresh considerations, semantic consistency/metrics definitions)
Experience implementing data mesh or domain-oriented ownership models, AI/ML feature platform exposure, regulated environment experience, and strong cloud cost management acumen
Industry certifications (AWS Solutions Architect, Azure Architect, GCP Professional Architect)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aimlci/cdawsazuregcp

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Wellness

Professional Development