Analytics Engineer

Dixons Carphone

Greater London, UK

4 days ago

Apply on www.collegerecruiter.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.collegerecruiter.com

Tech stack

Query Performance Data Analysis Data Dictionary Data Warehousing Database Queries Database Testing Power BI Software Tools Tableau (Software) Snowflake Git Flow Information Technology

+4 more

Data Management Looker Analytics Software Version Control Databricks

Job description

Develop and maintain dbt models that transform raw data into trusted datasets for analytics and business intelligence
Implement data quality tests and monitoring to ensure accuracy and reliability
Optimise query performance using effective data modelling and materialisation strategies
Establish and maintain documentation and data dictionaries for analytical models, KPI definitions and metrics frameworks
Support self-service analytics by building reusable, high-quality data models
Collaborate with cross-functional teams to translate business requirements into technical solutions
Collaborate with data engineers to define requirements for new data sources and pipelines
Conduct exploratory data analysis to identify trends, patterns, and anomalies in business performance
Build interactive dashboards and reports that empower self-service analytics
Design visualizations that clearly communicate complex data stories to both technical and non-technical audiences

Requirements

Strong SQL skills with experience in complex data transformations, CTEs, and window functions
Expertise with dbt and modern analytics engineering tools
Solid understanding of dimensional modelling and data warehousing concepts
Experience with Git-based workflows for version control and collaboration for analytics
Knowledge of data testing frameworks and quality assurance practices
Experience with Snowflake, Databricks, or similar data platforms
Proficiency in Omni, Looker or similar BI tools (Tableau, Power BI)
Strong analytical thinking and problem-solving abilities
Excellent communication skills with ability to present findings to diverse audiences, * 2-4 years of experience in a data analyst or analytics engineer role
Degree in Computer Science, Analytics, or a related technical field highly desirable
dbt & Analytics platform certification beneficial