About
I’m Alan, a data platform engineer focused on Snowflake, Databricks, and warehouse SQL. This site is the public version of how I work: clear implementation notes, reusable platform patterns, and practical articles that help teams deliver reliable data products faster.
Progression
Data Associate
Data Analyst
Consultant
Data Platform Engineer
Senior Data Platform Engineer
Data Architect
Tech Lead
???
What I work on
- Snowflake warehouse design, cost control, and secure data delivery
- Databricks notebooks, jobs, Python workflows, and lakehouse operating patterns
- SQL and Python for production-grade warehouse work
- Warehouse modeling and analytics engineering
- Reporting systems that support operational and business decisions
- Snowflake
- Databricks
- Python
- SQL
- Docker
- SQL Server
- Power BI
- Apache Superset
- Tableau
- dbt
What this site is for
The site is designed as a focused working reference rather than a traditional reverse-chronological blog. Its purpose is to collect:
- implementation patterns worth reusing
- Snowflake and Databricks guidance that reads well as a portfolio
- SQL snippets for common warehouse tasks
- notes on tools and tradeoffs inside those three areas
How the content is organized
- Snowflake playbooks for warehousing, ingestion, governance, performance, and cost
- Databricks playbooks for notebooks, jobs, environments, assistant workflows, and delivery patterns
- SQL articles for validation queries, transformations, SQL Server, and warehouse patterns
Engineering principles
- Make the system easier to reason about before trying to make it clever.
- Favor boring, debuggable patterns when they solve the problem well.
- Keep data contracts explicit and visible.
- Reduce manual steps before automating them.
- Build references that are easy to reuse later.
Reach out