Magna Legal Services
Magna LS is a litigation consulting and support company providing services from Discovery to Trial.
Data Engineer
Location
United States
Posted
1 day ago
Salary
$130K - $150K / year
Bachelor Degree5 yrs expEnglishSQL
Job Description
• 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.
Job 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.