Senior Analytics Engineer

OhioX; Dublin (OH); À distance; USD 85 000 - 139 000; Plein temps

Avantages offerts par ce poste

Medical, Dental, Vision

401(k) with company match

Employee Assistance Program

Parental Leave

Disability and Life Benefits

Résumé du poste

Bold Penguin is seeking a Senior Analytics Engineer to design data models, migrate from legacy tools, and build self-service analytics using Sigma and Hex. You will shape data strategy, implement a modern data stack with Snowflake, and collaborate with business teams to deliver insights and AI-powered applications.

The role emphasizes strong SQL, Python, and data governance, with remote work options and a fast-paced insurance-tech environment.

Qualifications

• 5+ years of experience in analytics engineering or a similar technical role.
• Expert-level SQL skills with deep understanding of data warehouse concepts.
• Hands-on experience with dbt for data transformation and modeling — dbt core experience 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 (Redshift) or BI tool (Tableau) to a modern analytics stack.
• Expert-level experience with Snowflake as a cloud data warehouse (required); familiarity with AWS Redshift a plus for migration context.
• Proven experience building and maintaining a semantic layer / metrics catalog to serve multiple downstream applications.
• Working knowledge of Python for analytics automation, predictive modeling, and reporting.
• Experience with version control systems (Git) and CI/CD practices.
• Practical experience leveraging AI/LLMs within a data stack to solve business problems — including prompt engineering, AI-assisted analytics, or GenAI tools in Hex, Sigma or Snowflake.
• Experience with data lakehouse technologies, including Apache Iceberg and AWS Glue (a plus)
• Experience in commercial insurance, financial services, or venture-backed technology companies
• Track record of building data solutions in B2B SaaS or enterprise software companies
• Experience using JIRA for project management and tracking
• Excellent communication skills with high attention to detail
• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field
• Self-starter who thrives in a fast-paced environment, capable of juggling multiple initiatives and meeting strict deadlines

Responsabilités

• Design, build, and maintain data models using dbt core.
• Lead and execute migration of data assets from Redshift/Tableau to Snowflake/Sigma/Hex.
• Build interactive data applications, dashboards, and reports in Sigma/Hex for self-service analytics.
• Govern centralized semantic layer to standardize metrics for multiple apps.
• Develop Python scripts for analytics automation and predictive modeling.
• Implement data quality testing frameworks for reliability.
• Integrate AI/LLMs into analytics workflows to automate enrichment and modeling.
• Create and manage JIRA epics, stories, and tasks.
• Collaborate with stakeholders to translate business needs into technical solutions.
• Additional duties as assigned.

Connaissances

5+ years analytics engineering

SQL proficiency

dbt core expertise

Sigma/Hex dashboards

Redshift/Tableau migration

Snowflake expertise

semantic layer / metrics catalog

Python for analytics

Git & CI/CD

AI/LLMs in data stack

Iceberg / AWS Glue

insurance/fintech domain

data solutions in B2B SaaS

JIRA

communication & detail

Bachelor's degree in CS/ENG/math

fast-paced environment

Formation

Bachelor's degree in Computer Science, Engineering, Mathematics, or related field

Outils

Snowflake

Sigma

Hex

Python

Git

Description du poste

• Location Remote - United States
• Base Pay $84,900.00 - $139,000.00 / Year
• Other Compensation Annual Performance Bonus Eligible
• Job Category Analytics Engineering, Business Intelligence, Data Engineering
• Relocation Expense Covered No
• Employee Type FT Exempt

Description

We're seeking a Senior Analytics Engineer to help shape the future of data-driven decision making at our rapidly growing, insurance technology company. As a key member of our data team, you'll architect and implement analytics solutions that power both strategic insights and operational workflows. You'll work at the intersection of our modern data stack and business operations — building robust data models, designing self-service data applications, and leading the migration from our legacy Redshift and Tableau environment to our modern stack.

This role offers a unique opportunity to work with cutting-edge tools (dbt, Snowflake, Sigma, Hex, Claude) while having significant influence on our data strategy and technical architecture. You'll collaborate closely with business teams to transform complex data into actionable insights, self-service analytics and AI-powered applications.

What You'll Do

• Design, build, and maintain data models using dbt core, ensuring efficient, scalable, and well-documented analytics solutions
• Lead and execute the migration of data assets from Redshift and Tableau to our modern stack — Snowflake, Sigma, and Hex — ensuring data quality and business continuity throughout
• Build interactive data applications, dashboards, and reports in Sigma and Hex that enable self-service analytics for business stakeholders
• Design, build, and govern our centralized semantic layer to standardize business metrics and enable true 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 to ensure reliable, trustworthy data
• Integrate AI and LLM capabilities (including Claude) into analytics workflows to automate 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
• Additional duties and responsibilities as assigned.

Requirements

YOUR LOCATION

This is a fully remote role, with the exception of onboarding and optional in-office events.

SKILLS & EXPERIENCE

• 5+ years of experience in analytics engineering or a similar technical role
• Expert-level SQL skills with deep understanding of data warehouse concepts
• Hands-on experience with dbt for data transformation and modeling — dbt core experience 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 (Redshift) or BI tool (Tableau) to a modern analytics stack
• Expert-level experience with Snowflake as a cloud data warehouse (required); familiarity with AWS Redshift a plus for migration context
• Proven experience building and maintaining a semantic layer / metrics catalog to serve multiple downstream applications
• Working knowledge of Python for analytics automation, predictive modeling, and reporting
• Experience with version control systems (Git) and CI/CD practices
• Practical experience leveraging AI/LLMs within a data stack to solve business problems — including prompt engineering, AI-assisted analytics, or GenAI tools in Hex, Sigma or Snowflake
• Experience with data lakehouse technologies, including Apache Iceberg and AWS Glue (a plus)
• Experience in commercial insurance, financial services, or venture-backed technology companies
• Track record of building data solutions in B2B SaaS or enterprise software companies
• Experience using JIRA for project management and tracking
• Excellent communication skills with high attention to detail
• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field
• Self-starter who thrives in a fast-paced environment, capable of juggling multiple initiatives and meeting strict deadlines

Physical Requirements

• Must be able to sit/stand/walk for prolonged periods of time (up to 8 hours per day), at a desk working on a computer.
• Must be able to use standard office equipment for extended periods of time, including but not limited to, a mouse, keyboard, phone and video conferencing.

Summary

Bold Penguin is the premier digital broker for commercial insurance. Their technology expands top-of-funnel demand and increases yield for enterprise partners. Through digital distribution, wholesale capabilities, and AI-driven insights, they transform the lifecycle of both simple and complex risks, from prospecting to placement.

Benefits

We offer competitive compensation and progressive benefits that include:

• Medical, Dental, and Vision
• Flexible PTO Policy
• 401(k) with a company match
• Employee Assistance Program
• Parental Leave
• Disability and Life Benefits

Stay connected to the Glacier. We have great SLACK channels for work and play. We also like to video conference and hold all-hands "Waddles" regularly.

Penguin bling. Like swag themed after a certain Antarctic bird? Just. You. Wait.

Bold Penguin believes in inclusion. That’s why we’re proud to be an equal opportunity employer that considers all qualified applicants regardless of race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. To learn more about our results-focused culture and employee-focused perks, read more on our careers page.