Applying to this job will open a new window on the employer's web site to apply there.
Posted Date
10/28/2025
Description
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 experience Want to Learn More? [Our Values] [Our Benefits] [Our Community Impact] [Our Leadership] PURE Insurance is a property and casualty insurance company—think homes, cars, fine art and collections—designed exclusively for financially successful individuals and families. We're dedicated to delivering an exceptional experience to our members by alleviating stress, solving challenges and removing conflict, wherever possible, from the insurance process. We are deeply committed to fostering a work environment where everyone has an equitable chance to learn, develop and succeed, and where all feel welcome, safe, and supported to do their best work and bring their whole self to PURE. Our team is comprised of empathetic, passionate and curious individuals who are #PUREproud of the work we do and milestones we achieve together. We’re constantly looking for bright individuals with ambitions as high as our own to join our community and contribute to our journey. Joining PURE means creating your own journey, too. We encourage our team members to pursue their personal passions and provide them resources and support to see them come to fruition. Learn more about our culture on LinkedIn. Interested in PURE but don’t see a role that fits? Introduce yourself and we’ll get in touch if an opportunity opens up that seems like a good match.
Salary120,000.00 - 140,000.00 Annual