Data Engineer

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