Senior Analytics Engineer

Bamboo Insurance; United States; On-site; USD 135,000 - 165,000; Full time

Job summary

Bamboo Insurance seeks a Senior Analytics Engineer to join the Data Strategy & Architecture team in building trusted analytical data assets that power reporting, BI, and executive decision-making. You will design models, curate datasets, and implement scalable transformations using SQL, dbt, and Snowflake.

The role requires strong SQL, data modeling, and data validation skills, with insurance experience preferred.

Qualifications

• 5+ years in analytics engineering, data analysis, BI engineering, or data warehousing.
• Property and Casualty insurance experience strongly preferred.
• Strong SQL skills: joins, CTEs, aggregations, window functions, profiling, reconciliation, tuning.
• Experience building analytical data models in Snowflake or similar cloud platforms.
• Experience with dbt or similar SQL-based transformation frameworks.
• Strong understanding of dimensional modeling, star schemas, and curated data layers.
• Experience translating business requirements into data mappings 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.

Responsibilities

• 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 tools.
• Move complex logic out of reports into governed data models.
• Support data architecture across Bronze, Silver, and Gold layers.
• Optimize queries and models for performance, usability, and maintainability.
• Partner with stakeholders to understand KPIs and data definitions.
• Document rules, transformations, lineage, and gaps.
• Create validated datasets for BI tools and dashboards.
• Collaborate with report developers to improve accuracy and performance.
• Support executive dashboards, operational reports, and regulatory extracts.

Skills

SQL

Data Modeling

Data Validation

Communication

Independent Work

Education

Bachelor's or Master's in a quantitative/CS field

Tools

Snowflake

dbt

Power BI

Tableau

Pyramid

Looker

Job description

Role Summary

We are seeking a strong Senior 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.

We are seeking a strong Senior 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.
• Document 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 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

• Bachelors or Masters 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.
• Property and Casualty insurance experience strongly preferred.
• 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

• Experience with Guidewire PolicyCenter, BillingCenter, ClaimCenter, BriteCore, or similar insurance platforms.

What This Role Is Not

This is not only a dashboard developer role.

This is not a pure data engineering pipeline role.

This is not a business analyst role with light SQL.

This role requires a strong hybrid profile: SQL depth, data modeling discipline, business understanding, reporting knowledge, testing rigor, and the ability to build reliable analytical data assets in a modern cloud data platform.

Salary

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