Senior Analytics Engineer

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.

Job Description

As a Senior 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.

Key Responsibilities:

• Spearhead the development of our new medallion-style data architecture in Databricks, translating your analytical expertise into robust data models

• 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

• Design and implement sophisticated 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, PowerBI, and semantic layer technologies, expanding your technical toolkit

• Act as a data champion, mentoring other analysts and promoting best practices in data modeling and analysis

Requirements:

• Bachelor's degree in Computer Science, Mathematics, Statistics, or a related field

• Minimum of 3 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

• Experience with cloud-based data warehouses and big data technologies

• Solid understanding of data modeling concepts and best practices

• Proficiency in Python or other programming languages used in data analysis

Preferred Qualifications:

• Experience with dbt, demonstrating ability to quickly adapt to modern data tools

• Familiarity with Databricks or similar big data platforms

• Knowledge of insurance industry data and regulatory requirements

• Experience with PowerBI or similar BI tools, 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.

General Description of the IDEAS Department

PURE Insurance is actively investing in our data, analytics, data science, machine learning (ML), and artificial intelligence (AI) capabilities. Toward this, we are building a centralized Data & ML/AI department with specialists across 10 key roles: Data Architects, Data Engineers, Analytics Engineers, Data Visualization Engineers, Data Product Managers, Data Analysts, Data Scientists, ML/AI Engineers, ML Operations (MLOps) Engineers, and Data Governance Professionals. As a member of the team, you will have unique opportunities for growth and collaboration since this diverse team structure allows you to deepen your expertise while gaining insights into related technical areas.

The combination of enterprise-wide specialization and department-specific problem-solving means you will engage with every function within the complex insurance ecosystem (from IT/Technology to all business units, including Underwriting, Claims, Customer Experience, Actuarial/Pricing, Product Management, Sales/Marketing, Distribution, HR, and Finance). Moreover, you will have the opportunity to shape, establish, and work with cutting-edge products within the modern Data & ML/AI technology stack, such as Databricks, dbt, GitHub, Hex, and Arize. In cases where it provides a competitive advantage, you will also develop in-house production-grade software in Python and other programming languages. Leveraging these technologies, you will streamline the transformation of first-party and third-party data into actionable insights, placing you at the forefront of innovation and directly driving business value.

The ideal candidate for the Data & ML/AI department at PURE Insurance embodies resolve and a commitment to doing the right thing, even when it requires taking the more challenging path forward. They balance delivering short-term value with building a robust, scalable foundation. This individual thrives in a dynamic and collaborative environment, communicates effectively with a diverse set of stakeholders, and prioritizes their time to align with our strategic goals. They are dedicated to leveraging their expertise and their colleagues’ complementary skills to drive continuous improvement and learning. Above all, they are accountable, transparent, and take ownership of their responsibilities, fostering trust and high performance in the team.

PURE Insurance’s company culture is a major differentiator. The leadership team understands that building a strong foundation in Data and ML/AI can take years, and they embrace the fact that learning from mistakes is an important part of the journey. PURE invests heavily in its people, prioritizing growth and development and offering extensive opportunities for mentorship, knowledge sharing, and career advancement. We seek individuals eager to think outside the box, apply insights from other companies, and challenge the status quo. Your voice matters here, and you are encouraged to speak up and make your impact felt across the organization. Join us and be part of a self-organizing Data & ML/AI department where your contributions are truly valued and will be impactful toward making PURE Insurance an industry leader in Data and ML/AI.

All positions in the Data & ML/AI Department at PURE Insurance are for full-time remote employment, where you can work anywhere in the USA. If you prefer, you can also work at one of the PURE Insurance offices located throughout the USA, including White Plains (NY), New York (NY), Warren (NJ), Chicago (IL), Boston (MA), Charleston (SC), Atlanta (GA), Fort Lauderdale (FL), Scottsdale (AZ), San Francisco (CA), and San Diego (CA).

The base salary for this role can range from $120K - $175K, 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.