Lead Data Engineer: Snowflake & ETL Architect

Magna Legal Services, LLC; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Magna Legal Services is seeking a hands-on Lead Data Engineer to lead the design, development, and evolution of our enterprise data platform. You will own the Snowflake data warehouse, architect scalable ETL/ELT pipelines, and set engineering standards to deliver reliable data solutions across the organization.

You will mentor data engineers and analysts, partner with stakeholders, and drive modernization of data infrastructure in a fast-growing environment.

Qualifications

• Bachelor's degree in computer science, information technology, engineering, or a related field.
• 5+ years of progressive experience in data engineering with leadership responsibilities.
• Advanced hands-on experience with Snowflake including warehouse architecture, performance tuning, security and cost optimization.
• Advanced SQL skills and Python for data processing, automation, and troubleshooting.
• Strong experience designing and operating scalable ETL/ELT pipelines with orchestration, testing, monitoring, and production support.
• Hands-on experience with dimensional data modeling and medallion/star schema architectures, using dbt or similar tools.
• Experience with Azure Data Factory or similar cloud orchestration platform, plus modernization of legacy pipelines.

Responsibilities

• Own the Snowflake data warehouse architecture, performance, security, reliability and cost efficiency.
• Lead design and development of scalable ETL/ELT pipelines across data sources and destinations, including Azure Data Factory evolution.
• Set engineering standards for code quality, testing, documentation, version control, deployment, monitoring and data quality.
• Design and develop dimensional data models using star schemas within a medallion architecture with dbt.
• Collaborate with stakeholders to translate data needs into a prioritized technical roadmap and reusable data solutions.
• Provide guidance through design reviews, mentor engineers, and help resolve complex technical challenges.
• Evaluate new tools and patterns to improve scalability, reliability, maintainability and delivery efficiency.
• Lead data engineering initiatives end-to-end while promoting data governance and responsible data practices.

Skills

Advanced SQL

Python scripting

Data modeling

Mentoring

Communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

Snowflake

dbt

Sigma

Azure Data Factory

Job description

Magna Legal Services is seeking a hands-on Lead Data Engineer to lead the design, development, and evolution of our enterprise data platform. You will own the Snowflake data warehouse, architect scalable ETL/ELT pipelines, and set engineering standards to deliver reliable data solutions across the organization.

You will mentor data engineers and analysts, partner with stakeholders, and drive modernization of data infrastructure in a fast-growing environment.