Responsibilities
- Lead and execute cross-functional analytics projects using advanced SQL and data modeling to uncover actionable business insights and identify optimization opportunities.
- Develop clear, data-driven recommendations to improve operational efficiency, influence product leadership, and support company objectives (including OKR tracking).
- Analyze and map the end-to-end customer journey to understand and measure key touchpoints, helping identify gaps and propose data-informed solutions.
- Design and deliver robust data models, reporting solutions, automated dashboards, and performance metrics to support strategic decisions.
- Integrate, clean, and synthesize data from multiple sources to build comprehensive narratives and actionable business stories.
- Serve as an SQL subject matter expert, mentoring junior team members and promoting best practices in query design, data modeling, and documentation.
- Contribute to a culture of data excellence by exemplifying quality, empathy, and continuous improvement in all analytics processes.
Skills and Qualifications
- Bachelorβs degree in Statistics, Economics, Mathematics, Computer Science, or a related field.
- 5+ years of professional experience in data analysis, business analytics, or a related analytical role.
- Proven expertise in SQL, including complex query design, data modeling, optimization for performance, and thorough code documentation.
- Strong programming skills in Python, R, or similar programming language
- Solid knowledge of analytical and statistical techniques: hypothesis testing, experiment design, data interpretation, and actionable recommendation development.
- Demonstrated experience working with BI/visualization tools like Tableau, Looker, or similar.
- Strong communication skills, with the ability to present technical findings clearly to non-technical business audiences.
- Track record of effective collaboration across product, operations, and cross-functional teams.
- Ability to context switch seamlessly between multiple areas of the business, prioritizing diverse requests and adapting to varied stakeholder needs.
- Passion, drive, and a deep sense of responsibility. We build the systems that keep us and our customers safe!
Bonus Skills
- Experience in insurance underwriting, insurtech, cyber security or fintech sectors.
- Familiarity with operational/business tools, such as Amplitude, Google Analytics, Marketo, Salesforce, Segment, or Zuora.
- Exposure to ETL and analytics workflow tools (e.g., DBT, Airflow).
- Experience using Cursor or other GenAI Assisted IDE for coding
- Understanding of advanced topics like causal inference or other advanced statistical methods.
Compensation
Our compensation reflects the cost of labor across several US geographic markets. The US base salary for this position ranges from $106,500/year in our lowest geographic market up to $156,925/year in our highest geographic market. Consistent with applicable laws, an employee's pay within this range is based on a number of factors, which include but are not limited to relevant education, skills, job-related knowledge, qualifications, work experience, credentials, and/or geographic location. Your recruiter can share more on target salary for your location during the interview process. Coalition, Inc. reserves the right to modify this range as needed.
Perks
- 100% medical, dental and vision coverage
- Flexible PTO policy
- Annual home office stipend and WeWork access
- Mental & physical health wellness programs (One Medical, Headspace, Wellhub, and more)!
- Competitive compensation and opportunity for advancement