Data & Analytics Manager

Tricoci Salon | Spa
Schaumburg, United States of America
11 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 150K

Job location

Schaumburg, United States of America

Tech stack

Microsoft Excel
Databases
Data Warehousing
Software Debugging
Python
Netsuite
Powerpivot
Power BI
SQL Databases
Powerquery
Data Analytics
Workday

Job description

The Data & Analytics Manager is responsible for turning our newly built data warehouse into the dashboards, reporting, and analytics that run the business. In this role, you will partner closely with FP&A on financial reporting and the close cycle, and serve as the trusted analytics partner for Operations, Marketing, Retail, CPG, and Med Spa leaders. The role touches all aspects of the business and is highly visible to senior leadership., * Design, build, and maintain dashboards and reporting across finance, retail, CPG, marketing, operations, and med spa.

  • Own the Power BI environment - semantic models, datasets, governance, and refresh health.
  • Partner with FP&A on monthly reporting, close-cycle variance analytics, budget reporting, and MBR/QBR data.
  • Build customer and marketing analytics - CAC, LTV, cohort, retention, and campaign post-mortems.
  • Build operating analytics - utilization, technician performance, salon menu, retention, and Operations Review reporting.
  • Stand up CPG reporting across brands and channels (DTC, retail, marketplace).
  • Write and optimize SQL against the data warehouse; partner with the data team on data quality and pipeline issues.
  • Lead migration of legacy direct-database and file-based reports onto the new warehouse; consolidate duplicate models.
  • Define KPI standards and metric definitions in partnership with finance and business stakeholders.
  • Conduct ad-hoc analyses to answer specific business questions and support strategic decision-making.

Requirements

Do you have experience in Scenario analysis?, * 7+ years of progressive BI and analytics experience, with hands-on ownership of a Power BI (or comparable) environment. Multi-unit retail, services, hospitality, or consumer industry experience strongly preferred.

  • Expert-level Power BI - semantic model design, DAX, dataflows, gateways, and workspace governance.
  • Fluent SQL - you can write, optimize, and debug complex queries independently against a modern warehouse.
  • Hands-on experience building customer analytics from first principles (CAC, LTV, cohort, retention).
  • Proven partner to FP&A or finance teams - you understand close cycles, budget vs actuals, and how financial reporting needs to tie.
  • Experience cleaning up and governing a fragmented BI environment.
  • Expert Excel - Power Pivot, Power Query, scenario modeling.
  • Strong written and verbal communication; able to present confidently to executives.
  • Experience with NetSuite or Workday Adaptive Planning a plus.
  • Familiarity with Python, R, or modern data-stack tools a plus.

Benefits & conditions

1450 American Lane, Schaumburg, IL 60173, Hybrid work $125,000 - $150,000 a year

About the company

Tricoci is an innovative, high-end provider of salon and spa services and a fast-growing haircare brand that delivers in-salon results at home. Established in 1977 by legendary stylist Mario Tricoci, the Tricoci brand started with a simple vision to help people look and feel their best., Tricoci is an innovative, high-end provider of salon and spa services and a fast- growing haircare brand that delivers in-salon results at home. Established in 1977 by legendary stylist Mario Tricoci, the Tricoci brand started with a simple vision to help people look and feel their best. Now, the brand inspires entire communities by setting trends and putting confidence at the forefront of beauty. Home to some of the most creative minds in the industry, Tricoci inspires confidence within every guest by catering to the unique needs of every individual, providing an experience that is anything but ordinary. Visit www.tricoci.com for more information and follow us on Instagram @Tricoci_Official. Tricoci is an equal opportunity employer. All qualified applicants are considered for employment without regard to the person's race, color, religion, national origin, sex, sexual orientation, age, marital status, veteran status, disability, or any other characteristic protected by applicable law. Tricoci makes reasonable accommodations during all aspects of the employment process, including during the interview process. It is our commitment to create an inclusive environment for all employees.

Apply for this position