Analyst - Data & Analytics

Role overview

Data integration and development

• Design, build, and maintain data pipelines, models, and visualisations integrating marketing and sales data with internal and external sources in Google BigQuery and Power BI.
• Support ITCG marketing, ecommerce, and CRM team initiatives through data integration and development.

Analysis and reporting

• Use Python or R and SQL for exploratory analysis of digital marketing and sales data to find trends, anomalies, and business opportunities.
• Present insights and recommendations to stakeholders.
• Deliver website-channel and performance reporting for senior leadership and cross-functional stakeholders, translating data outputs into commercial insight.

Architecture, quality, and customer journeys

• Develop and optimise data models for scalable storage, processing, and retrieval in Google Cloud and Microsoft Azure.
• Implement data validation and cleansing, and collaborate with IT on upstream changes needed to ensure reliable downstream data.
• Analyse customer behaviour on ecommerce and marketing B2C websites and work with ecommerce and content teams to recommend journey improvements.

Required qualifications

• At least 1 year of experience as a data engineer, data architect, or in a similar role, or 3 or more years as a data analyst or in a similar role.
• Excellent SQL skills.
• Understanding of data warehousing, data modelling concepts, and structuring new data tables.
• Understanding of how to clean raw data and check its quality.
• Bachelor’s degree.

Preferred qualifications

• Experience with a data visualisation tool, ideally a BI tool such as Tableau or Looker, is preferred.
• Python or R proficiency, particularly for automation and integrations, is preferred.

Working arrangements

• Hybrid working is available, with 3 days in the office and 2 days from home.

Benefits

• Benefits include flexible hours, professional development, at least 25 days of personal holiday with up to 5 additional days available for purchase, a pension scheme, and a discount on Canon products.
• The posting mentions sustainability, inclusion, and employee development.