Sr. Data Architect

Overview

Real people. Real service. , we value every individual team member and cultivate a community where people come first. Led by our core values of Generosity, Respect, Innovation, Teamwork, 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 Sr. 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 Sr. 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. EST

Base Salary: $145,000 – $180,000 per year

• Design, build, and maintain scalable ELT/ETL pipelines into Big Query 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…