Position Summary:

As a Lead Data Analytics Engineer you will design and implement production data pipelines for our data science and machine learning team – as well as create data resources for less technical functions – to use every day to evolve our business. The Lead Data Analytics Engineer will design, evaluate, and test data infrastructures and be a subject matter expert for all things data across the organization.

Essential Job Functions:

• Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across all departments, all products, and all states.

• Lead our DataOps transformation with best-in-class tools (such as dbt)

• Solve our most challenging data integration problems, utilizing optimal ELT patterns, frameworks, query techniques, sourcing from structured and unstructured data sources.

• Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts.

• Be an expert in all data lakes, data warehouses, data marts, and data cubes within organization, with no gaps in knowledge. Can efficiently and accurately extract and manipulate data from any source.

• Collaborate with teams of data analysts, data scientists, and machine learning engineers, who research and integrate algorithms to develop solutions that address complex business problems. Influence all functions across the organization to identify data opportunities to drive profitable growth. Proactively identify pain points that our data scientists and broader data citizens face with our existing data models.

• Leverages existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes. Analyzes data to spot anomalies, trends and compare similar data sets.

• Understands the implications of complex data science, machine learning, and actuarial methodologies in order to create, maintain, and analyze loss metrics (e.g., loss development triangles, on-leveling premiums, CAT and large loss loads, etc.), so pure premium and loss ratio-based models and analysis can be done by all relevant personnel across the organization

• Play an active role in our data governance program

• Other functions may be assigned

Education:

• Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field

• Or equivalent combination of education and/or experience

Experience:

• 6 or more years of experience in data analytics, analytics engineering, data engineering, data science, machine learning, or a related discipline.
• 6 or more years of experience in writing SQL statements.
• Highly preferred: 2 of more years of experience with the data built tool (dbt) and Jinja for data transformation

• Preferred: 1 or more years of experience in P&C insurance

Knowledge and Skills:

• A high-level specialist who regularly interacts and works with business and IT partners.

• Expert at analyzing data to identify gaps and inconsistencies

• Able to multitask, prioritize, and manage time effectively.

• The ability to think conceptually, analytically and creatively; comfortable with ambiguity.

• Experience managing and communicating data plans and data models to internal clients.

• Demonstrated solid understanding, and passion for, all areas of data/analytics engineering best practices.

• Demonstrated expert skills in data mining and data analytics

• Expert in SAS and/or SQL programming; some experience with R and Python preferred

• Solid experience with cloud-based advanced data and analytics environment

• Solid experience with AWS, GitHub/GitLab, and other cloud-based infrastructure

• Passionate about using best software engineering practices, including the creation of CI/CD pipeline

• Expert data skills and the ability to work with large structured and unstructured data sources

• Excellent problem-solving skills required

• Excellent analytical and critical thinking required

• Excellent written and verbal communication skills required

• Demonstrate Company’s Core Values