About Us.
We're a leading insurance company on the cusp of a data revolution. We're modernizing our entire data and technology stack, and we need additional analytics engineers to help us make it happen. If you're passionate about turning complex data challenges into elegant solutions, this is your chance to make a significant impact.
About the Role.
As an Analytics Engineer, you'll be a key player in our data architecture transformation. Your SQL expertise will be the foundation upon which we build our new medallion-style data architecture. You'll be working with cutting-edge tools like Databricks and dbt, turning our data into a powerful, unified ecosystem that drives business decisions.
What You'll Do.
- Contribute to the development of our new medallion-style data architecture in Databricks, translating your analytical expertise into robust data models
- Build out PURE’s data dictionary by creating high-quality user-friendly documentation for new and refactored data pipelines
- Harness the power of dbt to unify and standardize hundreds of regulatory data calls, building out the "platinum" layer of our data warehouse and ensuring data consistency across the organization
- Collaborate with cross-functional teams to deeply understand business needs, translating them into elegant technical solutions that drive decision-making
- Implement data models, ETL processes, and data quality checks, ensuring data integrity and reliability
- Optimize data pipelines for performance and scalability, allowing for faster and more efficient data analysis
- Work with cutting-edge tools such as Databricks, dbt, Hex, and semantic layer technologies, expanding your technical toolkit
What we're looking for.
- Bachelor's degree in Computer Science, Mathematics, Statistics, or a related field
- Minimum of 2 years of analytics engineering or similar experience, with a strong focus on SQL
- Proven track record of solving complex data challenges using advanced SQL techniques
- Ability to communicate technical concepts clearly to both technical and non-technical audiences
- Working knowledge of data modeling concepts and best practices
Preferred Qualifications:
- Experience with dbt, demonstrating ability to quickly adapt to modern data tools
- Proficiency in Python or other programming languages used in data analysis• Familiarity with Databricks or similar big data platforms
- Knowledge of insurance industry data and regulatory requirements
- Experience BI tools (e.g. Hex, Tableau, PowerBI ,or similar) showcasing your end-to-end data skills
- Understanding of semantic layer implementation and benefits
If you're ready to push the boundaries of what's possible with SQL and play a crucial role in shaping the future of data at a leading insurance company, we want to hear from you. Join us in building a data architecture that will drive our business forward for years to come.
The base salary for this role can range from $95,000 to $115,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
What We Do
PURE is a specialty property and casualty insurer dedicated to helping a membership of responsible people protect high value homes, jewelry, artwork and other fine assets.
We opened for business more than 15 years ago with the goal of offering something different in the insurance space: a company focused on promoting transparency, alignment of interests and doing what’s right. Our focus helps to keep premiums fair and service astonishingly good.
After growing at least 15% year over year since inception, we are the most awarded insurer in our category, offering coverage in all 50 states. Today, our membership is made up of more than 100,000 financially successful individuals and families and continues to grow sustainably.
#LoveYourInsurance #JoinTheClub
.png)
