Analyst, Reporting & Analytics

800flowerscareers; Westerville (OH); On-site; USD 60,000 - 70,000; Full time

Benefits offered by this job

Medical insurance

401(k) retirement plan

Paid vacation

Holidays

Job summary

800flowerscareers seeks a technically strong Analyst to join the Enterprise Customer Care Reporting & Analytics team. You will bridge business needs and data-driven solutions, turning complex data into clear insights.

You will work with Snowflake, Sigma, Power BI, SSMS, SQL, and Excel to understand data flows and support decision-making. Expect focus on reporting, data quality, and documentation.

Qualifications

• Bachelor's degree or equivalent combination of education and relevant experience.
• 1-3 years of experience working with data, reporting, analytics, databases, or related functions.
• Strong proficiency in Excel, Snowflake, and Sigma with experience working with large datasets.
• Strong SQL skills and experience querying, analyzing, and validating data within Snowflake or a comparable cloud data warehouse.
• Working knowledge of SQL also with SQL Server Management Studio (SSMS) preferably with Microsoft Dataverse.
• Experience with one or more analytical or programming tools such as Python, R, VBA, or similar technologies is preferred.
• Strong analytical and problem-solving skills with the ability to work with complex datasets and translate findings into meaningful business insights.
• Solid understanding of data modeling concepts, including fact and dimension tables.
• Experience defining and documenting business metrics, business rules, and data definitions.
• Strong attention to detail with an emphasis on data accuracy, validation, and consistency.
• Ability to communicate complex data concepts clearly to both technical and non-technical audiences.
• Ability to manage multiple priorities and deliverables in a fast-paced, cross-functional environment.
• Willingness to learn new technologies, data sources, business processes, and Customer Care operations.

Responsibilities

• Analyze performance trends, patterns, and key drivers to identify meaningful business insights and opportunities to improve customer experience and operational performance.
• Translate analytical findings into clear, actionable insights and recommendations for business leaders.
• Partner with Enterprise Customer Care leaders and cross-functional stakeholders to gather, clarify, and document reporting, analytics, and data requirements.
• Develop understanding of Customer Care operations and KPIs measuring customer experience and service levels.
• Support recurring daily, weekly, monthly, seasonal, and ad-hoc reporting and analytics needs.
• Define and document business metrics, data definitions, and reporting logic to promote consistency across reporting and analytics.
• Translate business requirements into structured documentation including data requirements, business rules, transformation logic, mapping specifications, and reporting requirements.
• Validate delivered data solutions and reporting products against documented requirements.

Skills

Excel

Snowflake

Sigma

SQL

SSMS

Python

R

VBA

Education

Bachelor's degree or equivalent

Tools

Power BI

Job description

We are seeking a technically strong, analytical, and detail-oriented Analyst to join our Enterprise Customer Care Reporting & Analytics team. This role is ideal for someone who excels at bridging the gap between business needs and data-driven solutions and enjoys turning complex data into clear, actionable insights.

In this role, you will work closely with Enterprise Customer Care leaders and cross-functional business partners to understand reporting and analytical needs, define and document key metrics, analyze performance, and ensure stakeholders have access to accurate and meaningful information to support decision-making.

You will work within our modern data environment, including Snowflake, Sigma, Power BI, SQL Server Management Studio (SSMS), SQL, and Excel, to understand how data flows through the organization and how it is ultimately used in reporting and analytics.

The focus is on reporting, analysis, requirements definition, data quality, documentation, and translating business needs into actionable data solutions, while maintaining a strong technical understanding of the underlying data.

What You'll Do

• Analyze performance trends, patterns, and key drivers to identify meaningful business insights, emerging issues, and opportunities to improve the customer experience and operational performance.
• Translate analytical findings into clear, actionable insights and recommendations, helping business leaders understand what is driving performance and where focused action may have the greatest impact.
• Partner with Enterprise Customer Care leaders and cross-functional stakeholders to gather, clarify, and document reporting, analytics, and data requirements.
• Develop a strong understanding of Customer Care operations and the metrics and KPIs used to measure customer experience, service levels, productivity, quality, and overall operational performance.
• Support recurring daily, weekly, monthly, seasonal, and ad-hoc reporting and analytics needs across Enterprise Customer Care.
• Define and document business metrics, data definitions, and reporting logic to promote consistency across reporting and analytics.
• Translate business requirements into clear, structured documentation, including data requirements, business rules, transformation logic, mapping specifications, and reporting requirements.
• Validate delivered data solutions and reporting products to ensure they meet documented business requirements and produce expected results.
• Identify data gaps, inconsistencies, anomalies, and data quality issues and work with appropriate partners to determine root causes and solutions.
• Develop and maintain reporting, dashboards, and data visualizations that enable stakeholders to quickly understand business performance and make informed decisions.
• Support the continued evolution of reporting from manual and legacy processes toward scalable, automated, and self-service analytics solutions.
• Continually evaluate existing reporting and analytical processes to identify opportunities to improve accuracy, efficiency, scalability, and business value.

• Bachelor's degree or equivalent combination of education and relevant experience.
• 1-3 years of experience working with data, reporting, analytics, databases, or related functions.
• Strong proficiency in Excel, Snowflake, and Sigma with experience working with large datasets.
• Strong SQL skills and experience querying, analyzing, and validating data within Snowflake or a comparable cloud data warehouse.
• Working knowledge of SQL also with SQL Server Management Studio (SSMS) preferably with Microsoft Dataverse.
• Experience with one or more analytical or programming tools such as Python, R, VBA, or similar technologies is preferred.
• Strong analytical and problem‑solving skills with the ability to work with complex datasets and translate findings into meaningful business insights.
• Solid understanding of data modeling concepts, including fact and dimension tables.
• Experience defining and documenting business metrics, business rules, and data definitions.
• Strong attention to detail with an emphasis on data accuracy, validation, and consistency.
• Ability to communicate complex data concepts clearly to both technical and non‑technical audiences.
• Ability to manage multiple priorities and deliverables in a fast-paced, cross‑functional environment.
• Willingness to learn new technologies, data sources, business processes, and Customer Care operations.

Preferred Qualifications

• Experience working with Customer Care metrics such as service level, response time, handle time, customer satisfaction, quality, productivity, contact volume, and related operational KPIs.
• Experience with data documentation.
• Familiarity with data quality methodologies and root‑cause analysis.
• Advanced proficiency with Excel, Snowflake, and Sigma with experience working with large datasets.
• Experience supporting the transition from legacy or manually maintained reporting to modern self‑service analytics solutions.

What Success Looks Like

Success in this role means becoming a trusted analytical partner to Enterprise Customer Care and the teams that support it. You will develop a strong understanding of both the business and its underlying data, ensure that reporting and metrics are accurate and consistently defined, and help stakeholders move from asking "What happened?" to understanding "Why did it happen, and what should we do next?"

You will also play an important role in modernizing how Customer Care uses data - helping move the organization toward more scalable, governed, and actionable reporting and analytics.

Why Join Us

• Join a team focused on using data to improve both the customer experience and operational performance.
• Work within a modern analytics ecosystem that includes Snowflake, Sigma, and Power BI.
• Partner directly with business leaders, analysts, data engineers, and other teams across the Enterprise.
• Gain exposure to both analytics and the technical foundations that enable modern reporting.
• Help shape how Enterprise Customer Care defines, measures, and uses its most important performance indicators.
• Have meaningful visibility and impact on how data is used to make business decisions across the organization.

Compensation & Benefits

The expected salary range for this position is $60,000 to $70,000 annually, which 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.