Job Description
Note: The job is a remote job and is open to candidates in USA. Bamboo Insurance is seeking a Senior Sales Data Analyst to leverage insights from data to enhance their go-to-market strategies across distribution channels. The role involves extracting, structuring, and analyzing raw data to support distribution strategy and collaborating with cross-functional teams.
- Responsibilities
- Develop and write advanced SQL queries against raw data lake environments (not pre-modeled tables)
- Build clean, structured datasets from fragmented, messy source data - including designing transformations, data models, and repeatable logic
- Design and build management reports, dashboards and scorecards to analyze customer and agent behavior
- Perform deep-dive analytics using statistical methods, segmentation, and cohort analysis to monitor ongoing performance across distribution partners, identifying opportunities to increase sales and customer conversions
- Assist in the onboarding of new partners, validating data pipelines, ensuring field mapping, and establishing ongoing monitoring logic
- Build and refine the ideal customer profile for direct-to-consumer marketing
- Partner with engineering, actuarial, underwriting, and marketing teams to unify data definitions, improve data quality, and support analytical initiatives. Other duties, as assigned
- Skills
- Expert-level SQL with a demonstrated ability to query unstructured/poorly formatted data
- Strong understanding of data structures, ETL concepts, joins, nested logic, partitioning, and performance optimization techniques
- Experience building datasets or data marts from scratch using raw, ungoverned data
- Familiarity with APIs, JSON, and request testing frameworks (Postman, etc.)
- Strong analytical and quantitative skills with the ability to interpret complex data sets (e.g., regression, forecasting, clustering, etc)
- Excellent communication skills, with the ability to convey technical information to non-technical stakeholders
- Detail-oriented mindset with the ability to manage multiple tasks and deadlines
- Proficiency in using analytical tools and software
- Collaborative team player with a proactive and problem-solving attitude
- Bachelor's degree in a quantitative field (Engineering, Computer Science, Finance, Mathematics, Statistics, etc.)
- 5+ years of experience in a data-heavy analytical or technical SQL role. Advanced skills in Microsoft Excel
- Experience with Homeowners' insurance
- Proficiency in Python or equivalent scripting language preferred
- Knowledge of Tableau, Pyramid, or other visualization tool preferred
- Company Overview
- We're a modern, customer-focused insurance provider dedicated to simplifying the insurance experience. NPN 18657046. CA License #0M31082. It was founded in 2018, and is headquartered in Midvale, Utah, USA, with a workforce of 201-500 employees. Its website is https://bambooinsurance.com.
- Company H1B Sponsorship
- Bamboo Insurance has a track record of offering H1B sponsorships, with 3 in 2024, 3 in 2023, 2 in 2022, 1 in 2021. Please note that this does not guarantee sponsorship for this specific role.
Apply Now
Apply Now