Data Insights & Reporting Analyst

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

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.