Senior Analytics Engineer

Role Summary

We are seeking a strong Analytics Engineer to join our Data Strategy and Architecture team. This role will help design, build, validate, and maintain trusted analytical data assets that support reporting, business intelligence, operational analytics, and executive decision-making. The Analytics Engineer will work closely with business stakeholders, data engineers, data architects, analysts, and reporting teams to translate business requirements into scalable data models, curated datasets, and high-quality reporting layers. This is a hands-on technical role requiring strong SQL, data modeling, data validation, and business analysis skills. The ideal candidate has experience working in a modern cloud data platform, preferably Snowflake, and understands how to build governed, reusable, and reliable analytical datasets. Experience in Property and Casualty insurance is strongly preferred.

Key Responsibilities

• Data Modeling and Analytics Engineering
• Design, build, and maintain analytical data models for reporting and business consumption.
• Develop curated datasets, fact tables, dimension tables, marts, and semantic-ready data layers.
• Build scalable transformations using SQL, dbt, Snowflake, or similar modern data tools.
• Move complex business logic out of reports and into governed data models.
• Support medallion-style data architecture across Bronze, Silver, and Gold layers.
• Optimize queries and models for performance, usability, and maintainability.
• Business Requirements and Data Mapping
• Partner with business stakeholders to understand reporting needs, KPIs, and data definitions.
• Translate business requirements into source-to-target mappings and analytical data models.
• Create documentation for business rules, transformation logic, metric definitions, data lineage, and known gaps.
• Work with business SMEs to clarify ambiguous definitions and resolve data interpretation issues.
• Support requirements across Policy, Billing, Claims, Finance, Underwriting, Agency, and Operations domains.
• Data Quality, Testing, and Reconciliation
• Build validation checks to ensure data completeness, accuracy, consistency, and traceability.
• Perform reconciliation between source systems, data warehouse layers, and BI reports.
• Create SQL-based testing scripts, dbt tests, and automated data quality checks.
• Investigate data issues and determine whether defects are caused by source data, transformation logic, model design, or reporting logic.
• Support User Acceptance Testing (UAT) and help business users validate reports, extracts, dashboards, and metrics.
• Reporting and BI Enablement
• Prepare trusted datasets for BI tools such as Power BI, Tableau, Pyramid, Looker, or similar platforms.
• Partner with report developers and analysts to improve report accuracy and performance.
• Support executive dashboards, operational reports, financial reporting, and regulatory or audit-related extracts.
• Ensure reporting datasets are reusable, well-documented, and aligned with enterprise standards.
• Collaboration and Delivery
• Work closely with Data Engineering, Architecture, Business Intelligence, Product, Finance, Claims, and Operations teams.
• Participate in Agile delivery, sprint planning, backlog refinement, and release validation.
• Communicate data issues, risks, dependencies, and tradeoffs clearly to both technical and business audiences.
• Take ownership of assigned models, datasets, defects, and deliverables.

Required Qualifications

• Bachelor's or Master's degree in Finance, Accounting, Economics, Business Administration, Statistics, Mathematics, Computer Science, or Engineering
• 5+ years of experience in analytics engineering, data analysis, BI engineering, data warehousing, or a similar data role
• Strong SQL skills, including joins, CTEs, aggregations, window functions, data profiling, reconciliation, and performance tuning
• Experience building analytical data models in Snowflake, or similar cloud data platforms
• Experience with dbt or similar SQL-based transformation frameworks
• Strong understanding of dimensional modeling, fact and dimension design, star schemas, and curated data layers
• Experience translating business requirements into data mappings, transformation logic, and reporting datasets
• Strong data validation, reconciliation, and root-cause analysis skills
• Experience supporting BI tools such as Power BI, Tableau, Pyramid, Looker, or similar
• Ability to work independently with business and technical teams
• Strong communication skills with the ability to explain data issues in clear business terms

Preferred Qualifications

• Property and Casualty insurance experience strongly preferred
• Experience with Guidewire PolicyCenter, BillingCenter, ClaimCenter, BriteCore, or similar insurance platforms

Salary

Starting at $150,000 annually. Candidate's skills, experience and abilities will be taken into consideration for final offer.