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