Alex Dimmock Profile Image

Alex Dimmock

Data/AI Engineer | Building Next-Gen Data Platforms and AI powered solutions

Data/AI Engineer: Building Next-Gen Data Platforms and AI powered solutions

I thrive on solving complex data challenges and building scalable solutions with a strong foundation in the Microsoft stack and Databricks related technologies.

Experienced in building RAG based applications and agentic workflows with various AI toolsets, with comprehensive understanding of SQL and Python.

In-depth understanding of data modelling techniques with a background in Kimball, having implemented both data vault and dimensional modelling at scale.

Comfortable with streaming technologies and have a track record of implementation across various technologies.

One of my biggest strengths is helping to build and nurture teams in the data engineering space, with a great track record of seeing talented individuals go on to have successful careers.

Work Experience

Senior Data Engineer at The Access Group

November 2022 - Present

At the forefront of architecting and developing a greenfield Data platform to cater to the entire business on a global level. Leveraging a tech stack that includes Databricks, Azure, Apache Spark, Python, and SQL to build next-generation AI-powered data solutions.

  • Spearheading the design and architecture of the Data platform on Databricks, ensuring scalability, reliability, and performance
  • Involved in every step of planning from data governance, data architecture down to build and initialization of custom Python framework for data engineering on the platform
  • Leveraging Spark to full capabilities, utilizing DLT pipelines in Databricks and exploring all platform functionality
  • Designed main ingestion pipelines that take federated catalogs and load them into platform with minimal latency
  • Built custom Python application that enables other data engineers across the business to work more efficiently
  • Collaborating cross-functionally with group level data teams and product managers to understand business requirements and translate them into scalable data solutions
  • Fostering a culture of innovation and data-driven decision-making across the organization

Head of Data at adam (HTT)

September 2020 - November 2022

Led the transformation of the company's data capabilities during a period of rapid growth. Formed and managed a dedicated team of Data Engineers and Data Analysts to revolutionize how data was harnessed and presented, both internally and externally.

  • Promoted to Head of Data to align data capabilities with modern data stack during company's rapid growth
  • Built and led dedicated team of Data Engineers and Data Analysts
  • Led complete reconstruction of internal data warehouse grounded in Kimball methodology
  • Planned and implemented each phase including comprehensive data modelling
  • Designed architecture leveraging Azure technologies - Power BI front end, Azure SQL data warehouse, and Azure Data Factory for ELT
  • Re-evaluated and remodelled all existing data sources from internal systems and main application
  • Completed four pivotal phases of delivery, propelling data capabilities to forefront of organizational operations
  • Enabled more efficient work processes, leveraged data-driven insights, and improved decision-making across the company

Senior Database Developer at adam (HTT)

February 2018 - September 2020

Promoted to senior role with the opportunity to assemble and nurture a high-performing team. Focused on delivering procurement services to local government entities while mentoring team members and addressing comprehensive business intelligence and reporting needs.

  • Promoted to senior role following company division
  • Assembled and nurtured high-performing team, mentoring individuals from internal support roles into accomplished data professionals
  • Worked closely with key stakeholders across the organization
  • Addressed comprehensive business intelligence and reporting needs
  • Supported finance department with monthly reporting
  • Maintained legacy data warehouse
  • Successfully managed second infrastructure migration from one private cloud to another
  • Earned Microsoft MCSE for Data Management and Analytics during tenure

Database Developer at Dynamic Procurement Holdings Ltd

May 2016 - February 2018

Served as the inaugural and sole data resource at DPH, assuming full responsibility for the company's data estate including legacy data warehouse and on-site infrastructure. Led critical infrastructure migration to private cloud environment.

  • First and sole data resource at DPH with full responsibility for company's data estate
  • Managed legacy data warehouse and on-site infrastructure
  • Led critical infrastructure migration project transitioning on-site infrastructure to private cloud
  • Performed various database administration activities
  • Implemented availability groups and upgraded to SQL 2014
  • Delivered significant enhancements to existing systems

Junior BI Consultant at Dynamic-BI

May 2012 - May 2016

Started as an apprentice and progressed to business intelligence consultant. Gained comprehensive experience in the Microsoft data stack, managed on-site infrastructure, and delivered end-to-end data warehousing solutions to clients nationally and internationally.

  • Earned CompTIA certifications as an apprentice
  • Managed all on-site infrastructure including phone systems, network devices, and servers
  • Performed database administration for Microsoft SQL and Oracle servers vital for development and QA
  • Shadowed senior business intelligence consultants to gain proficiency in Microsoft data stack (SSIS, SSRS, SSAS, T-SQL)
  • Actively participated in stakeholder meetings, developing soft skills alongside technical expertise
  • Progressed to business intelligence consultancy role
  • Collaborated with senior colleagues to strategize, build, and deliver end-to-end data warehousing solutions
  • Worked with clients nationally and internationally
  • Traveled to USA to deliver comprehensive financial BI solution to one of the world's largest grain suppliers

Projects

Next-Generation AI-Powered Data Platform

Leading the development of a cutting-edge data platform at The Access Group using Databricks, Azure, Apache Spark, Python, and SQL to support global business strategy and AI-powered solutions.

  • Spearheading the design and architecture of a greenfield Data platform on Databricks, ensuring scalability, reliability, and performance
  • Involved in every step of planning from data governance and data architecture to build and initialization of custom Python framework for data engineering
  • Leveraging Spark to full capabilities, utilizing DLT pipelines in Databricks and exploring all platform functionality
  • Designed main ingestion pipelines that take federated catalogs and load them into platform with minimal latency
  • Built Python application that enables other data engineers across the business

Enterprise Data Warehouse Reconstruction

As Head of Data at adam (HTT), transformed the company's data infrastructure by building a modern data warehouse from the ground up, enabling data-driven insights and improved decision-making processes across the organization.

  • Led complete reconstruction of internal data warehouse grounded in Kimball methodology
  • Built dedicated team of Data Engineers and Data Analysts
  • Re-evaluated and remodelled all existing data sources from internal systems and main application
  • Designed architecture leveraging Azure technologies with Power BI front end, Azure SQL data warehouse, and Azure Data Factory for ELT
  • Completed four pivotal phases of delivery, propelling data capabilities to forefront of organizational operations

Infrastructure Migration to Private Cloud

Orchestrated major infrastructure migrations at Dynamic Procurement Holdings, modernizing the data estate and implementing enterprise-grade database technologies.

  • Led critical infrastructure migration project transitioning on-site infrastructure to private cloud environment
  • Implemented availability groups and upgraded to SQL 2014
  • Successfully managed second infrastructure migration between private clouds
  • Ensured seamless transition with accumulated expertise

International Financial BI Solution

As a BI Consultant at Dynamic-BI, worked on high-impact international projects, delivering comprehensive business intelligence solutions to global organizations.

  • Collaborated with senior consultants to strategize, build, and deliver end-to-end data warehousing solutions
  • Traveled to USA to deliver comprehensive financial BI solution
  • Worked with one of the world's largest grain suppliers
  • Successfully delivered solution for international client