Data Engineer

THE ROLE

OPTIMIZE, ENABLE, INNOVATE!

As our Finance Data Engineer, you are responsible for designing and maintaining high‑quality, SOX‑compliant Finance data assets within Coty’s Data Cloud. You will engineer scalable semantic models, ensure data accuracy and reconciliation, and partner closely with Finance, Reporting, and IT teams to deliver trusted, audit‑ready data for global decision‑making.

YOUR MAIN RESPONSIBILITIES

1. Data Quality Ownership & Governance

• Build and operate a robust Finance data quality framework across the data cloud
• Define and implement validation, anomaly detection, reconciliations, and monitoring controls
• Partner with Finance SMEs to define data standards, business rules, and master data
• Lead root‑cause analysis and remediation of data quality issues
• Ensure Finance data pipelines meet SOX, compliance, and audit requirements

2. Semantic Model Development (Databricks & Power BI)

• Design, build, and maintain scalable semantic models for reporting and analytics
• Create optimized curated Finance layers, Delta tables, and datasets in Databricks
• Engineer robust dimensional and star‑schema models aligned to Finance processes
• Collaborate with Finance analysts to ensure usability, documentation, and business alignment
• Implement role‑based security, lineage, and data catalog integration

3. Data Reconciliation & SOX Compliance

• Reconcile data between the Data Cloud, ERP systems, and official financial results
• Build automated reconciliation checks across transformation layers
• Document and maintain SOX 302 & 404 data controls
• Support internal and external audits with evidence, lineage, and control walkthroughs

4. Data Pipeline Engineering

• Develop, maintain, and optimize ingestion pipelines using Databricks
• Ensure pipelines are scalable, performant, and aligned with engineering best practices
• Monitor pipeline health, troubleshoot issues, and drive enhancements
• Partner with IT and platform teams to ensure high availability of Finance data assets

5. Cross‑Functional Collaboration

• Work closely with FP&A, Commercial Finance, Supply Chain Finance, and Controlling teams
• Translate reporting and analytical requirements into technical data solutions
• Partner with Data Governance, Security, and Platform teams on standards and architecture
• Enable self‑service analytics through certified, high‑quality datasets

YOU ARE A COTY FIT

As a data‑driven and detail‑oriented engineer, you thrive at the intersection of Finance, data, and technology.

Your skills and experience include:

• Bachelor’s or Master’s degree in Data Engineering, Computer Science, Finance, or related field
• Experience in data engineering, ideally within Finance or regulated environments
• Strong hands‑on experience with Databricks, SQL, Delta Lake, and Lakehouse architecture
• Proficiency in Power BI semantic models (tabular models, DAX, modeling best practices)
• Understanding of Finance processes (GL, FP&A, actuals, budgets, forecasts)
• Experience with data quality frameworks, reconciliations, and lineage documentation
• Knowledge of SOX controls, audit requirements, and compliance‑driven data management
• Strong analytical mindset and proactive, problem‑solving attitude

Nice to have:

• Experience in enterprise‑scale Data & AI platforms
• Exposure to MDM, data cataloguing, and governance tooling
• ERP knowledge (SAP, Oracle, consolidation systems)
• Python for automation and testing
• Experience supporting Finance transformation or GBS environments

WHAT WE OFFER

This role offers the opportunity to shape Finance’s data foundation from the ground up.

• Key role in building Finance’s single source of truth
• High visibility and collaboration with global Finance and IT stakeholders
• Exposure to modern data, analytics, and AI technologies
• International, transformation‑driven environment
• Hybrid working model and flexible ways of working