Lead analysis and reporting of regulatory data for P&C insurance, collaborating with teams to build SQL queries and modern data pipelines.
About the Role
As a Lead Data Analyst, you’ll be a key player in our data modernization effort, how we build and use data across the company. You’ll focus on developing well-structured, reliable data models in dbt and Databricks, specifically the gold and platinum layers of our medallion architecture.
This role sits at the intersection of analytics and engineering - ideal for someone who’s comfortable writing production-grade SQL, building modular dbt models, and shaping how data is organized for analysis. You’ll work closely with our Data Analytics team, Analytics Engineering, and business teams to ensure data is accurate, consistent, and ready for insight.
What You’ll Do
- Partner with the Analytics Engineering team to align silver-layer and develop gold and platinum layers in dbt
- Build and document reusable, production-grade data assets to support analytics and reporting
- Drive best practices in dbt development, including modularization, testing, and Git-based version control
- Implement data validation and quality checks to ensure trustworthy datasets
- Mentor analysts on SQL, dbt workflows, and data modeling best practices
- Collaborate with key business partners (e.g., Product, Underwriting, Claims) to ensure analytical outputs meet needs
What We’re Looking For
- 4–6+ years of experience in data analytics or analytics engineering, preferably within Property & Casualty (P&C) insurance or another data-rich industry
- Expert-level SQL skills and hands-on experience building dbt projects (macros, testing, documentation, Jinja)
- Familiarity with Databricks SQL or similar cloud data platforms
- Strong understanding of medallion architecture and experience shaping gold/platinum data models
- Experience with Git-based workflows, CI/CD, and collaborative development using dbt Cloud or dbt Core
- Ability to work independently and deliver high-quality data models with minimal supervision
- Solid communication skills and a willingness to partner with business teams when needed
Bonus Points For
- Experience mentoring or leading analytics professionals
- Familiarity with Hex or other data visualization tools
- A passion for clean design, data modeling, and building maintainable systems
Location & Work Environment
This is a full-time, fully remote position. You can work from anywhere in the United States or choose to work from one of PURE Insurance’s office locations, including White Plains (NY), Warren (NJ), Chicago (IL), Boston (MA), Charleston (SC), Atlanta (GA), Fort Lauderdale (FL), Scottsdale (AZ), and San Diego (CA).
The base salary for this role can range from $120,000 to $140,000 based on a full-time work schedule. An individual’s ultimate compensation will vary depending on job-related skills and experience, geographic location, alignment with market data, and equity among other team members with comparable experienceWant to Learn More?
- [Our Values]
- [Our Benefits]
- [Our Community Impact]
- [Our Leadership]
Top Skills
Databricks
Dbt
Git
Hex
Power BI
SQL
Tableau
Similar Jobs
Artificial Intelligence • Fintech • Machine Learning • Social Impact • Software
As a Senior Dealer Success Manager, you'll drive growth for dealership partners in auto finance, delivering exceptional service and onboarding while providing strategic consultation and market insights.
Top Skills:
Data DashboardsSalesforce
.png)
Consumer Web • eCommerce • Machine Learning • Professional Services • Software • Sports • Analytics
The Senior Business Recruiter will source candidates, manage the full-cycle recruiting process, and collaborate with hiring managers to meet hiring needs for corporate and operations roles. They will also propose process improvements and enhance talent pipelines using data-driven strategies.
Top Skills:
Applicant Tracking SystemsCandidate Management SystemsHr DatabasesWorkday
Fintech • Machine Learning • Payments • Software • Financial Services
The Director of Product Management for Virtual Cards will lead a team to optimize and enhance the customer experience, focusing on user growth and product integration with various business lines.
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
