Data Analytics Engineer

Rugs USA Inc; New York (NY); Hybrid; USD 110,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

Paid time off

401(k)

Employee discount

Job summary

RugsUSA in Manhattan is seeking a Data Analytics Engineer to design, build, and support our data warehouse and BI platform. You will work with Snowflake, Sigma, Fivetran and dbt to deliver reliable data and actionable insights for stakeholders.

This hybrid role requires on-site presence 3-4 days per week; you will collaborate across teams, model data, build dashboards, and ensure data quality and performance.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems or related technical field.
• Minimum of 2 years in a Software Engineering role with data focus.
• Experience developing and supporting Snowflake, Sigma, Fivetran/dbt stack for enterprise BI.
• Experience in data modeling, ELT/ETL, and CI/CD for data warehousing.
• Experience with Sigma for dashboards and governance is a plus.

Responsibilities

• Stand up data warehouse and BI tooling as part of the enterprise stack.
• Design, implement, maintain and support Fivetran–Snowflake–dbt–Sigma architecture.
• Translate stakeholder requirements into reporting solutions.
• Develop performant data models and visualizations for cross-functional units.
• Collaborate with Enterprise Data Analysts and Data Governance to deliver trusted data.
• Build backend and front-end structures to meet reporting needs.
• Create dashboards from wireframes and ensure data flow accuracy.

Skills

SQL

Data modeling

Data governance

Analytics

Stakeholder collaboration

CI/CD

Self-service BI

Education

Bachelor’s degree in Computer Science, Computer Engineering, Information Systems or related technical field

Tools

Snowflake

Sigma

Fivetran

dbt

Job description

Since launching in 1998, Rugs USA hasestablisheditself as a leading innovative online destination for an extensive variety of high-quality, on-trend area rugs at prices customerswon’tfind anywhere else. Passionate about the impact that the perfect rug brings to a space, we foster close relationships with the designers, artisans, and factories who make our goods, giving us the ability to simplify our business model and deliver exceptional pricing and a vast assortment of styles. By guiding our customers through therugbuying process and offering a curated selection of complementary lighting and accessories,we’vebecome our customers’ ultimate secret weapon in bringing their vision of home to life -atany budget.

Position Overview

The Data Analytics Enginee r designs, builds, and supports RugsUSA's enterprise data warehouse and business intelligence platform. Working closely with business stakeholders and cross-functional teams, this role develops scalable data models, pipelines, and dashboards using the Fivetran, Snowflake, dbt, and Sigma stack to deliver reliable, high-quality data and actionable insights. The role also supports ongoing platform performance, data quality, and self-service analytics across the organization.

This is a hybrid role requiring on-site presence in our Manhattan office 3 to 4 days per week.

Essential Job Functions

• Stand up data warehouse and business intelligence tools
• As part of a results-oriented team, participate in the design, implementation, maintenance and support of our Fivetran > Snowflake > dbt > Sigma data warehouse stack to enable the business to make informed decisions.
• Interact with internal stakeholders to gather/develop functional and technical requirements and translate them into reporting solutions.
• Provide quality and performant data modeling and visualizations solutions to RugsUSA cross functional business units
• Work collaboratively with Enterprise Data Analysts, Data Governance Team to help define, develop and implement solutions and provide services for the enterprise data warehouse.
• Model, design, develop, test and implement the appropriate backend and front-end structures needed to meet business visualization and reporting requirements.
• Build dashboards as required to follow wireframes designs, integrate with backend data models. Build aggregate data models. Manage the data flow to reflect in dashboards to meet business requirements.
• Work on data transformation, using the ELT tools. Build dimension views and fact tables.
• Data formatting and processing to build the foundation layer for dashboards and self-service reporting. Work on data transformation, using the ELT tools. Build dimension views and fact tables.
• Data formatting and processing to build the foundation layer for dashboards and self-service reporting.
• Follow development standards in accordance with UA best practices.

Manage the steady state data warehouse and BI output

• Responsible for the full life cycle of development, from requirements gathering through data transformation coding and report/dashboard design and creation.
• Troubleshoot data anomalies with key stakeholders.
• Responsible for daily support of the data warehouse and associated data marts.
• Coordinate key stakeholders to align with change management processes and to ensure performance, processes and access is optimal for reporting solutions.
• Work collaboratively to align business requirements with reporting and analytical solutions.
• Improve processes regarding data flow and quality to improve data accuracy, viability and value.
• Document development for peer reference and knowledge transfer.
• Interact with the key stakeholders to gather/develop functional and technical requirements and translate them into visualization solutions.
• Educate and empower the business community towards self-serve reporting model.
• Other duties as assigned within area of responsibility.

You Have

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems or related technical field. Followed by minimum of 2 years of progressively responsible experience in a Software Engineering role (e.g. Project Lead, Senior Software Engineer, Software Engineer, etc.).
• Experience developing and supporting the Snowflake, Sigma, Fivetran/dbt platform stack to ensure performance, process, access is optimal for the global reporting solution.
• Experience with dbt as a data orchestration tool.
• Experience with Snowflake Virtual Warehouse (VWH) and data modeling.
• Experience working in CI/CD framework for data warehousing and business intelligence.
• Experience in Technical design of Data Modelling for Snowflake and Sigma to support the ongoing Business requirements formulation process for Enterprise Business Analytics operations.
• Experience in design and development of analytical queries, reports and visualisations utilising the Sigma Platform.
• Experience supporting data analytics, reporting, or business intelligence functions within the retail or e-commerce industry is a nice to have.
• Experience with data governance practices, including data quality standards, access controls, and metadata management within a Snowflake environment.
• Experience building and maintaining semantic layers (e.g., Sigma workbooks/models, dbt metrics layer) to enable consistent, governed self-service reporting.
• Demonstrated knowledge of the following:
• Fivetran HVR (High Volume Replication) enterprise data integration replication for data ingestion.
• Data warehouse architecture, including dimensional modelling, ELT design, and Snowflake-based cloud data platforms.
• SQL and strong data transformation.

Preferred Skills

The ideal candidate is a hands-on data builder with strong SQL, Snowflake, dbt, Fivetran, and Sigma expertise, able to turn messy business needs into clean, scalable data models, reliable pipelines, and sharp self-service dashboards. They bring a strong grasp of data warehouse architecture, governance, quality, and performance, paired with the communication skills to partner with stakeholders, troubleshoot issues quickly, and deliver trusted insights that help the business move faster.

Your Life and Career at RugsUSA

• A culture that promotes a healthy work/life balance
• Benefits package offered to all eligible full-time employees (including medical, dental, vision, PTO, 401(k)
• Exposure to career advancement opportunities across all departments
• Generous employee discount that can be used across our house of brands!

The pay range for this role is:

110,000 - 120,000 USD per year (Manhattan Office)