Transforming advertising performance and industry practices through supporting work rooted in data analysis. This role will be responsible for supporting the team in building data infrastructure and ETL pipelines to ensure that business analytics can perform analysis and generate insights from accurate data.
Main Responsibilities:
- Own the data cleaning and harmonization process
- Own the weekly pacing process, including data collection, compilation, QA, and finalization of weekly pacing reports
- Collaborate with the Annalect India team to process data into the database, build tables, conduct QA checks, and ensure data quality
- Assist in resolving data issues raised by the Investment teams, Chanel Global team, and the Annalect India team
- Develop Alteryx workflows or leverage other tools to automate and improve current data ingestion processe
Technical Skills:
- Advance level in Excel
- Familarity with Datorama
- Intermediate proficiency in Alteryx - hands-on experience building and refining workflows
- Experience building large data sets through ETL processes/pipelines
- Experience with one of the database such Redshift, with experience creating database tables, joins via SQL
- Strong in QA/Data Validation processes
Soft Skills:
- Excellent English communication skills, with the ability to convey ideas clearly and concisely
- Highly organized with strong attention to detail, demonstrating ownership and pride in delivering accurate, high-quality work
- Strong team player, able to follow established processes and collaborate effectively
- Effective problem solver with a proactive mindset
- Resourceful and adaptable in navigating challenges and identifying solutions
- Self-motivated with a strong sense of initiative
- Domenstrate interest in and passion for the luxury industry
Nice to have Skills:
- Brand Lift
- SQL
- Python
- Statistics knowledge
- Attribution Modeling / MMM
Position Profile:
Education: Bachelor´s Degree, preferably in data, engineering, data analytics, or a STEM-related field
Languages: English – Good communication
Mandatory Responsibilities:
- Owning cleansing and harmonization processes
- Owning the overall pacing process and able to support the manager with data requests
- Being collaborative with the other crafts