Data Analytics Engineer

About the company

Since launching in 1998, Rugs USA has established itself as a leading innovative online destination for an extensive variety of high-quality, on-trend area rugs at prices customers won’t find 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 the rug buying process and offering a curated selection of complementary lighting and accessories, we’ve become our customers’ ultimate secret weapon in bringing their vision of home to life—at any budget.

About the role

The Data Analytics Engineer 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.

Responsibilities

• Stand up data warehouse and business intelligence tools:
  • Design, implement, maintain, and support the Fivetran > Snowflake > dbt > Sigma data warehouse stack to enable data-driven decision-making.
  • Gather and develop functional and technical requirements from internal stakeholders and translate them into reporting solutions.
  • Provide quality and performant data modeling and visualization solutions to cross-functional business units.
  • Collaborate with Enterprise Data Analysts and the Data Governance Team to define, develop, and implement solutions for the enterprise data warehouse.
  • Model, design, develop, test, and implement backend and front-end structures to meet business visualization and reporting requirements.
  • Build dashboards following wireframe designs, integrate with backend data models, and manage data flow to meet business requirements.
  • Develop aggregate data models, dimension views, and fact tables using ELT tools for data transformation.
  • Perform data formatting and processing to build the foundation layer for dashboards and self-service reporting.
  • Follow development standards in accordance with best practices.
• Manage the steady state data warehouse and BI output:
  • Oversee 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.
  • Provide daily support for the data warehouse and associated data marts.
  • Coordinate with key stakeholders to align change management processes and ensure optimal performance, processes, and access for reporting solutions.
  • Align business requirements with reporting and analytical solutions.
  • Improve processes regarding data flow and quality to enhance data accuracy, viability, and value.
  • Document development for peer reference and knowledge transfer.
  • Educate and empower the business community toward a self-serve reporting model.
  • Perform other duties as assigned within the area of responsibility.

Requirements

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or a related technical field.
• Minimum of 2 years of progressively responsible experience in a Software Engineering role (e.g., Project Lead, Senior Software Engineer, Software Engineer).
• Experience developing and supporting the Snowflake, Sigma, Fivetran/dbt platform stack to ensure optimal performance, process, and access for global reporting solutions.
• Experience with dbt as a data orchestration tool.
• Experience with Snowflake Virtual Warehouse (VWH) and data modeling.
• Experience working in a CI/CD framework for data warehousing and business intelligence.
• Technical design experience in data modeling for Snowflake and Sigma to support ongoing business requirements for Enterprise Business Analytics operations.
• Experience in the design and development of analytical queries, reports, and visualizations using the Sigma Platform.
• Experience supporting data analytics, reporting, or business intelligence functions within the retail or e-commerce industry is a plus.
• 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.

Skills

• Fivetran HVR (High Volume Replication) for data ingestion.
• Data warehouse architecture, including dimensional modeling, ELT design, and Snowflake-based cloud data platforms.
• Strong SQL and data transformation 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.

Benefits

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

Pay

110,000 - 120,000 USD per year.

Schedule

Hybrid role requiring on-site presence in the Manhattan office 3 to 4 days per week.