Analytics Engineer

Summary

SupplyHouse.com is an industry-leading e-commerce company specializing in HVAC, plumbing, heating, and electrical supplies. The Analytics Engineer will build the company’s production data layer in BigQuery, own the transformation layer between raw data and reporting, standardize business metrics, and enable trusted self-service analytics. The role also involves data quality testing, documentation, stakeholder partnership, and shaping the future BI layer.

Responsibilities

• Design and build a layered, version-controlled data model in BigQuery using a modern transformation framework (Dataform)
• Migrate business logic out of hundreds of ad hoc scheduled queries into governed, reusable, tested models
• Work with the team to define and own the canonical definitions of core business metrics
• Implement automated data testing and continuous integration so data quality is enforced before changes ship
• Document models, definitions, and data lineage so knowledge lives in the system
• Partner with analysts and business stakeholders to build a foundation that supports reliable self-serve reporting
• Partner with analysts and business stakeholders to build a foundation that supports reliable self-serve reporting
• Partner with IT to support accurate and timely raw data ingestion from the IT side
• Help evaluate and shape the go-forward BI layer, given that the current Power BI setup is open to reconsideration

Skills

• Bachelors degree in a quantitative, technical, or related field
• 2+ years of data modeling experience
• Strong SQL skills and hands-on experience building production-ready data models within a cloud data warehouse
• Hands-on experience using a data transformation framework, such as dbt, Dataform, or a comparable tool
• Software engineering fundamentals applied to analytics: version control (Git), testing, code review, and CI
• Layered or dimensional data modeling experience, with a track record of maintainable, well-documented datasets
• 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
• Experience working with Google BigQuery as a cloud data warehouse
• Experience using Google Cloud Dataform to build and manage data transformations
• Direct experience standing up a data model or semantic layer from scratch
• Familiarity with Google Cloud tooling and Dataform specifically
• Exposure to distribution, e-commerce, HVAC, or plumbing data domains

Qualifications

Must Haves

• Bachelors degree in a quantitative, technical, or related field
• 2+ years of data modeling experience
• Strong SQL skills and hands-on experience building production-ready data models within a cloud data warehouse
• Hands-on experience using a data transformation framework, such as dbt, Dataform, or a comparable tool
• Software engineering fundamentals applied to analytics: version control (Git), testing, code review, and CI
• Layered or dimensional data modeling experience, with a track record of maintainable, well-documented datasets
• 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

Nice to Haves

• Experience working with Google BigQuery as a cloud data warehouse
• Experience using Google Cloud Dataform to build and manage data transformations
• Direct experience standing up a data model or semantic layer from scratch
• Familiarity with Google Cloud tooling and Dataform specifically
• Exposure to distribution, e-commerce, HVAC, or plumbing data domains

Benefits

• Remote position
• Reasonable and necessary travel expenses reimbursed for required travel to headquarters in Melville, NY
• 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
• One-time $250 work from home stipend
• $750 annual professional development budget
• $25 monthly Grubhub credit
• Company rewards and recognition program
• Ownership for All program, through which each SupplyHouse team member will benefit financially from the company’s growth and accomplishments
• Wellness initiatives
• Flex-Time Policy
• Annual merit and bonus opportunities
• Hands-on training
• Diversity and inclusion initiatives
• Internal mobility options
• Professional development budget
• Volunteer Paid Time Off
• Donation drives
• Employee-nominated contributions
• Support for non-profit organizations
• Monthly town halls
• Regular 1:1 check-ins
• Employee listening initiatives
• Company-wide ideas form