Data Analytics and Reporting Enablement Manager

Coty SA; New York (NY); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Remote work up to 50%

Job summary

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

Qualifications

• Hands‑on BI development and reporting automation with accountable deployed solutions.
• Advanced Python proficiency with pandas, validation and automated execution.
• Strong SQL skills with complex joins, aggregations and window functions.
• Advanced Power BI development including DAX, Power Query and data modeling.
• Experience building ETL workflows and integrating large datasets from files, DBs, APIs.
• Excel and Power Query skills to automate spreadsheet workflows.
• Git or equivalent version control, with documentation and testing.

Responsibilities

• Develop and own BI reporting for US Prestige across datasets and frameworks.
• Write Python scripts to ingest, clean, validate and export data; automate reports.
• Build Power BI models, dashboards and ensure governance and performance.
• Create reliable data integrations from external and internal sources.
• Maintain documentation, version control, and user handover materials.
• Train users and troubleshoot reporting issues; deliver on recurring deadlines.

Skills

Python

SQL

Power BI

Data modeling

ETL

Excel

Git

Tools

Power BI

SQL

Python

ETL tools

Job description

MANAGER, PRESTIGE DIVISION

DATA ANALYTICS & REPORTING ENABLEMENT

BUSINESS INTELLIGENCE AND COMMERCE EXCELLENCE (BICE) – NEW YORK

COTY is looking for smart leaders who are tenacious, passionate, and fearlessly kind.

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.

QUALIFICATIONS

We’d love to see candidates who have:

Essential:

• 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

WHAT WE OFFER

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.

ABOUT US

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.

EQUAL EMPLOYMENT OPPORTUNITIES

We offer equal employment opportunity to qualified individuals without regard to race, religion, color, national origin, age, gender,disability, sexual orientation, gender identity, gender expression, marital status, veteran status, or any other characteristic protected by law. Coty complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [e-mail]. We strongly believe that cultivating a diverse workplace gives a company strength. The combination of unique skills, abilities, experiences and backgrounds creates an environment that produces extraordinary results. EOE Minorities/Females/Protected Veterans/Disabled.

English - Please click here to review the Notification of Equal Opportunity Rights poster

Español - Por favor, haga un en el enlace para revisar el poster de la Ley de los Derechos de Igualdad de Empeo

Base Salary Range: $ (100-130k)