[Hiring] Data Engineer I @Mercury Insurance Services

Role Description

The Data Engineer I role focuses on enhancing automation framework features, developing tools, and integrating automation into the software development lifecycle. This position also involves working closely with cross-functional teams to minimize manual efforts and ensure that testing meets both business objectives and regulatory requirements.

Responsibilities

• Design, build, and launch collections of high-quality big data/data lake solutions on Cloud platform preferably AWS.
• Solve challenging data integration problems using optimal ETL patterns, frameworks, and query techniques.
• Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts.
• Expert in all data lakes, data warehouses, and data cubes within Mercury, efficiently extracting and manipulating data from any source.
• Collaborate with data analysts and data scientists to develop solutions for complex data problems.
• Identify data opportunities to drive profitable growth and address pain points faced by Analytics & Data Science.
• Leverage existing data infrastructure to fulfill data-related requests, perform data housekeeping, cleansing, normalization, and implement required data model changes.
• Analyze data to spot anomalies, trends, and correlate similar data sets.
• Design, develop, and implement natural language processing software modules.
• Other functions may be assigned.

Qualifications

• Minimum: Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field OR equivalent combination of education and/or experience.
• Minimum: 1 or more years of experience in data analytics, data engineering, and/or data science.
• Minimum: 1 or more years of experience in architecting/designing and leading development of big data/data lake solutions on Cloud platforms, preferably AWS.
• Minimum: 1 or more years of experience in Python or Java programming.
• Minimum: 1 or more years of experience in writing SQL statements and query performance tuning.
• Minimum: 1 or more years of experience in RDMS or MPP databases, preferably AWS Redshift or Snowflake.
• Preferred: Experience supporting or building cloud-based data platform workflows in AWS.
• Preferred: Experience working with Spark for large-scale data processing.
• Preferred: Exposure to data ingestion or integration pipelines.
• Preferred: Familiarity with CI/CD practices and cross-functional infrastructure support.
• Preferred: Exposure to AI and automation.

Requirements

• A high-level specialist who regularly interacts and works with senior management.
• Expert at analyzing data to identify gaps and inconsistencies.
• Able to multitask, prioritize, and manage time effectively.
• Ability to think conceptually, analytically, and creatively.
• Experience managing and communicating data plans and data models to internal clients.
• Demonstrated solid understanding and passion for data/analytics engineering best practices.
• Expert skills in data mining and data analytics.
• 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.
• Excellent problem-solving, analytical, and critical thinking skills required.
• Excellent written and verbal communication skills required.
• Demonstrate Company’s Core Values.
• Preferred: Proficiency in creating and maintaining libraries to enhance automated capabilities.
• Preferred: Strong knowledge of programming languages commonly used in automation.
• Preferred: Proficiency in agile software development release process and CI/CD practices.
• Preferred: Strong skills in diagnosing issues and scripts.
• Preferred: Ability to follow best practices and receive constructive feedback.
• Preferred: Proficiency in documenting components, usage instructions, and bug reports.
• Preferred: Commitment to staying updated with the latest trends, tools, and technologies.
• Preferred: Meticulous attention to detail to ensure high-quality reliable framework performance.
• Preferred: Multi-tasking skill with a positive attitude.
• Preferred: Excellent organizational skills to manage multiple testing projects.
• Preferred: Ability to adapt to new tools and processes in a fast-paced development environment.

Benefits

• 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.