Note: The job is a remote job and is open to candidates in USA. Mercury Insurance is an insurance company seeking an Associate Data Engineer to support its analytics and data science teams. The role assists with building and maintaining data pipelines, ingesting and transforming data, monitoring infrastructure, performing data quality tasks, and documenting data assets using AWS, Snowflake, SQL, and Python.
Responsibilities
- Assist in building and maintaining reliable batch data pipelines on AWS and Snowflake using SQL and Python, following established patterns and templates
- Help implement data ingestion from structured sources; support work with semi/unstructured data with guidance
- Monitor scheduled jobs, troubleshoot basic data load issues, and escalate when needed
- Perform routine data quality checks, profiling, cleansing, normalization, and basic hashing/tokenization per standards
- Create and maintain tables, views, and simple data models; contribute to data dictionaries and documentation
- Write basic queries to support analysts and data scientists; validate outputs against source data
- Participate in code reviews; use version control (Git) and follow CI/CD, security, and privacy best practices
- Collaborate with analytics, data science, and engineering teams to understand data needs and deliver small enhancements
- Support data housekeeping tasks (e.g., partition management, cost/performance hygiene) under mentorship
- Other duties as assigned
Skills
- * Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field
- * Completion of the Summer 2026 Internship at Mercury Insurance
- * 1 or more years of experience in data analytics, data engineering, and/or data science
- * Demonstrate Company's Core Values
Benefits
- Flexibility to work from anywhere in the United States for most positions
- Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
- Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
- Medical, dental, vision, life, and pet insurance
- 401 (k) retirement savings plan with company match
- Engaging work environment
- Promotional opportunities
- Education assistance
- Professional and personal development opportunities
- Company recognition program
- Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more
Company Overview
Company H1B Sponsorship