Open to opportunities

Mathew Kirk

@mathewkirk

Message

SQL BI Developer specializing in T-SQL, ETL, and Power BI for reliable, insight-led data solutions.

United Kingdom

Message

What I'm looking for

I’m looking for a role where I can build secure, scalable SQL/Power BI solutions, optimize ETL and query performance, and partner closely with stakeholders to deliver automated, insight-led reporting.

I’m an Analytical and technically skilled SQL BI Developer with over 10 years’ experience spanning mathematics, data analysis, and stakeholder engagement. I design and deliver SQL Server solutions—building stored procedures and ETL pipelines that power data warehousing and dashboarding platforms, with a client-focused approach for complex requirements.

In my current role at Katchr, I translate law firm practice-management needs into technical implementations: writing advanced T-SQL (CTEs, window functions, dynamic SQL), optimizing database architectures to improve query performance, and validating solutions to protect data integrity. Previously at HMRC, I built automated Power BI data hubs and ETL processes, created DAX measures and data models for multi-dimensional analysis, and mentored colleagues in SQL and Power BI best practices.

Experience

Work history, roles, and key accomplishments

Current

SQL BI Developer

Current

Katchr

Oct 2025 - Present (9 months)

Design and develop SQL stored procedures and ETL pipelines to support data warehousing and dashboarding for law firm clients. Optimize T-SQL performance and translate client requirements into validated data solutions.

SQL Server T SQL Stored Procedures ETL Dashboarding Query Optimization Window Functions Data Validation Stakeholder Engagement Data Integrity

Senior Data Analyst

HMRC

May 2025 - Sep 2025 (4 months)

Designed and delivered automated Power BI data hubs for secure, scalable performance reporting to senior stakeholders. Built SQL-based ETL processes and created DAX measures and data models, mentoring colleagues on SQL and Power BI best practices.

Power BI DAX SQL ETL Data Modeling performance reporting

Performance Analyst

HMRC

Aug 2023 - May 2025 (1 year 9 months)

Created interactive Power BI dashboards tracking digital service performance across multiple directorates. Wrote complex SQL for automated reporting pipelines and optimized Power Query/DAX transformations to reduce refresh times and improve reporting efficiency.

Power BI DAX Power Query SQL Data Extraction Data Cleaning performance reporting

Mathematics Teacher

St George International School Sofia

Aug 2022 - Jul 2023 (11 months)

Delivered a Cambridge curriculum aligned to COBIS/BSO standards and provided academic support. Led pastoral duties including serving as form tutor and running a chess club.

Academic Support Pastoral Leadership Form Teacher Duties Student Support Stakeholder Engagement

Mathematics Teacher

International British School Bucharest

Aug 2021 - Aug 2022 (1 year)

Taught full secondary mathematics including Cambridge IGCSE and A-Level Mathematics. Contributed to school inspection preparation and supported the school's high-performance ethos.

Mathematics Teaching Student Support Stakeholder Engagement

Mathematics Teacher

Kingsway Park High School

Sep 2017 - Aug 2021 (3 years 11 months)

Developed and delivered KS3 and KS4 mathematics curricula focused on bridging knowledge gaps and supporting advanced understanding. Managed student data reporting and tracked academic progress to inform data-driven improvements in curriculum delivery.

KS3 KS4 Mathematics Curriculum Development Student Progress Tracking Data Reporting

Mathematics Intervention Tutor

Kingsway Park High School

Feb 2013 - Jul 2017 (4 years 5 months)

Provided targeted one-on-one and small-group support for KS3 and KS4 students during lessons, lunchtime, and after school. Collaborated with the mathematics department and senior leadership team to maintain professional standards.

One On One Tutoring Small Group Instruction KS3 KS4 Support Student Support Collaboration

Sales Assistant

Co-operative Food

Nov 2010 - Feb 2013 (2 years 3 months)

Worked as a Sales Assistant for Co-operative Food. Responsibilities are not specified in the source details.

Sales Assistant

Somerfield Plc

Oct 2005 - Jun 2008 (2 years 8 months)

Worked as a Sales Assistant for Somerfield Plc. Responsibilities are not specified in the source details.

Sales Assistant

T Corbally's Plc (Greengrocers)

May 2005 - Oct 2005 (5 months)

Worked as a Sales Assistant for T Corbally's Plc (Greengrocers). Responsibilities are not specified in the source details.

Education

Degrees, certifications, and relevant coursework

Liverpool John Moores University

Master of Science (MSc), Astrophysics

2019 - 2021

Grade: Distinction

Master of Science (MSc) in Astrophysics with a Distinction grade. Thesis on detecting alien communication using Monte Carlo simulations, statistical analysis, and advanced programming in Python, MATLAB, and Fortran.