Summary
Overview
Work History
Education
Skills
Certification
Courses
References
Timeline
Generic

Alexander Spence

Experienced Data Engineer
London

Summary

I am a Multi-talented Data Engineer with 6+ years of producing robust data solutions at a company wide level. I am highly skilled in multiple Database technologies such as Snowflake, PostgreSQL, Redshift and have experience with Oracle and MSSQL. A motivated self starter who enjoys problem solving and the challenges it brings. Alongside proven technical excellence, I am able to learn new things quickly. I am a Tech-savvy and independent professional bringing outstanding communication and organizational abilities. With my strong background in Data Engineering and software development, I am determined to bring the best of my abilities to face new challenges.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Republic Europe (Formerly Seedrs)
London
11.2022 - Current
  • Lead the Migration into Single Global Redshift based Datawarehouse after acquisition of previous company.
  • Data Ingestion Orchestrated with Airflow (Rest API, SFTP, Database Extracts)
  • Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
  • Data Modelling using DBT; Exposed to the Business via Looker
  • Developed Python scripts for extracting data and loading into databases (Rest API, SFTP, Database Extracts)
  • Integrated multiple sources of structured and unstructured datasets into a single platform.
  • Managed performance monitoring and tuning while identifying and repairing issues within database realm.
  • Designed Datawarehouse Architecture which influenced Data Ingestion Patterns in AWS.
  • Managed Data Engineering workloads while managing Stakeholders
  • Lead the Data Engineering ways of working workflow through projects involving the Larger company.

Data Engineer

Air New Zealand Limited
Auckland
03.2018 - 09.2022
  • Built Data Pipelines/ETL Processes using FiveTran/Snowflake/DBT
  • Built Data Pipelines/ETL Process using Only AWS S3, SQS + Snowflake
  • AWS DMS using CDC for Database Migration into Snowflake; Postgres + Oracle Migration
  • Task Orchestration + ETL Pipeline Scheduling with Apache Airflow
  • Built Data Models for Reporting using DBT; Star Schema / Normalised Data Models
  • Built Structured + Unstructured Data Ingestion Pipelines in Snowflake; Kafka to Snowflake, Parquet to Snowflake, Flat File Ingestion Pipelines
  • Data Ingestion using REST API's; API to Published Reporting Models (Airflow/AWS Lambda + AWS S3 + Snowpipe + DBT)
  • Data Ingestion Pipeline Automation + CI/CD Using Docker and Airflow
  • Managed Deployments of Cloudbased Infrastructure - Container Based / AutoScaling (AWS, Docker) + Monitoring and Alerting
  • System Administrator for Linux Servers - Linux Shell + Python Scripting
  • 3+ Years On Call Support For Production ETL Workloads and Production Cloud Infrastructure on Snowflake and Oracle.
  • Built/Managed Infrastructure with IaC; Terraform/Ansible/Cloudformation

E Customer Service Representative

ASB Bank Limited
Auckland
03.2013 - 12.2019
  • Communicated Effectively with Customers through Electronic Channels; Facebook/Twitter
  • Strong Customer Service Skills with a Focus on Customers best interests
  • Asked probing questions to determine service needs and accurately input information into electronic systems.
  • Assisted large volumes of customers through a variety of Channels

Education

Bachelor of Technology (Hons) - Medical Physics And Imaging Technology

University Of Auckland
Auckland
05.2017

Skills

  • Strong SQL Skills with solid experience; Impala, Oracle, MSSQL, PostgreSQL, Redshift
  • Strong Snowflake Knowledge; 3 Years
  • Task Orchestration with Apache Airflow; 3 Years
  • Dimensional Modelling with WhereScape RED;
  • Data Models with DBT; 3 Years
  • Data Ingestion with Fivetran
  • Strong Knowledge of AWS Services (5 Years Hands on experience)
  • Confluent Kafka; Consuming/Data Ingestion
  • Python/Bash Scripting; 5 Years
  • Strong Python Development Skills (OOP);
  • Intermediate-Advanced Linux Administration Skills
  • Version Control , CI/CD with Git

Certification

Business Information With WhereScape RED provided by NOW Consulting (Before Qrious)

AWS Cloud Practitioner Certificate

Courses

AWS SysOPS Associate Engineer Preparation Course

Snowflake Introduction and Immersion Week

References

Can be provided on Request

Timeline

Senior Data Engineer

Republic Europe (Formerly Seedrs)
11.2022 - Current

Data Engineer

Air New Zealand Limited
03.2018 - 09.2022

E Customer Service Representative

ASB Bank Limited
03.2013 - 12.2019

Bachelor of Technology (Hons) - Medical Physics And Imaging Technology

University Of Auckland
Alexander SpenceExperienced Data Engineer