Analytics Engineer
SupplyHouse.com23 days ago
Remote, United StatesMid Level
Base Salary
$72k - $91k/yr
Responsibilities
- Design and build a layered, version-controlled data model in BigQuery using Dataform.
- Migrate business logic from ad hoc scheduled queries into governed, reusable, tested models.
- Define and maintain canonical definitions for core business metrics.
- Implement automated data testing and continuous integration to enforce data quality.
- Document models, definitions, and data lineage.
- Partner with analysts and business stakeholders to enable reliable self-service reporting.
- Partner with IT to support accurate and timely raw data ingestion.
- Help evaluate and shape the future BI layer, including the current Power BI setup.
Requirements
- Bachelor’s degree in a quantitative, technical, or related field.
- At least 2 years of data modeling experience.
- Strong SQL skills and hands-on experience building production-ready data models in a cloud data warehouse.
- Hands-on experience with a data transformation framework such as dbt, Dataform, or a comparable tool.
- Software engineering fundamentals including Git, testing, code review, and continuous integration.
- Experience with layered or dimensional data modeling and maintainable, well-documented datasets.
- Preferred qualifications include Google BigQuery, Google Cloud Dataform, building a data model or semantic layer from scratch, Google Cloud tooling, and distribution, e-commerce, HVAC, or plumbing data domains.
Benefits
- Remote, full-time exempt position with a Monday–Friday, 8:00 a.m.–5:00 p.m. schedule and time zone flexibility, available in specified states.
- Travel to headquarters in Melville, New York, six times per year; reasonable and necessary travel expenses are reimbursed.
- Medical, dental, vision, voluntary life, company-paid basic life, and long-term disability insurance.
- 401(k) with up to a 4% company match.
- Paid vacation, sick time, holidays, and Volunteer Paid Time Off.
- Company-provided equipment and a one-time $250 work-from-home stipend.
- $750 annual professional development budget and a $25 monthly Grubhub credit.
- Flexible Spending Account, Employee Assistance Program, insurance discounts, wellness initiatives, professional development, training, merit and bonus opportunities, and employee rewards programs.
About SupplyHouse.com
SupplyHouse.com is an e-commerce distributor of plumbing, heating, and HVAC supplies for contractors, facilities teams, and homeowners. The company sells parts and equipment from major manufacturers via its online storefront and ships from U.S. distribution centers, including locations in Ohio, New Jersey, Nevada, and Texas. Founded in 2004 and headquartered in Melville, New York, it operates as a privately held business focused on trade-grade products and fast fulfillment.