Senior Analytics Engineer

Senior Analytics Engineer
Bold Penguin is a leading integrated digital solution platform dedicated to simplifying small commercial insurance. Our technology makes the quote and bind process quick, effortless, and profitable for all parties - agents, brokers, and carriers. Bold Penguin's innovative product suite has digitized and transformed a slow, manual process resulting in reduced costs, increased efficiency, and better overall outcomes. For more information, please visit www.boldpenguin.com.
Or, simply put....
We simplify commercial insurance.
Flexible Workplace
This role is a flex office/home role and comes with the expectation you will engage onsite a certain number of working days per month, in our brand-new office located in Dublin, Ohio, with your Bold Penguin colleagues and customers. On-site workdays will be managed at the team level to maintain an environment focused on work-life balance, innovation velocity, and the delivery of exceptional customer experiences.
In this role, you will be expected to work 20% of working days per month (4 days per month on average) in the office. This is a minimum expectation. All employees are welcome to work in the office as much as they like. Applicants must be local (within 35 miles) to Dublin, Ohio.
YOUR ROLE
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 end-to-end 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, implementing reverse ETL solutions, and creating impactful visualizations that drive business outcomes.
This role offers a unique opportunity to work with cutting-edge tools (dbt, Census, Tableau) while having significant influence on our data strategy and technical architecture. You'll collaborate closely with customer success, product, and business teams to transform complex data into actionable insights and automated data workflows.
WHAT YOU'LL DO

• Design and maintain data models using dbt, ensuring efficient and scalable analytics solutions
• Create and optimize data visualizations across multiple BI tools
• Design and implement reverse ETL pipelines to sync data to operational systems
• Develop and maintain Python scripts for predictive models and automation
• Build and document reliable data pipelines that transform raw data into analytics-ready datasets
• 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
• Implement and maintain data quality testing frameworks
• Additional duties and responsibilities as assigned.

SKILLS AND QUALIFICATIONS

• 5+ years of experience in analytics engineering or similar technical roles
• Expert-level SQL skills and experience with understanding of data warehouse concepts
• Hands-on experience with dbt for data transformation and data modeling
• Proficiency in building dashboards and reports using Tableau, Sigma, or Power BI
• Experience in commercial insurance, financial services, or venture-backed technology companies
• Track record of building data solutions in B2B SaaS or enterprise software companies
• Working knowledge of Python for predictive modeling, automation, and reporting
• Experience with version control systems (Git) and CI/CD practices
• Experience with reverse ETL tools (Census, Hightouch, or similar)
• Experience using JIRA for project management and tracking
• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field
• Excellent communication skills with high attention to detail
• Candidate is a self-starter who can work in an extremely fast-paced environment while juggling simultaneous 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.
• Occasionally required to stoop, kneel, bend, crouch and lift and carry up to 50 pounds.
• Must be able to access and navigate the corporate office.

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 regularly 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 .
The national salary range for this role is $104,600 to $153,900. The expected starting salary range for this role at Bold Penguin is $116,700 to $142,700.
If you are an applicant who resides in the state of California, please review our Employee Privacy Notice here .