Alan Cruickshank
Director of Engineering at sqlfluff
London, England, United Kingdom
Summary
🤩
RockstarAlan Cruickshank is a Director of Engineering based in London with a decade of hands-on experience building and leading backend and data engineering efforts. He combines leadership with deep technical craft—maintainer of sqlfluff and a former Insights Director at tailsdotcom—bringing expertise in SQL linting, dbt modelling, and production data platforms. His open-source work spans impactful projects like sqlfluff and Apache Superset, where he has improved templating, formatting rules, and time-grain support, demonstrating attention to determinism and performance. Known for pragmatic refactors and clear documentation, he focuses on making complex data pipelines reliable and auditable while mentoring teams to ship consistent, well-tested solutions.
10 years of coding experience
Stackoverflow
385reputation
23kreached
4answers
9questions
Github Skills (32)
parser10
python10
back-end-development10
mysql10
data-engineering10
data-modeling10
dbt10
apache-superset10
sql10
code-formatting10
testing9
data-visualizations9
code-optimization9
jinjava9
data-visualisation9
Programming languages (9)
Github contributions (5)
sqlfluff/sqlfluff
Oct 2018 - Jan 2023
A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
Role in this project:
Back-end Developer
Back-end DeveloperContributions:27 releases, 1307 reviews, 1922 commits in 4 years 3 months
Contributions summary:Alan primarily focused on improving the codebase for the SQLFluff project, which is a modular SQL linter and auto-formatter. Their contributions involved implementing features for Jinja macro calls, improving indentation rules, and refining the handling of comments and code formatting, demonstrating a strong grasp of code structure and rule design. They worked on addressing specific issues like handling missing column aliases and implementing more efficient performance improvements.
dialectslinterpypisql-lintertemplated
brooklyn-data/dbt_artifacts
May 2021 - Aug 2022
A dbt package for modelling dbt metadata. https://brooklyn-data.github.io/dbt_artifacts
Role in this project:Data Engineer
Data EngineerContributions:2 releases, 31 reviews, 45 commits in 1 year 4 months
Contributions summary:Alan focused on modifying and improving the dbt models within the repository. Their contributions involved sorting and ensuring determinism within SQL queries, modifying jinja syntax, and adding comments for better clarity. The user also made significant changes to enforce consistency across materialised models by inner joining fact tables and refactored the staging models.
brooklyndbt-packagesdbtartifactsdbt-artifacts
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.