At a Glance
- Tasks: Design and maintain data pipelines and visualisations to support marketing and sales initiatives.
- Company: Join Canon's innovative ITCG team and make an impact in the digital space.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on automation and efficiency.
- Why this job: Uncover insights from data and drive decisions that shape marketing strategies.
- Qualifications: Strong SQL skills and experience with data warehousing and BI tools.
The predicted salary is between 60000 - 75000 £ per year.
Overview
Design, build, and maintain collections of sophisticated data pipelines, models and visualisations that integrate marketing and sales data with other internal and external data sources in Google Big Query and Power BI to support Canon’s ITCG marketing, ecommerce and CRM team initiatives.
Perform exploratory analysis using Python/R and SQL to uncover trends, anomalies, and business opportunities in ITCG digital marketing and sales data and present back insights and recommendations to key stakeholders.
Create, present and maintain dashboards and ad-hoc reports in Power BI based on requirements gathered from key stakeholders to deliver actionable insights and support data-driven decisions.
Identify and automate repetitive data tasks, workflows, and processes to improve efficiency and reduce manual data handling utilising Google Cloud and Microsoft Azure platforms.
Develop and optimise data models that support scalable and efficient data storage, processing, and retrieval within Google Cloud and Microsoft Azure platforms.
Implement data validation and cleansing processes to ensure data accuracy and reliability before it's used in downstream systems and collaborate with IT on upstream changes required.
Requirements
- Excellent SQL skills
- Understanding of data warehousing, data modelling concepts and structuring new data tables
- Knowledge of cloud-based data warehousing (Google Big Query)
- Experience developing in a BI tool (Power BI or similar)
- Python or R proficiency, particularly in areas of automation and integrations
- ATS Optimization Keywords
Below are skills and terms extracted directly from this job posting to improve Applicant Tracking System (ATS) visibility.
This unique feature helps candidates tailor their applications more effectively — a feature exclusive to Job Tailor job listings.
- Hard Skills
- SQL
- Python
- R
- data warehousing
- data modelling
- data validation
- data cleansing
- automation
- data pipelines
- data visualisations
- Soft Skills
- communication
- collaboration
- analytical thinking
- problem-solving
- presentation skills
- #J-18808-Ljbffr
