Data Engineer I

Mercury Insurance

. Design, build, and launch high-quality big data/data lake solutions on cloud platforms, preferably AWS .

Posted 9/30/2026full-timeRemote • United StatesJunior💰 $83,670 - $161,815 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing big data solutions on cloud platforms, particularly AWS, while leveraging advanced data analytics and engineering practices. Proficient in Python and SQL programming, with a strong ability to optimize data processes and collaborate effectively with cross-functional teams.

Highest-signal resume keywords

Big Data Solutions DesignAWS Cloud PlatformsPython ProgrammingSQL Query Performance TuningData Analytics and Engineering

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data IntegrationETL PatternsData ManipulationNatural Language ProcessingData MiningData AnalyticsData HousekeepingData NormalizationAlgorithmic ConceptsData Modeling

Soft Skills

Problem-SolvingAnalytical ThinkingCritical ThinkingWritten CommunicationVerbal Communication

Tools & Technologies

AWS S3AWS GlueAWS EMRAWS RedshiftSnowflakeGitHubSparkDockerEKSCI/CD Practices

Industry Keywords

Data LakeData WarehouseData CubeData IngestionData Integration PipelinesVendor API CallsSecure Data DeliveryCloud-Based InfrastructureAutomation FrameworkCross-Functional Collaboration

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloudDockerETLJavaPythonSparkSQL

About the role

Key responsibilities & impact

Design, build, and launch high-quality big data/data lake solutions on cloud platforms, preferably AWS
Solve data integration problems using optimal ETL patterns, frameworks, and query techniques
Source data from structured and unstructured data sources
Own existing production processes and optimize complex code through advanced algorithmic concepts
Extract and manipulate data from data lakes, data warehouses, and data cubes
Collaborate with data analysts and data scientists to develop solutions for complex data problems
Identify data opportunities to drive profitable growth
Proactively identify pain points in existing data models
Fulfill data-related requests using existing data infrastructure
Perform data housekeeping, cleansing, normalization, hashing, and required data model changes
Analyze data to identify anomalies, trends, and correlations
Design, develop, and implement natural language processing software modules
Enhance automation framework features, develop tools, and integrate automation into the software development lifecycle
Work with cross-functional teams to minimize manual efforts and ensure testing meets business and regulatory requirements
Perform other assigned functions

Requirements

What you’ll need

Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field OR equivalent combination of education and/or experience
1 or more years of experience in data analytics, data engineering, and/or data science
1 or more years of experience in architecting/designing and leading development of big data/data lake solutions on Cloud platforms, preferably AWS (S3, Glue/EMR, Athena, AppFlow)
1 or more years of experience in Python or Java programming
1 or more years of experience in writing SQL statements and query performance tuning
1 or more years of experience in RDMS or MPP databases, preferably AWS Redshift or Snowflake
Expert in Python and/or SQL programming; some experience with R preferred
Solid experience with cloud-based advanced data and analytics environment
Knowledge of working with AWS, GitHub, and other cloud-based infrastructure
Expert data skills and ability to work with large structured and unstructured data sources
Excellent problem-solving, analytical, critical thinking, written, and verbal communication skills
Preferred experience supporting or building AWS cloud-based data platform workflows, including S3, Lambda, Docker, and EKS
Preferred experience working with Spark for large-scale data processing, transformation, or dataset preparation
Preferred exposure to data ingestion or integration pipelines, vendor API calls, and secure data delivery into a data lake
Preferred familiarity with CI/CD practices and cross-functional infrastructure support
Preferred exposure to AI and automation
Demonstrated understanding of data/analytics engineering best practices
Demonstrated expert skills in data mining and data analytics
Demonstrate Company’s Core Values

Benefits

Comp & perks

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