Analytics Engineer

SupplyHouse.com

2d•$72,440 - $108,660•Remote

About The Position

SupplyHouse.com is seeking an Analytics Engineer to join its Finance team. Reporting to the Senior Manager of Data Analytics, this person will design and build the company’s production data layer from the ground up in BigQuery. They will own the transformation layer between raw data and reporting, creating clean, tested, and well-documented datasets, standardizing core business metrics, and enabling trusted self-service analytics across the organization. The position is remote and open to candidates who live in or are willing to relocate to Arizona, Delaware, Florida, Georgia, Kentucky, Nevada, New Jersey, New York, North Carolina, Ohio, Rhode Island, South Carolina, Tennessee, Texas, Virginia, or Washington. Travel to the Melville, New York headquarters is required six times per year for internal meetings and team-building activities; reasonable and necessary travel expenses are reimbursed. Additional onsite work is welcome. The schedule is Monday through Friday, 8:00 a.m. to 5:00 p.m., with time-zone flexibility. Applicants must be authorized to work full-time in the United States; visa sponsorship is not available.

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 applied to analytics, including version control (Git), testing, code review, and CI.
Layered or dimensional data modeling experience and a track record of building maintainable, well-documented datasets.
Must currently be authorized to work in the United States on a full-time basis; the company will not sponsor work visas.

Nice To Haves

Experience 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, particularly Dataform.
Exposure to distribution, e-commerce, HVAC, or plumbing data domains.

Responsibilities

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

Benefits

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 the Employee Assistance Program (EAP).
Company-provided equipment and a 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 team members benefit financially from company growth and accomplishments.
Wellness initiatives and a Flex-Time Policy.
Annual merit and bonus opportunities, hands-on training, diversity and inclusion initiatives, internal mobility options, and professional development opportunities.
Volunteer Paid Time Off.
Reasonable and necessary travel expenses reimbursed for required headquarters visits.