Lee A.

ENTERPRISE DATA ARCHITECT | SNOWFLAKE SNOWPRO CERTIFIED (3x) | DBT CERTIFIED DEVELOPER I specialise in designing, building and securing modern cloud data platforms, with particular expertise in Snowflake, dbt and enterprise data architecture. I have successfully architected and delivered two greenfield Snowflake data platforms for freelance clients, taking ownership of the technical architecture and hands-on implementation from initial design through to production. Alongside my freelance work, I work as an Enterprise Data Architect, with extensive hands-on experience in Snowflake security, including Role-Based Access Control (RBAC), role design, key-pair authentication and secure integrations. I combine enterprise-level architecture experience with practical data engineering expertise to deliver secure, scalable, maintainable and cost-effective solutions. WHAT I CAN HELP YOU WITH • Snowflake Architecture & Greenfield Implementations - Design and build complete Snowflake platforms, from initial architecture through to production. • Snowflake Security & Governance - RBAC, role hierarchies, least-privilege access, key-pair authentication and secure service integrations. • Snowflake & dbt Development - Scalable ELT pipelines, dbt models, automated testing and maintainable transformation frameworks. • Data Integration & Ingestion - Reliable pipelines using Airbyte, dltHub, Azure Data Factory, databases, APIs and cloud storage. • Data Platform Modernisation - Migration from legacy systems to modern cloud data platforms. • Performance & Cost Optimisation - Snowflake query performance, warehouse efficiency and cost management. • Data Modelling - Kimball, Data Vault 2.0 and modern data warehousing principles. • Engineering Best Practices - Version control, CI/CD, testing, documentation and reliable deployment processes. • Technical Leadership & Mentoring - Architectural guidance, hands-on support and knowledge transfer. TECHNICAL EXPERTISE Snowflake: Architecture, Security, RBAC, Key-Pair Authentication, Streams, Dynamic Tables, Performance Optimisation Data Transformation: dbt Core, dbt Cloud, SQL, Stored Procedures Data Integration: Airbyte, dltHub, Azure Data Factory, APIs Programming: SQL, Python Data Platforms: Snowflake, SQL Server, PostgreSQL, DuckDB Architecture & Modelling: Kimball, Data Vault 2.0, ELT/ETL, Data Warehousing Orchestration: Apache Airflow, Azure Data Factory Cloud: Microsoft Azure, AWS Analytics: Power BI, Amazon QuickSight PROFESSIONAL CERTIFICATIONS • Snowflake SnowPro Core - Certified three times • dbt Certified Developer • Microsoft Azure Fundamentals (AZ-900) • Microsoft SQL Server 70-461 • Microsoft SQL Server 70-463 WHY WORK WITH ME? I offer a combination of solution architecture, enterprise security, hands-on engineering and technical leadership. Having personally designed and delivered greenfield Snowflake platforms, I understand both the architectural decisions required at the beginning of a project and the practical engineering challenges involved in delivering a reliable production solution. I have experience working with international clients, including US-based organisations, and I'm comfortable collaborating across different time zones. My focus is on delivering solutions that are secure, scalable, maintainable and aligned with your business requirements. If you're planning a Snowflake implementation, modernising an existing platform or need experienced Snowflake architecture, security and dbt expertise, I'd welcome a conversation about your project.