Data Analytics - Compunnel : Job Details

Job Description:

• Client would like to see someone who understands e-comm data and e-comm KPIs and CRM
• Need to be able use data manipulation and python and Google Worker for visualization and building of dashboards. General reporting with Excel. Manage time very well as this candidate will report into two managers. Interpret and analyze data to make recommendations.
• This role will be responsible for leveraging global data sources to build and maintain e-commerce and CRM dashboards and reporting to support data-driven Brand strategies.

Key Responsibilities:

E-COMMERCE:

• Own, build and maintain monthly & quarterly global digital channels sales reporting and global eCommerce and KPI dashboards
• Leverage analytics to drive customer-centric action plans and maximize opportunities by cross-referencing and merging insights from diverse data sources, supporting multi-channel strategies
• Consolidate multiple Google Analytics property data for recurring monthly reporting, utilizing internal tools to analyze the state of business and provide key findings
• Collaborate closely with stakeholders, serving as a subject matter expert to lead KPI analyses of site performance, site feature performance, and digital marketing channels globally. Provide feedback on ways to enhance performance
• Possess a key understanding of on-site user journeys and conversion funnels to advise on delivering a consistent user experience and to improve conversion. Identify gaps or opportunities for improvement to support digital, content and site experience teams

CRM:

• Create and maintain CRM & loyalty reporting dashboards by aggregating and consolidating data from various platforms and data sources (Tableau, Power Bi, csv files, etc.)
• Own CRM & loyalty quarterly reporting and identify gaps to improve holistic view of our customers
• Lead data collection from various global market partners and KPI analyses on global CRM and loyalty activations (customer behavior, email channel performance, loyalty program performance, NPS, product purchase trends, etc.)
• Support data-aggregation, standardization, and analysis for loyalty program structural and financial modeling

TRANSVERAL:

• Deliver monthly digital dashboards and presentations (eCommerce + CRM) to provide business highlights and insights to the leadership team
• Collaborate with the internal global team to support ad-hoc data or analysis requests and develop business cases
• Consolidate and streamline the data needs of business stakeholders and Digital IT
• Compile data and research of online consumer behavior, monitor industry trends, and share insights with cross-functional teams to inform strategic decisions to inform strategic business decisions

Requirements:

• Background in E-Commerce and/or CRM data and web analytics
• Experience with on-site user journey, CRM KPIs (like retention, CLV), email, and SMS marketing
• Experience with Google Analytics 4
• Experience developing dashboards using Looker Studios (BigQuery experience preferred)
• Experience with SQL & Python (Databricks experience preferred)
• Advanced skills in excel is mandatory