# ============================================================================= # COMPETENCY RECORD - Cedric Ancellin's demonstrated engineering skills and # experience. Third-party technologies and vendors are named as the concrete # skill surface. Professional background / track record. # ============================================================================= # ============================================================ # DATA ENGINEERING & WAREHOUSE - COMPETENCY RECORD # ============================================================ # Core Purpose: # Demonstrated experience building an analytics data warehouse: # a Snowflake galaxy/fact-constellation schema, a dbt semantic # layer, CDC ETL from transactional MySQL, multi-tenant gated # data shares, and formal data-quality/governance enforcement. # ============================================================ summary: > Designed and built an enterprise analytics data warehouse on Snowflake, a galaxy (fact-constellation) dimensional model fed by CDC-style ETL from transactional MySQL, modeled through a dbt semantic layer, exposed to tenants through gated data shares and a REST gateway, and governed by formal grain/FK contracts, an ontology, and daily data-quality KPIs. detail: > The detailed record behind this competency is available to prospective clients on request, under NDA. It is not published here.