Curriculum Vitae

Nik (they/them)

Taunton, England

about

Data architect with a wealth of skills on traditional data warehouses, who since the pandemic has focused more on modern practices utilising python and relevant tools. Has experience in the design and implementation of greenfield warehouses on top of developing and improving existing solutions. They have also spent time in developing proof of concepts of modern data warehouse structures with some of these concepts being incorporated in more traditional settings. Have also had experience in implementing CI/CD pipelines in Jenkins and Azure DevOps.

technical skills

In-depth knowledge & experience conceptualising and developing Data Warehouses
Developing ETL/ELT Pipelines utilising tools such as Docker, Prefect, & dbt, as well as pure python
Setting up and implementing CI & CD
Knowledge & proof of concept work of modern data warehouse design such as Kappa & Lambda architectures, and Data Lake formats with Delta & Apache Iceberg files.

employment

oxford health nhs foundation trust

Senior BI Solutions Architect

05/2021 - Present

Overall design and implementation of Data Warehouse
Design and proof of concept of Operational Data Store implementing modern data tools (Prefect, dbt, airflow)
Emergency development of COVID related database and reporting
Continuation of tasks of Senior BI Developer

oxford health nhs foundation trust

Senior BI Developer

09/2017 - 04/2021

Development of Data Warehouse built in SQL Server 2017
Building metadata driven ETL approach using T-SQL, SSIS, & BIMLScript
Designing and creating Tabular Analysis Models in SSAS
Designing visualisations, reports & dashboards using Power BI
Developing and automating data extraction projects to several file formats using many protocols (FTP, FHIR, HL7v2) utilising T-SQL, SSIS, PowerShell, Bash, Python, & C#
Heading project to provide continuous integration and deployment using Azure DevOps
Leading daily stand ups, sprint planning, & retrospectives

jisc

BI & Data Warehouse Developer

10/2014 - 08/2017

Developed Enterprise Data Warehouse using AWS and RedShift
Developed ETL using metadata driven approach in Pentaho
Created unit and integration tests using pytest library
Created reports and dashboards in Tableau and Excel (including VBA)
Developed Postgres database to store JANET network data and migrated away from preexisting Access database

ageuk enterprises

Data Processing Analyst

07/2012 - 10/2014

Maintained SQL Server transactional database & bespoke CRM system
Developed ETL to incorporate data from 3rd party partners whilst ensuring data cleanliness
Produced financial journals and KPI reports in Excel
Provided supporting data to ad-hoc queries from other departments and 3rd parties

personal skills

Leading team in Agile related meetings.
Mentoring junior members in Data Warehousing designing and implementation.
Not afraid to try new methods, tools, or advice to achieve a goal in a cleaner, more concise, or Agile way.
Presentation skills with providing 'Show and Tells' to consumers as well as personal projects and improvements with team members.
Constantly wanting to learn, with a number of online courses going on

outside of work

Building and maintaining personal website & blog
Raising 2 daughters
Game Master of a number of Tabletop RPG games
Running
Active advocate for mental health & LGBTQIA+ rights