Magna Legal Services is a provider of end-to-end legal support services, seeking a Data Engineer to lead the design and scalability of their Snowflake data platform. This role is crucial for building enterprise-grade data models and enabling analytics and AI use cases through a secure, high-performing data foundation.
Responsibilities:
- Design, own, and maintain core enterprise data models
- Provide architectural leadership by defining and enforcing data engineering standards and best practices
- Implement and manage Snowflake security and RBAC, ensuring secure, scalable access across analytics and AI use cases
- Build and maintain reusable dbt macros, seeds, and utility functions
- Leverage advanced dbt features including incremental models, snapshots, and exposures
- Optimize and refactor complex SQL for performance, reliability, and maintainability
- Implement and maintain CI/CD workflows (Git branching, automated testing, code reviews)
- Monitor Snowflake warehouse and query performance
- Drive Snowflake cost optimization initiatives (warehouse sizing, caching, workload management)
- Mentor and support junior data engineering resources
- Partner with leadership to co-own Snowflake COE and data governance practices
Requirements:
- 5+ years of experience in data engineering or analytics engineering
- Deep hands-on experience with Snowflake, including performance tuning and RBAC
- Strong production experience with dbt
- Advanced SQL skills with a focus on optimization
- Experience implementing CI/CD pipelines for data teams
- Ability to design scalable, reusable data architectures
- Strong communication skills and comfort working cross-functionally
- Experience with enterprise data governance or COE models
- Exposure to AI/ML data enablement
- Experience managing cloud data platform costs