David McCandless
Data architecture specialist with deep expertise in Snowflake, cloud data platforms, and modern data stack design. Founder of McCandless Consulting, helping mid-market and enterprise organizations architect scalable data solutions. Experienced in data warehouse modernization, ELT pipeline design, and analytics engineering with a focus on Snowflake-native patterns.
SnowPro Core Certification
Snowflake
SnowPro Advanced: Architect
Snowflake
SnowPro Advanced: Data Engineer
Snowflake
AWS Certified Solutions Architect - Associate
Amazon Web Services
Snowflake
12 implementationsFull Snowflake implementations including architecture design, data modeling, ELT pipeline development, role-based access control, and performance optimization. Led migrations from on-premise SQL Server and Oracle to Snowflake.
dbt
8 implementationsdbt project setup and analytics engineering including data modeling, testing frameworks, CI/CD pipelines, and documentation. Built modular transformation layers on top of Snowflake.
Fivetran
6 implementationsFivetran connector setup and management for SaaS-to-warehouse data integration. Configured connectors for Salesforce, NetSuite, HubSpot, Stripe, and custom database sources.
AWS
10 implementationsAWS cloud infrastructure for data platforms including S3 data lakes, Lambda functions, Glue ETL, and IAM security configurations supporting Snowflake deployments.
McCandless Consulting
Founder & Principal Consultant
2020-01-01 - Present