Senior Data Engineer: Pipelines, Analytics & Cloud BI

Jobtailor; Uxbridge; On-site; GBP 55,000 - 75,000; Full time

Job summary

Canon ITCG marketing, ecommerce and CRM teams rely on a data-focused specialist to design, build and maintain data pipelines, models and dashboards in Google BigQuery and Power BI to drive data‑driven decisions across initiatives.

You will perform exploratory analysis with Python or R, automate repetitive data tasks, and present insights that inform strategic marketing and sales actions.

Qualifications

• Strong SQL skills.
• Understanding of data warehousing and data modelling concepts.
• Knowledge of Google BigQuery.
• Experience developing in Power BI or similar BI tool.
• Proficiency in Python or R, especially for automation and integrations.

Responsibilities

• Design, build, and maintain data pipelines, models and dashboards in Google BigQuery and Power BI to support marketing, ecommerce and CRM initiatives.
• Perform exploratory analysis using Python/R and SQL to uncover trends and opportunities and present insights to stakeholders.
• Create, present and maintain dashboards and ad-hoc reports in Power BI based on stakeholder requirements.
• Identify and automate repetitive data tasks and processes using Google Cloud and Microsoft Azure platforms.

Skills

SQL

BigQuery

Power BI

Python

R

Data warehousing

Automation

Tools

Google Cloud

Azure

Job description

• 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 BigQuery 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 BigQuery)
• 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 JobTailor 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