Working...
Michael Page
You must first log in before applying to jobs.

BI Specialist

Job Description and Requirements

Job description / Role

Utilise wealth of strong technical skill set to help improve structure and quality of data being captured and managed by the business

Client Details

An industry leading online business in a thriving sector going through large scale technology upgrades.

Description

* Work alongside the data engineering team to create best practice data architecture / reporting layers
* Write and maintain ETL jobs to populate data into the data warehouse
* Performance tune queries to optimise data load/transform times
* Ensure data accuracy and data quality
* Create a 'single version of truth' and maintain appropriate documentation to enforce methodology
* Champion data quality, integrity and reliability throughout the department by designing and promoting best practices

Job Offer

* Attractive tax-free salary
* Diverse project portfolio
* Opportunity to join an already successful organisation at time you can make a genuine personal impact

Requirements

* Strong SQL skills, knowledge of advanced windowing functions
* In depth knowledge of data lake, data warehouse/BI development with a focus on auditability, end-to-end lineage
* Experience of working with cloud-based data warehouse systems, design and implementation (eg. Snowflake, Redshift, BigQuery )
* Knowledge of dimensional modelling, including temporal modelling (SCD)
* Performance tuning experience in relational and distributed systems
* Experience of working with visualisation tools (eg. Tableau, Looker)
* Experience of agile development methodologies
* Experience of ETL tools e.g. Pentaho, Talend, Fivetran, DBT etc and streaming approaches e.g. Change Data Capture (CDC)