Analytics Engineer

SupplyHouse.com; United States; À distance; USD 72 000 - 91 000; Plein temps

Avantages offerts par ce poste

Medical, dental, vision, and voluntary

401(k) with company match

Paid vacation, sick time, holidays

Company-paid life insurance & long‑int

Discounts on auto/home/pet insurance

FSA

EAP

Equipment + $250 WFH stipend

Professional development budget

Grubhub credit

Rewards program

Résumé du poste

SupplyHouse.com is seeking an Analytics Engineer to build and own the production data layer in BigQuery. You will transform raw data into clean, documented datasets and standardize core metrics while enabling self-serve analytics across the finance team.

You’ll work with engineers, analysts, and stakeholders, with a remote role open to multiple states and occasional travel to Melville, NY for meetings. This is a full-time exempt position with flexible on-site options beyond travel.

Qualifications

• Bachelor's degree in a quantitative, technical or related field.
• 2+ years of data modeling experience.
• Strong SQL skills with production-ready data models in a cloud DW.
• Hands-on with a data transformation framework such as dbt or Dataform.
• Software engineering fundamentals: version control (Git), testing, CI.

Responsabilités

• Design and build a layered, version-controlled data model in BigQuery using a modern transformation framework (Dataform).
• Migrate business logic out of ad hoc queries into governed, reusable, tested models.
• Define and own canonical definitions of core metrics.
• Implement automated data testing and CI to enforce data quality before changes ship.
• Document models, definitions, and data lineage for knowledge retention.
• Partner with analysts and business stakeholders to enable reliable self-serve reporting.
• Partner with IT to ensure accurate and timely raw data ingestion.
• Evaluate and shape the go-forward BI layer as Power BI is under consideration.

Connaissances

Data Modeling

SQL

Git

CI

Data Transformation Frameworks

Formation

Bachelor's degree in a quantitative, technical, or related field

Outils

BigQuery

dbt

Dataform

Power BI

Description du poste

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 an Analytics Engineer to join our Finance team. This individual will report into our Senior Manager of Data Analytics and will design and build SupplyHouse’s production data layer from the ground up in BigQuery. They will own the transformation layer between raw data and reporting, turning complex data into clean, tested, and well-documented datasets, standardizing core business metrics, and enabling trusted, self-service analytics across the organization. If you’re passionate about building reliable data foundations, enjoy partnering with engineers, analysts, and business stakeholders, and are excited to make high-quality data more accessible and actionable across an organization, we’d love to hear from you!

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 6 times per year for internal meetings and team building activities. 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. with time zone flexibility

Base Salary:** The expected starting salary for the position is $72,440to $90,550** within a full position range of $72,440 to $108,660annually. 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 and build a layered, version-controlled data model in BigQuery using a moderntransformation framework (Dataform).
• Migrate business logic out of hundreds of ad hoc scheduled queries into governed, reusable, testedmodels.
• 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 beforechanges 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 toreconsideration.

Requirements:

• 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

Preferred Qualifications:

• 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

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:** https://www.supplyhouse.com/our-company !

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.