
Lead Data Analytics Engineer
Posted 11 hours ago

Posted 11 hours ago
This is a fully remote position, open to applicants in California.
• Contribute to the development of Mercury's governed, AI-ready analytics ecosystem.
• Establish enterprise metrics and facilitate reliable insights across underwriting, sales, product, claims, and customer experience.
• Develop highly scalable production data pipelines for advanced analytics and data science teams.
• Conduct ad-hoc analyses for staff in less technical roles.
• Design, assess, and validate data infrastructures.
• Act as a subject matter expert for data throughout the organization.
• Collaborate closely with the Data Science team on intricate analytics and data preparation tasks.
• Design, construct, and deploy advanced data models and visualizations supporting various use cases across departments, products, and states.
• Address complex data integration challenges using ETL patterns, frameworks, querying techniques, and both structured and unstructured data sources.
• Manage existing production processes and enhance complex code utilizing advanced algorithmic concepts.
• Extract and manipulate data from Mercury's data lakes, data warehouses, and data cubes.
• Partner with data analysts and data scientists to devise solutions for intricate data issues.
• Influence organizational functions to pinpoint data opportunities that foster profitable growth.
• Identify challenges within existing data models.
• Address data-related requests and carry out data housekeeping, cleansing, normalization, hashing, and necessary changes to data models.
• Analyze data to uncover anomalies, trends, and correlations.
• Design, develop, and implement natural language processing software modules.
• A bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or a related field, or an equivalent combination of education and/or experience.
• A minimum of 5 years of experience in data analytics, analytics engineering, data engineering, and/or data science.
• At least 3 years of experience in P&C insurance is preferred, but not mandatory.
• Proven experience in building enterprise metrics stores, semantic layers, or governed KPI frameworks, including metric definitions, relationships, hierarchies, and lineage (e.g., with dbt).
• Familiarity with prompt engineering or LLM-powered assistants, including persona design, guardrails, retrieval or knowledge bases, and validation.
• Experience with P&C insurance data such as quote, bind, policy, claims, or agent data.
• Knowledge of orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud.
• Proficiency in SQL and Python for building data pipelines and conducting analyses.
• Experience with AWS (S3, EC2) and Unix/Shell scripting.
• ETL/ELT experience with tools like dbt, Informatica, or Fivetran.
• Familiarity with relational and non-relational databases and data sources.
• Understanding of data pipeline orchestration frameworks and related tools.
• Awareness of CI/CD best practices.
• Expert proficiency with large structured and unstructured data sources.
• Capability to interact with senior management.
• Expertise in analyzing data to identify gaps and inconsistencies.
• Strong conceptual, analytical, and creative thinking skills; comfort with ambiguity.
• Experience in managing and communicating data plans and data models to internal clients.
• Knowledge of data/analytics engineering best practices.
• Advanced skills in data mining and data analytics.
• Familiarity with cloud-based advanced data and analytics environments.
• Excellent problem-solving abilities.
• Strong analytical and critical thinking skills.
• Exceptional written and verbal communication skills.
• Demonstrate the Company's Core Values.
• Competitive compensation.
• Flexibility to work remotely from anywhere in the United States for most positions.
• Paid time off including vacation, sick leave, 9 paid Company holidays, and volunteer hours.
• Incentive bonus programs with potential for holiday bonuses, referral bonuses, and performance-based bonuses.
• Comprehensive medical, dental, vision, life, and pet insurance.
• 401(k) retirement savings plan with company match.
• An engaging work environment.
• Opportunities for promotion.
• 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.
• Bonus potential.
LawnStarter
LawnStarter
LawnStarter
Enfuce
Get handpicked remote jobs straight to your inbox weekly.