The Data Engineer will enhance and maintain the Snowflake data warehouse, standardize ETL processes, and manage ad hoc data projects while ensuring data optimization and efficiency.
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 versatile and experienced Data Engineer to spearhead the development and optimization of our ETL processes and support our Snowflake data warehouse. This hybrid role is crucial for someone eager to dive into various data engineering tasks, from standardizing ETL processes across the organization to tackling ad hoc projects that arise in a fast-evolving company landscape. Your expertise in Snowflake and ETL process optimization will play a pivotal role in streamlining our data management practices and ensuring our data infrastructure scales efficiently with our growth.
Key Responsibilities
- Lead the enhancement and maintenance of our Snowflake data warehouse, ensuring optimal performance, scalability, and security.
- Design, implement, and standardize ETL processes, focusing on efficiency and consistency across data sources and destinations.
- Evaluate and adopt best practices and tools for data integration, ensuring robust and scalable data pipelines.
- Support the building of numerous star schema data models in a medallion architecture utilizing tools like dbt, Sigma, and others.
- Work closely with stakeholders to understand data needs, delivering custom data solutions and reports that support decision-making across the company.
- Proactively identify opportunities for data process improvements and lead initiatives to implement these changes.
- Manage a variety of ad hoc data engineering projects, demonstrating flexibility and problem-solving skills in a rapidly changing environment.
- Foster a culture of data literacy and best practices within the team and across the organization.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
- 3+ years of experience in data engineering, with a strong focus on ETL process optimization and data warehousing, particularly using Snowflake.
- Demonstrated ability to design, implement, and standardize ETL processes, with a keen eye for automation and improvement opportunities.
- Solid understanding of SQL and experience with scripting languages (e.g., Python) for data processing and automation.
- Hands-on experience with data modeling, preferably in a star schema architecture, and general data architecture best practices.
- Practical experience with data integration tools and methodologies, with a preference for those familiar with transitioning to Azure Data Factory from other ETL frameworks.
- Excellent analytical and problem-solving skills, capable of handling multiple ad hoc tasks in a dynamic and fast-paced environment.
- Strong communication and collaboration skills, with the ability to engage effectively with both technical and non-technical stakeholders.
Compensation: USD $140,000 - $160,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
Azure Data Factory
Dbt
ETL
Python
Sigma
Snowflake
SQL
Similar Jobs
Fintech • Mobile • Software • Financial Services
The Senior Data Engineer will design, build, and maintain data solutions for risk management, focusing on data warehousing and pipeline development. They will mentor other engineers and drive data strategy.
Top Skills:
AirtableAnsibleApache AirflowApache KafkaCloudFormationDbtGithub ActionsGitlab Ci/CdPythonSnowflakeSQLTerraform
Artificial Intelligence • Big Data • Consumer Web • Digital Media • Marketing Tech
The Senior Data Engineer will manage data infrastructure, build data pipelines, develop dashboards for analytics, and ensure data quality while collaborating with various teams.
Top Skills:
AirflowBigQueryDbtFivetranLookerPower BIPythonRRedshiftSnowflakeSQLTableau
Healthtech • Other • Software • Wearables
As a Senior PHP Data Engineer, you will design and build data extraction services, architect data platforms, and tackle complex healthcare data challenges while integrating AI tools into the workflow.
Top Skills:
Ai-Powered Coding ToolsClaude CliHl7 ParsingMySQLPdf ProcessingPHPPostgres
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
