Note: The job is a remote job and is open to candidates in USA. Bold Penguin is the premier digital broker for commercial insurance. Their technology expands top-of-funnel demand and increases yield for enterprise partners. As a Senior Analytics Engineer, you will architect and implement end-to-end analytics solutions to drive business outcomes.
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
- 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
- Design, build, and govern our centralized semantic layer to standardize business metrics and enable true self-service analytics across Tableau, Sigma, and Hex
- Integrate AI and LLM capabilities into data pipelines (e.g., via Snowflake Cortex, Hex, or Python) to automate data enrichment, text analysis, and predictive modeling for insurance use cases
- Additional duties and responsibilities as assigned
Skills
- 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
- Track record of building data solutions in B2B SaaS or enterprise software companies
- Working knowledge of Python for predictive modeling, automation, and reporting
- 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
- Experience with data lakehouse technologies, including Apache Iceberg and AWS Glue is a plus
- Experience in commercial insurance, financial services, or venture-backed technology companies
- 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
- 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
- Medical, Dental, and Vision
- Flexible PTO Policy
- 401(k) with a company match
- Employee Assistance Program
- Parental Leave
- Disability and Life Benefits
- 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.
Company Overview
Company H1B Sponsorship