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
Auckland05.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
Similar Profiles
Karel KeřkaKarel Keřka
Senior Sales Specialist at TOYOTA TSUSHO EUROPE SA Czech Republic BranchSenior Sales Specialist at TOYOTA TSUSHO EUROPE SA Czech Republic Branch
Anna KomorováAnna Komorová
Senior Lawyer at MetLife Europe, d.a.c., Branch for the Czech RepublicSenior Lawyer at MetLife Europe, d.a.c., Branch for the Czech Republic
Luca ColomboLuca Colombo
Chief Financial Officer at Europe Assistance Eastern Europe RegionChief Financial Officer at Europe Assistance Eastern Europe Region
Selin YozkanSelin Yozkan
Store Colleague at Holland & BarrettStore Colleague at Holland & Barrett
Regina BrewRegina Brew
Registered Nurse at Ontario Health at HomeRegistered Nurse at Ontario Health at Home