Senior Data Engineer
Summary
Senior Data Engineer building and maintaining data pipelines, models, and Power BI dashboards in Google BigQuery and Azure to support Canon's marketing, ecommerce, and CRM teams.
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 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