Senior Analytics Engineer

Bold Penguin • Dublin, OH

4d • Remote

About The Position

Bold Penguin is seeking a Senior Analytics Engineer to shape data-driven decision making at an insurance technology company. The role works at the intersection of the modern data stack and business operations, architecting analytics solutions that support strategic insights and operational workflows. The engineer will build data models and self-service data applications, and lead migration from the legacy Redshift and Tableau environment to Snowflake, Sigma, and Hex. The role also collaborates with business teams to turn complex data into actionable insights, self-service analytics, and AI-powered applications.

Requirements

• At least 5 years of experience in analytics engineering or a similar technical role.
• Expert-level SQL skills and a deep understanding of data warehouse concepts.
• Hands-on experience with dbt for data transformation and modeling; dbt Core experience is preferred.
• Proficiency building data applications, dashboards, and reports in Sigma and/or Hex.
• Proven experience leading or executing a migration from a legacy data warehouse such as Redshift or a BI tool such as Tableau to a modern analytics stack.
• Expert-level experience with Snowflake as a cloud data warehouse.
• Proven experience building and maintaining a semantic layer or metrics catalog for multiple downstream applications.
• Working knowledge of Python for analytics automation, predictive modeling, and reporting.
• Experience with Git or other version control systems and CI/CD practices.
• Practical experience using AI or LLMs in a data stack to solve business problems, including prompt engineering, AI-assisted analytics, or GenAI tools in Hex, Sigma, or Snowflake.
• Experience using JIRA for project management and tracking.
• Excellent communication skills and high attention to detail.
• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.
• Self-starter who can thrive in a fast-paced environment, juggle multiple initiatives, and meet strict deadlines.

Nice To Haves

• Familiarity with AWS Redshift for migration context.
• Experience with data lakehouse technologies, including Apache Iceberg and AWS Glue.
• Experience in commercial insurance, financial services, or venture-backed technology companies.
• Track record of building data solutions in B2B SaaS or enterprise software companies.

Responsibilities

• Design, build, and maintain efficient, scalable, and documented analytics data models using dbt Core.
• Lead and execute migration of data assets from Redshift and Tableau to Snowflake, Sigma, and Hex while maintaining data quality and business continuity.
• Build interactive data applications, dashboards, and reports in Sigma and Hex to enable self-service analytics.
• Design, build, and govern a centralized semantic layer to standardize business metrics and enable self-service analytics across Sigma and Hex.
• Develop and maintain Python scripts for analytics automation, predictive models, and operational reporting.
• Implement and maintain data quality testing frameworks.
• Integrate AI and LLM capabilities, including Claude, into analytics workflows for data enrichment, text analysis, and predictive modeling for insurance use cases.
• Create and manage JIRA epics, stories, and tasks to track development work.
• Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
• Perform additional duties and responsibilities as assigned.

Benefits

• Medical, dental, and vision benefits.
• Flexible PTO policy.
• 401(k) with a company match.
• Employee Assistance Program.
• Parental leave.
• Disability and life benefits.
• Work and social Slack channels, video conferences, and regular all-hands events.
• Company-themed swag.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior