Data Analytics and Reporting Enablement Manager

Coty is seeking a highly technical, hands-on Manager to build and maintain the data, reporting, and automation capabilities supporting the US Prestige Beauty business across fragrance, makeup, and skincare. This role will integrate market, retailer, e-commerce, consumer, and internal commercial datasets into reliable reporting tools and automated workflows that support CMI and business decision-making.

The Data Analytics and Reporting Enablement Manager will serve as a technical and operational partner to US Prestige BICE leadership, with direct responsibility for developing, maintaining, and improving reporting capabilities. Working closely with CMI, brand, commercial, and local and global technical teams, this person will translate reporting requirements into scalable solutions that improve data accuracy, accessibility, and delivery speed.

This role requires ability to personally write Python scripts and SQL queries, develop Power BI data models and dashboards and own recurring reporting from data ingestion through validation and delivery. The primary accountability is technical development and reporting enablement. CMI partners will lead consumer interpretation, strategic storytelling and business recommendations using the capabilities this role delivers.

THE ROLE

In this role you will be responsible for:

Reporting automation and scripting :

• Write, maintain and troubleshoot Python scripts to ingest, clean, combine, validate and export data; automate recurring report creation and distribution.
• Build repeatable workflows for weekly and monthly reporting, including scheduled execution, error handling, logging and alerts for failed runs or missing data.
• Replace manual file manipulation and repetitive Excel processes with documented, reusable code that reduces turnaround time and manual effort.

Power BI development and ownership:

• Build and maintain Power BI semantic models, relationships, DAX measures, Power Query transformations and dashboards for category, brand, retailer, channel and product performance.
• Own refresh schedules, gateway coordination, report publishing, access controls and performance optimization in partnership with IT and approved governance standards.
• Develop reusable measures and reporting templates that enable consistent, self-service access to approved data

Data integration and reporting reliability:

• Use SQL and ETL processes to combine external market and retailer data with internal commercial datasets through approved files, connectors or APIs.
• Maintain product and brand mappings, retailer hierarchies, reporting calendars, metric definitions and source documentation, preserve differences in source coverage and methodology.
• Build reconciliation and quality checks for completeness, duplicates, missing records, mapping changes and calculation accuracy; resolve discrepancies before delivery.

Technical Delivery and user enablement:

• Translate CMI and commercial reporting needs into technical specifications, prioritize development with the Senior Manager, CMI & Data Analytics; and deliver working solutions from build through deployment.
• Partner with local and global IT, Data, Digital, and Analytics teams on approved architecture, integrations, security and reporting migrations.
• Maintain code version control, documentation, operating instructions, and handover materials; train users and troubleshoot reporting issues.

• Demonstrated hands-on experience in business intelligence development, reporting automation, data engineering or a similar technical analytics role, with personal ownership of deployed solutions.
• Advanced Python proficiency, including pandas, reusable script development, file processing, validation, debugging and automated execution.
• Strong SQL skills, including complex joins, aggregations, window functions and query optimization across multiple datasets.
• Advanced Power BI development skills across DAX, Power Query M, dimensional data modeling, Power BI Service, refresh configuration and report performance tuning.
• Experience building ETL workflows and integrating large datasets from files, databases and approved connectors or APIs.
• Strong Excel and Power Query Skills, with the ability to convert existing spreadsheet workflows into automated reporting solutions.
• Practical experience with Git or equivalent version control, code documentation, testing, reconciliation and operational troubleshooting.
• Ability to clarify requirements with business users, explain technical issues clearly and independently deliver accurate reporting to recurring deadlines.
• Candidates must be able to demonstrate solutions they personally coded, built, deployed and maintained.

Desirable:

• Experience with retail POS, syndicated market measurement, ecommerce, or commercial data; familiarity with platforms such as Circana, NiQ, Yipitdata, Numerator, etc
• Experience with Microsoft Fabric or Azure data services, Power Automate, or comparable workflow orchestration tools.
• Experience migrating reports between platforms and improving data access and reporting adoption.
• Exposure to beauty, luxury or consumer goods; ability to learn category and retailer structures quickly

This is unique role with a genuine opportunity to make an impact. You’ll get to work in a diverse environment with a team of professionals who are passionate about the work they do and know how to have some fun along the way.

Coty’s global omni-working policy provides the option to work up to 50% of your month remotely. We believe that a more flexible philosophy of remote working will give everyone the freedom to choose what works for their individual circumstances and empower them to always perform at their best.

Our people make us who we are. They are the brightest minds bringing the boldest ideas to life every day. If you’re the kind of person who refuses to settle, if you want to think bigger, learn faster and go further than you ever thought possible - we’d love to hear from you.

Coty is deeply committed to Changing the Conversation around Diversity, Equity & Inclusion in an effort to create a more open, inclusive, and diverse workplace where all employees can be their authentic self., Español -Por favor,haga (https://www.dol.gov/sites/dolgov/files/OFCCP/regs/compliance/posters/pdf/22-088_EEOC_KnowYourRights-Spanish.pdf) un en el enlace para revisar el poster de la Ley de los Derechos de Igualdad de Empeo