Senior Analytics Data Engineer

What you'll do

• Design and maintain scalable data models and delivery solutions for complex operational reporting projects.
• Execute all phases of development for automated data delivery processes using ETL/ELT tools like dbt and Azure Data Factory.
• Write, debug, and optimize advanced SQL queries to maintain high-performing data pipelines.
• Support the migration of existing SAS solutions to modern technologies such as dbt and Power BI.
• Perform root cause analysis and performance tuning for data pipelines, queries, and reporting datasets.
• Automate daily maintenance processes and assist with data and database migrations, testing, and validation.
• Provide technical guidance and mentorship to junior engineers and other team members.
• Contribute to team development standards including documentation, modularization, testing, and code reviews.

What we're looking for

• Must have 5+ years of relevant work experience.
• Must have Property & Casualty (P&C) claims data/analytics experience or P&C insurance industry experience.
• Must be proficient in developing data pipelines using dbt, GitHub, and Airflow.
• Must possess advanced SQL skills to write, debug, optimize, and maintain queries and data pipelines.
• Must have a strong foundation in modern data architecture concepts like data warehouses, data marts, data lakes, and lakehouses.
• Must be able to communicate effectively verbally and in writing.
• Must be able to work independently and in a team environment while multi-tasking.
• Must be able to learn and apply large amounts of technical and procedural information.