Senior Data Solutions Engineer

Personalization Mall; Jericho (NY); On-site; USD 95,000 - 105,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Paid time off

Job summary

1-800-FLOWERS.COM, INC is seeking a Senior Data Solutions Engineer to shape the analytics data layer and own data products for scalable, trusted datasets. You will collaborate with stakeholders and data teams to ensure reliable analytics-ready data assets across BI tools like Sigma and Power BI.

The role emphasizes designing semantic layers, building ELT pipelines, and delivering high-quality data models for AI/advanced analytics use cases, with a senior-level ownership style.

Qualifications

• 5+ years of experience in data analytics, analytics engineering, or data engineering roles.
• Advanced SQL skills and hands-on experience working with Snowflake or similar cloud data warehouses.
• Experience building and maintaining ELT pipelines using tools such as Coalesce.io, dbt, or comparable frameworks.
• Strong experience supporting BI and analytics tools (e.g., Sigma, Power BI, Tableau, Looker).
• Deep understanding of data modeling concepts, including fact and dimension tables and star schemas.
• Proven ability to work directly with business users and translate complex requirements into effective data solutions.
• Strong analytical thinking, attention to detail, and problem-solving skills.

Responsibilities

• Design, build, and own analytics-ready datasets in Snowflake using curated ELT pipelines.
• Develop and maintain Snowflake semantic views to standardize business logic, KPIs, and metric definitions.
• Translate analytical needs into scalable, reusable data solutions for business users.
• Enable and support self-service analytics across BI tools such as Sigma and Power BI.
• Establish and maintain documentation for datasets, metrics, and analytical models.
• Monitor, validate, and improve data quality, performance, and reliability.

Skills

Analytics

SQL

Snowflake

ELT pipelines

Coalesce.io

dbt

Data modeling

BI tools

Stakeholder comms

Analytics

Tools

dbt

Sigma

Power BI

Tableau

Looker

Job description

We are seeking a Senior Data Solutions Engineer to join our growing Data Products & Platforms team. This role is designed for an experienced analytics professional who operates comfortably across analytics and data engineering, serves as a thought partner to the business, and takes ownership of delivering trusted, scalable, analytics-ready data products.

As a senior member of the team, you will play a key role in shaping the analytics data layer, defining standardized metrics and datasets, and enabling high-quality reporting and self-service analytics across the organization. You will work closely with business stakeholders, analytics partners, and data engineering teams to ensure data is reliable, well-documented, and ready to support advanced analytics and AI use cases.

What You’ll Do

• Design, build, and own analytics-ready datasets in Snowflake using curated ELT pipelines (e.g., Coalesce.io)
• Develop and maintain Snowflake semantic views to standardize business logic, KPIs, and metric definitions across teams
• Act as a trusted partner to business stakeholders by translating analytical needs into scalable, reusable data solutions
• Enable and support self-service analytics across BI tools such as Sigma and Power BI
• Establish and maintain clear documentation for datasets, metrics, and analytical models
• Proactively monitor, validate, and improve data quality, performance, and reliability
• Collaborate closely with data engineering and platform teams to evolve and optimize the analytics data layer
• Support AI and advanced analytics initiatives by delivering well-structured, high-quality datasets suitable for forecasting, machine learning, and generative AI
• Contribute senior-level guidance on analytics engineering best practices, data modeling standards, and dataset design

Requirements

• 5+ years of experience in data analytics, analytics engineering, or data engineering roles
• Advanced SQL skills and hands‑on experience working with Snowflake or similar cloud data warehouses
• Experience building and maintaining ELT pipelines using tools such as Coalesce.io, dbt, or comparable frameworks
• Strong experience supporting BI and analytics tools (e.g., Sigma, Power BI, Tableau, Looker)
• Deep understanding of data modeling concepts, including fact and dimension tables and star schemas
• Proven ability to work directly with business users and translate complex requirements into effective data solutions
• Strong analytical thinking, attention to detail, and problem‑solving skills

Preferred Qualifications

• Experience designing or managing semantic layers or metrics layers
• Familiarity with modern data stack best practices and analytics engineering principles
• Experience with data documentation standards, data quality validation, or observability tools
• Exposure to AI, machine learning, or advanced analytics workflows
• Strong communication skills with the ability to influence and collaborate across teams

Why Join Us

• Be part of a modern data organization focused on data as a product
• Work with a contemporary analytics stack including Snowflake, Coalesce.io, Sigma, and Power BI
• Opportunity to operate at a senior level with real ownership and influence
• High-visibility role with meaningful impact on how the business uses, trusts, and scales data

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.

1-800-FLOWERS.COM, INC Participates in E-Verify, for more information:

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Human Resources at 516-237-6000.