Associate Data Engineer

Overview Join an amazing team that is consistently recognized for our achievements and culture, including our most recent Forbes award of being one of America's Best Midsize Employers for 2026! Position Summary: As an Associate Data Engineer, you will support the development and upkeep of data pipelines for our analytics and data science teams. With guidance from senior engineers, you’ll help ingest and transform data from internal and external sources, assist with testing and monitoring data infrastructure, and perform basic data quality and documentation tasks across the organization. Geo-Salary Information An in-person interview may be required during the hiring process State specific pay scales for this role are as follows: $76,829 to $142,213 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA) $69,845 to $129,284 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $62,860 to $116,356 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV) The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location. In CA: Typical hiring range is $98,569 to $136,901 Responsibilities Essential Job Functions: 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. Qualifications Education: Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field Experience: 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 About the Company Why choose a career at Mercury? At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it. Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life. We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals. Learn more about us here: https://www.mercuryinsurance.com/about/careers Perks and Benefits We offer many great benefits, including: Competitive compensation 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 Mercury Insurance is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law. Pay Range USD $76,829.00 - USD $142,213.00 /Yr.