Senior Analytics Engineer
About the 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. This role offers a unique opportunity to work with cutting-edge tools while having significant influence on our data strategy and technical architecture.
Responsibilities
- 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
- 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
- Add additional duties and responsibilities as assigned.
Requirements
- Your location: Fully remote role, with the exception of onboarding and optional in-office events.
- Skills & Experience:
- 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, Hex, 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
- Expert-level SQL and Python skills with expertise in cloud data warehouses, specifically Snowflake (required) and AWS Redshift (preferred)
- Proven experience building and maintaining a semantic layer / metrics catalog to serve multiple downstream applications
- PRACTICAL EXPERIENCE LEVERAGING AI/LLMs within a data stack to solve business problems (e.g., prompt engineering via SQL, vector databases, or utilizing GenAI tools in Hex/Snowflake)
- Experience working with data lakehouse technologies, including Apache Iceberg and AWS Glue is a plus
Benefits
- Competitive compensation
- 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
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.
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.