Source description
About the role
Snowflake Platform
Serve as the internal authority on Snowflake architecture, performance tuning, cost governance, and security (RBAC, data masking, network policies).
Design and maintain a scalable, well-documented warehouse structure including database, schema, and object hierarchy standards.
Drive Snowflake feature adoption — dynamic tables, Snowpark, data sharing, and emerging capabilities.
dbt & Transformation Layer
Own the dbt project end-to-end: modeling conventions, testing strategy, documentation standards, and CI/CD integration.
Establish and enforce a layered modeling approach (staging → intermediate → marts) that downstream teams can trust and self-serve.
Azure Data Ecosystem
Lead the design and operation of data pipelines on Azure, including Azure Data Factory
Ensure reliable, monitored data movement from source systems into Snowflake with clear SLAs and alerting.
Team Leadership
Manage, mentor, and grow a team of data engineers — running regular 1:1s, setting performance goals, and building a culture of engineering excellence.
Own hiring, onboarding, and career development for the data engineering function.
Translate business requirements from stakeholders into well-scoped, prioritized engineering work.
Standards & Governance
Define and enforce organization-wide ETL/ELT best practices, naming conventions, and code review standards.
Champion data quality, observability (e.g., dbt tests), and lineage across the platform.
Proactively identify opportunities for data process improvements and lead initiatives to implement these changes.
More at Magna Legal Services
