Aaron Richards

I’m a Google Cloud Certified Data Engineer with 7+ years’ experience across data engineering, analytics and reporting roles. I design and deliver data solutions that turn business requirements into reliable, business-driven outcomes.

In my current role, I contribute to building a new SQL Server Data Warehouse for Azure migration using Medallion Architecture layers and Kimball dimensional modelling. I develop SQL Server solutions including stored procedures, views and dynamic SQL to support ETL, reporting and metadata analysis.

I’ve built and maintained a reusable metadata framework spanning 250+ databases across 10 SQL Server instances, enabling lineage and dependency analysis that supported the decommissioning of two servers and retirement of 200+ redundant SSRS reports. I also develop SSIS packages and SQL Server Agent jobs, including automated ETL processes and secure SFTP integrations.

Previously, at Sky, I developed BigQuery datasets, tables, views and transformation procedures, and optimized workloads through partitioning, clustering and query refactoring—reducing a key report runtime from 40 minutes to 3 minutes. I also deliver Power BI and Tableau/SSRS reporting and manage delivery in an Agile environment using Azure DevOps, Git, and Scrum.