The Data Engineer will design and maintain data models on Snowflake, enforce data standards, manage security, optimize SQL, implement CI/CD, and mentor junior staff.
About Us:
Magna Legal Services provides end-to-end legal support services to law firms, corporations, and governmental agencies throughout the nation. As an end-to-end service provider, we can provide strategic advantages to our clients by offering legal support services at every stage of their legal proceedings.
Job Description:
Job Title: Data Engineer
Position Summary:
Magna Legal Services is seeking a Data Engineer to lead the design, security, and scalability of our Snowflake data platform. This role will play a critical part in building enterprise-grade data models, enforcing best practices, and enabling analytics and AI use cases through a secure, high-performing data foundation. You'll help shape a secure, scalable data platform that powers analytics, reporting, and AI across the organization — while setting standards that allow the data team to grow sustainably.
Key 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.
Qualifications:
- 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.
Nice to have:
- Experience with enterprise data governance or COE models.
- Exposure to AI/ML data enablement.
- Experience managing cloud data platform costs.
Compensation: USD $130,000 - $150,000 per year.
An employee’s pay position within the salary range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, travel requirements, revenue-based metrics, any contractual agreements, and business or organizational needs. The range listed is just one component of the total compensation package for employees.
Magna Legal Services provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Top Skills
Ci/Cd
Dbt
Git
Snowflake
SQL
Similar Jobs
.png)
Big Data • Healthtech • HR Tech • Machine Learning • Software • Telehealth • Big Data Analytics
As a Data Engineer II, you will build and optimize data pipelines, define reusable datasets, and create a data validation framework while ensuring user privacy and security.
Top Skills:
AirbyteAirflowArgoAWSDbtDuckdbElasticsearchIcebergLookerPythonSparkSQLTerraform
.png)
Food • Software
The Senior Data Engineer handles ChowNow's data platform, collaborating with teams to enhance data availability and insights, supporting internal and customer-facing products.
Top Skills:
AWSDbtPythonSnowflakeSQL
.jpg)
Big Data • Healthtech • Software
Design, build, and maintain scalable ETL/ELT pipelines using Python, Spark, Databricks, Airflow and SSIS. Integrate and cleanse diverse healthcare datasets, implement Unity Catalog for metadata and governance, optimize Spark performance and JVM tuning, support Medallion architecture, and collaborate with cross-functional teams to automate CI/CD, observability, and data quality processes.
Top Skills:
Apache AirflowSparkAWSCsvDatabricksDeltaGitlab CiJenkinsJvmMedallion ArchitectureNoSQLParquetPythonScalaSQLSsisUnity CatalogXML
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
