Skip to content
View robert-aitken's full-sized avatar

Block or report robert-aitken

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
robert-aitken/README.md

Robert Aitken

Data engineer focused on reliable data pipelines, clean data models and practical analytics workflows.

I work across SQL, dbt, Snowflake, Azure Data Factory and Python, with an interest in maintainable data transformation patterns, analytics engineering and practical use of developer tooling.

Portfolio Projects

Local-first data pipeline using Python, DuckDB and dbt.

Silver award-winning hackathon prototype using natural language to identify available clinical data points and surface data quality information.

Learning, Labs and Workshop References

Date Course / Workshop Focus Evidence
May 2025 Snowflake Healthcare AI / Machine Learning Workshop Cortex AI, Document AI, Cortex Search, Cortex Analyst, notebooks and Streamlit applications Repo
Apr 2026 Snowflake Dynamic Tables Lab Declarative pipelines, target lag, refresh modes and SQL-based pipeline design Repo
May 2026 Snowflake Intelligence Lab Cortex AI, Cortex Search, Cortex Analyst and governed analytical AI applications Repo
May 2026 Snowflake AWS Immersion Day Cortex Code, practical developer tooling and Snowflake data engineering workflows Repo
May 2026 Snowflake Open Pipelines Learning Reference Apache Iceberg, Snowflake OpenFlow, Open Catalog, Apache Polaris, dbt Projects and multi-engine lakehouse patterns Repo
May 2026 dbt Fundamentals dbt project structure, models, sources, tests and analytics engineering concepts Repo

Current Interests

  • Reliable data pipelines
  • Clean transformation layers
  • Data modelling
  • Analytics engineering
  • Practical developer tooling

Repository Notes

Repository names use labels such as project, learning-project, lab-reference, workshop-reference and learning-reference to distinguish original portfolio work from guided labs, workshops, course material and archived learning references.

Older archived repositories show earlier C#/.NET and SQL Server/SSIS experience, while newer repositories focus on data engineering, analytics engineering, Snowflake, dbt and Python.

Pinned Loading

  1. oyster-journey-data-platform oyster-journey-data-platform Public

    Local first Oyster journey data pipeline using Python, DuckDB and dbt.

    Python

  2. microsoft-hackathon-2026-data-champs microsoft-hackathon-2026-data-champs Public

    Silver award winning project from the Microsoft GitHub Copilot Hackathon 2026. A synthetic-data prototype that uses natural language to identify available clinical data points and surface data qual…

    Python