Senior Data Solutions Engineer

1-800-FLOWERS.COM, INC.; Jericho (NY); On-site; USD 95,000 - 105,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Paid vacation

Employee discount

Holidays

Job summary

1-800-FLOWERS.COM, Inc. is seeking a Senior Data Solutions Engineer to join our Data Products & Platforms team.

You will design analytics-ready datasets in Snowflake, develop robust ELT pipelines, and create semantic views to standardize KPIs for trusted reporting and self-service analytics. As a senior contributor, you’ll partner with business stakeholders to translate needs into scalable data solutions, onboard data across brands, and enable forecasting, ML, and AI initiatives with tools like

Qualifications

• Five+ years in data analytics, analytics engineering, or data engineering.
• Advanced SQL skills with complex queries and transformations.
• Hands-on experience with Snowflake or similar cloud data warehouse.
• Experience building ETL/ELT pipelines (Coalesce.io, dbt or equivalent).
• Strong data modeling knowledge: dimensional models, star schemas.

Responsibilities

• Design, build, and own analytics-ready datasets in Snowflake.
• Develop and maintain ETL/ELT pipelines with Coalesce.io or dbt.
• Create semantic views standardizing KPIs and business logic.
• Collaborate with stakeholders to translate needs into data solutions.
• Onboard data from multiple sources and standardize information across brands.
• Enable self-service analytics via Sigma and Power BI.
• Document datasets, metrics, models, and business rules.
• Monitor data quality and performance; improve reliability.

Skills

SQL

Snowflake

ETL/ELT pipelines

Data modeling

Analytics engineering

Stakeholder communication

Independent ownership

Tools

dbt

Coalesce.io

Sigma

Power BI

Job description

1-800-FLOWERS.COM, Inc. is seeking a Senior Data Solutions Engineer to join our growing Data Products & Platforms team. This role is ideal for an experienced data professional who works comfortably across analytics engineering and data engineering and can translate business needs into trusted, scalable data solutions.

As a senior individual contributor, you will help shape our analytics data layer, standardize business metrics and datasets, and enable high-quality reporting and self-service analytics across the organization. You will partner closely with business stakeholders, analytics teams, and technical partners to onboard data from multiple systems and make it reliable, well-documented, and ready for advanced analytics and AI applications.

What You’ll Do

• Design, build, and own analytics-ready datasets within Snowflake.
• Develop and maintain curated ELT pipelines using Coalesce.io, dbt, or similar tools.
• Create semantic views that standardize business logic, KPIs, and metric definitions.
• Partner directly with business stakeholders to understand data, reporting, and analytical needs.
• Translate complex or ambiguous requirements into scalable, reusable data solutions.
• Onboard data from multiple source systems and standardize information across brands and business areas.
• Develop dimensional data models, including fact and dimension tables and star schemas.
• Enable self-service analytics through platforms such as Sigma and Power BI.
• Establish clear documentation for datasets, metrics, analytical models, and business rules.
• Monitor and improve data quality, performance, accuracy, and reliability.
• Collaborate with data engineering and platform teams to evolve the enterprise analytics data layer.
• Deliver high-quality datasets that support forecasting, machine learning, generative AI, and other advanced analytics initiatives.
• Provide senior-level guidance on analytics engineering practices, data modeling standards, and dataset design.
• Independently own assigned business domains and help drive the enterprise data roadmap.

What We’re Looking For

Required Qualifications

• Five or more years of experience in data analytics, analytics engineering, data engineering, or a related field.
• Advanced SQL skills with experience developing complex queries and data transformations.
• Hands-on experience with Snowflake or another modern cloud data warehouse.
• Experience building and maintaining ETL or ELT pipelines using Coalesce.io, dbt, or a comparable framework.
• Strong understanding of data modeling, including dimensional modeling, fact and dimension tables, and star schemas.
• Experience integrating, standardizing, and normalizing data from multiple source systems.
• Proven ability to work directly with business stakeholders and translate their needs into effective data solutions.
• Strong analytical thinking, attention to detail, and problem-solving skills.
• Ability to work independently, manage ambiguity, and take ownership of projects with limited oversight.
• Strong written and verbal communication skills.

Preferred Qualifications

• Direct experience with Snowflake, Coalesce.io, or dbt.
• Experience designing or managing semantic or metrics layers.
• Familiarity with Sigma, Power BI, Tableau, Looker, or similar business intelligence tools.
• Knowledge of modern data-stack and analytics-engineering best practices.
• Experience with data documentation, testing, quality validation, or observability tools.
• Exposure to forecasting, machine learning, generative AI, or other advanced analytics workflows.
• Experience supporting merchandising, marketing, inventory, costing, or other enterprise business data.

Why Join Us?

• Join a modern data organization that approaches data as a product.
• Work with a contemporary technology stack that includes Snowflake, Coalesce.io, Sigma, and Power BI.
• Take ownership of high-impact data solutions used across multiple business areas.
• Help shape how the organization standardizes, trusts, and scales its data.
• Collaborate with business and technical leaders on highly visible enterprise initiatives.
• Operate with meaningful autonomy while contributing to a close-knit, growing team.

1-800-FLOWERS.COM, Inc. is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

The expected salary range for this position is $95,000 to $105,000 annually. Actual compensation will be determined based on experience, skills, internal equity, and other factors permitted by law.

To support our commitment to being an employer of choice, we offer comprehensive and competitive health, wellness, and additional benefits to eligible full-time team members. Benefit eligibility may vary based on location, average hours worked, and length of service.

Benefits may include*:

• Medical, dental, vision, life, and disability insurance for the associate and eligible dependents
• Flexible Spending Account (FSA)
• Health Savings Account (HSA)
• 401(k) retirement savings program
• Mental health resources and Employee Assistance Program (EAP)
• Paid vacation time (accrued based on hours worked and tenure)
• Paid company holidays
• Employee discount across our family of brands
• Potential eligibility for annual merit-based compensation increases, where applicable

*Exact benefit terms, conditions, and eligibility requirements are governed by official plan documents and applicable law. The Company reserves the right to modify, amend, or terminate benefit plans and programs at any time.