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 com