Jason Thompson
Manchester
Summary
Senior data engineer with 5+ years of experience in designing and implementing cloud-based data platforms. Expertise in data warehousing, ELT pipelines, and scalable analytics solutions on AWS. Proficient in building and optimising data pipelines using Amazon Redshift, S3, and Python, along with migrating legacy SQL Server warehouses to modern cloud architectures. Strong skills in data modelling, performance tuning, and delivering reliable data products for reporting and analytics.
Overview
13
13
years of professional experience
8
8
years of post-secondary education
Work history
Senior Data Engineer
Zuto Finance
Manchester
2018.07 - Current
- Key contributor to the design and ongoing development of the company data platform
- Managing the migration of the legacy SQL Server warehouse to AWS, implementing a Redshift-based analytics architecture
- Build scalable ELT workflows to transform raw data from the data lake into curated datasets for analytics and reporting
- Develop stored procedures and transformation logic in Amazon Redshift to support incremental loading and high-frequency refresh of the data warehouse
- Led the implementation of a cloud-based ingestion pipeline to batch process communication event data, including transcripts, using AWS services for PII redaction, LLM summarisation, embedding generation and search indexing for an internal AI application
- Develop Python-based AWS Lambda ingestion pipelines for API and external data sources, landing raw data in S3 for downstream processing
- Contribute to the migration of scheduled workflows from third-party tools to AWS orchestration services
- Use Git, CI/CD pipelines and Terraform to manage deployments and infrastructure changes
- Perform performance tuning and troubleshooting across warehouse and pipeline processes to ensure reliable delivery of business-critical reporting
Senior Report Developer
Newcastle College Group
Manchester
2016.09 - 2018.07
- Supported production of reporting and MI across multiple databases
- Maintained and enhanced data warehouse structures and ETL processes
- Developed database objects including tables, views and stored procedures
- Delivered reporting using SQL Server, SSRS, VBA and Excel
- Worked with end users to troubleshoot issues and develop new reports
- Contributed to data migration and data quality improvement projects
Database Developer
TalkTalk
Irlam
2015.05 - 2016.09
- Developed database solutions to meet business requirements
- Followed source control and deployment processes within delivery team
- Created stored procedures, tables and functions following coding standards
- Supported testing, release and production deployments
- Provided third-line support for database issues
BI Developer
Betfred
Birchwood, Warrington
2013.08 - 2015.05
- Developed ETL processes using SSIS and T-SQL
- Maintained data warehouse loads and reporting structures
- Produced KPI reports using SSRS and SSAS
- Integrated data from internal and third-party systems
- Worked with business users to translate requirements into technical solutions
Education
GCSEs -
South Trafford College
Altrincham, Trafford 1986.09 - 1988.08
GCSEs -
Sale Boys Grammar School
Sale, Trafford 1980.09 - 1986.08
Skills
- AWS services (Redshift, S3, Lambda, Glue, Athena, EC2, EventBridge, Kinesis, Comprehend, OpenSearch, IAM, CloudWatch)
- Strong SQL proficiency
- Python (data processing, pipeline logic, AWS Lambda)
- Data warehousing & dimensional modelling (Kimball)
- ELT / ETL pipeline design & data integration
- Data lake and S3 ingestion pipelines
- CI/CD, Git and Infrastructure as Code (Terraform)
- Data pipeline orchestration (AWS services, scheduled workflows)
- Performance tuning & query optimisation
- API and external data ingestion pipelines
Affiliations
- Playing tennis (badly)
Timeline
Senior Data Engineer
Zuto Finance
2018.07 - Current
Senior Report Developer
Newcastle College Group
2016.09 - 2018.07
Database Developer
TalkTalk
2015.05 - 2016.09
BI Developer
Betfred
2013.08 - 2015.05
GCSEs -
South Trafford College
1986.09 - 1988.08
GCSEs -
Sale Boys Grammar School
1980.09 - 1986.08