Nik Dot Codes and tries other things

Curriculum Vitæ

Contact Me

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