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.