Data Engineer
Magna Legal Services
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $130,000 - $150,000 per year
Tech Stack
About the role
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data modelingdata engineeringSnowflakeRBACdbtSQLCI/CDperformance tuningdata architectureautomated testing
Soft Skills
architectural leadershipmentoringcommunicationcross-functional collaboration