Specialist, CRM Data Engineer

Specialist, CRM Data Engineer 

At Chanel, we are focused on creating an inclusive culture that nurtures personal growth, contributing to collective progress. We believe the uniqueness of each individual increases the diversity, complementarity and effectiveness of our teams. We strongly encourage your application, as we value the perspective, experience and potential you could bring to CHANEL. 

About the role:  

CHANEL is looking for a Specialist CRM Data Engineer to join our BI+CRM Team in New York City. This Data Engineer will design, build, and maintain robust data pipelines that power our Customer Relationship Management (CRM) ecosystem. Our ideal candidate will have retail and omni channel ecommerce experience and work closely with CRM, marketing, and analytics teams to ensure high-quality, timely data is available for campaign execution, personalization and reporting. This role bridges the gap between source systems (e.g. POS, ecommerce) and target systems (Salesforce, Marketing Cloud, BI Tools).  This Data Engineer role requires a minimum of 2+ years of technical data engineering using SQL, Python, BigQuery, GCP, Azure, Power BI, etc.  This role requires a passion for leveraging technical mastery and a mindset that’s both curious and creative to identify opportunities and address unique technical and business challenges in a collaborative, analytical, and fast-paced environment of the Luxury Retail industry. 

What impact you can create at CHANEL: 

• Technical Resource – Design, build and maintain scalable efficient data pipelines and ETL processes using GCP tools (BigQuery). Document technical solutions, data flows and schemas for cross-functional transparency and knowledge sharing 

• Expertise support- support the CDP with onboarding data quality, identity resolution and segmentation enablement. Troubleshoot data issues end-to-end, from source systems to target like data warehouses, BI tools, touchpoints, identifying and resolving data inconsistencies and failures 

• Data Governance – act in role of data custodian for the Client Data Domain, ensuring data accuracy, completeness and consistency 

• Study, understand, develop, and maintain the Data as a Service data pipelines and solutions – Collaborate with CRM architect and review documentation materials covering the existing data pipeline solutions and analytical data assets managed within the Data as a Service domain. Continue to understand, develop, expand, and maintain data assets and processes 

• Partner with Business Analysts, Dashboard Developers, Service Owners, and Providers – Work closely with internal business analysts, service owners, data providers, as well as onshore and offshore consultants to deliver accurate, scalable, and maintainable data solutions 

• Communication and Documentation – Communicate and interface effectively with the Data as a Service IT Manager, business analytics teams, and front-end dashboard developers, productively working with them throughout the project life cycles. Adhere to documentation requirements and change control best practices throughout development and production deployment phases 

• Teach – Serve as a model example of presenting concepts and use cases for Data Engineering in CHANEL’s internal Data & Analytics space, Masterclasses, Department meetings, etc. Support by helping to equip the organization with the best practices, skills and techniques needed for unlocking the full value of CHANEL’s data assets as well as assisting with self-service BI 

• Strategize - Contribute towards providing inputs to assist CRM architect and EA with the strategic direction and evolution of the services and practices described above 

• Innovation – Be able to proactively think about ways to enhance existing solutions and/or prototyping new ones 

You are energized by: 

• Building relationships and communities of analytical users at CHANEL 

• Identifying opportunities and tackling complex problems prevalent in Luxury Retail 

• Working in a highly collaborative, analytical, and fast-paced environment 

• Coding to solve for unique technical challenges 

• A space to explore curiosity and foster creativity 

What you will bring to the team: 

• Experience in data acquisition (e.g., SQL, Python, Web API, SFTP, File Directories), data manipulations (e.g., JSON, XML, CSV) and structuring data using BigQuery, SQL Procedures, Scheduled Queries, Storage Buckets, Pub/Sub topics, Cloud Functions, and Cloud Scheduling 

• Familiarity with Google Analytics, Firebase, and corresponding GA BigQuery data export schemas (i.e., Nested data structures in BigQuery), and implement advanced SQL coding including aggregations/partitions/window functions 

• Experience working in Salesforce Data Cloud (CDP) 

• Thorough understanding of data design and dimensional data modeling concepts 

• Aptitude to build and maintain local Python virtual environments, supporting local development and testing with Python IDEs (e.g., Spyder, PyCharm, etc.), and experience with using the Google Cloud SDK and Google Cloud ‘gsutil’ command in local environment is a plus 

• Exposure to Microsoft BI SQL Server Agent Job/Step scheduling architecture and Microsoft SSIS (dtsx) package development with Visual Studio is desired 

• Functional and technical experience in Advanced Analytics (e.g., BigQuery ML, Vertex AI) and Data Governance (e.g., Data Catalog, DLP) is a plus 

• Ability to contribute to projects for end-to-end delivery with minimal guidance but also influence the business on best practices and solutions 

• Solid written and oral communication skills, with the ability to communicate effectively with all stakeholders 

Position Logistics: 

• Role requires a minimum of 3 days in-person office presence in the New York City office with some occasional presence in our Piscataway, New Jersey office     

• Minimum of 2+ years of multidisciplinary professional experience with an emphasis on building and maintaining data pipelines in Google Cloud Platform (GCP) 

• Required experience in retail, omnichannel ecommerce environment with a preference for Luxury Goods  

• Salesforce Marketing Data Cloud, Marketing Cloud experience highly recommended 

• Required experience with SQL, Python, BigQuery, GCP, Power BI, Azure with CRM and CDP focus 

• Bachelor’s degree (or technical knowledge) in Information Management, Statistics, Mathematics, Engineering, Computer Science, Economics, or Analytics/Data Science is preferred 

*Chanel, Inc. reserves the right to edit, change, or make exceptions to designations where circumstances where deemed appropriate. 

Compensation:  

• The anticipated base salary range for this position is $87,500-$130,000.  Base salary is one component of the total compensation for this position. Other forms of variable pay [may/will] be offered for this position. Other components [may/will] include bonus potential, benefits, and/or perks.  

​

Benefits and Perks:  

• Wellbeing resources include dedicated paid time off for wellbeing (2-week August Office Closure) and a Wellbeing fund   

• Family and care giving benefits (inclusive of parental leave, fertility support, MilkStork, and Care.com Membership)  

• Generous paid time off policies to include vacation, holiday, sick and volunteer days   

• 401K and other incentives   

• Robust healthcare offerings; medical, dental, vision, MDLIVE (virtual care), One Medical, Flexible Spending Accounts (Health Care & Dependent Care), Health Savings Account and Employee Assistance Program  

• Life insurance, Accidental Death & Dismemberment, Short Term Disability, Long Term Disability, Health Advocate, International Business Travel Accident & Medical, and Commuter Transit & Parking  

​

Additional Information:  

Chanel is a private company whose values are grounded in creating the conditions for people to perform at their best and feel fulfilled and confident in their work. We offer a unique work environment where individuals are encouraged to better understand the brand, the business, and motivations, so that together we can unlock the possibilities of growth. This is reflected in:  

Diversity and Inclusion:  

• At CHANEL, we are intentional in promoting Diversity & Inclusion. We foster respect, empathy, and dignity for all.  We believe strongly that the diversity of our people across the full spectrum of human differences is essential to our organisation and the connections we have with each other and our clients.   

• We offer Employee Resource Groups in the US that are voluntary, open to all, employee-led groups formed around a shared identity or lived experience, whose aim is to foster a diverse, inclusive, and equitable community aligned with the values and missions of the communities they support.  

​

 Chanel Community:  

• CHANEL Community empowers our employees to channel their passions, talents and sense of purpose to contribute to and learn from our communities.  

• Employees are encouraged to take time off annually to volunteer through the CHANEL Community. CHANEL also matches employee donations to select charitable organizations.  

​

Sustainability:  

• CHANEL Mission 1.5° is our climate action plan. It is focused on transforming the business in line with the ambitions of the Paris Agreement on climate change to limit the average global mean temperature increase to 1.5 degrees Celsius above preindustrial levels.  

• Employees are encouraged to contribute to our US Sustainability efforts at the corporate level and within the divisions, through organized taskforces and initiatives.  

​

Arts and Culture:  

• We are committed to extending our legacy of cultural engagement. Global support includes the CHANEL Culture Fund, which supports a select group of leading art culture institutions across the globe, and the CHANEL Next Prize for the next generation of creative talent.  US support currently includes Annual sponsorship of the MoMA film program, Tribeca Film Festival programs and Through Her Lens, Support of the Academy Gold Fellowship for Women and Sponsorship of the BAAND Together Dance Festival at Lincoln Center.  

​​

Fondation Chanel:  

• Since 2011, Fondation CHANEL’s mission is for women and girls to be free to shape their own destiny.  Through multi-year partnerships with financial and technical support, Fondation CHANEL is committed to improving the safety and autonomy of women and adolescent girls around the world, impacting over a million women and girls in its first 10 years.      

• For more information, please navigate to the Fondation Chanel website here    

​​

 Career and Leadership Development:   

• We have dedicated in-house teams focused on supporting the onboarding of employees, developing leadership skills via custom programs like Imagine Chanel People, Heart of Leadership and group and individual coaching, and blended online and live classes offered on our Bloom platform and by skilled trainers, such as Shape Your Career, to develop career building skills.  

​

 *Chanel, Inc. benefits and perks are dependent on eligibility and subject to modification by Chanel at any time.