Senior Analytics Engineer — Snowflake Data Modeling & BI

Bamboo Insurance; United States; Presencial; USD 135.000 - 165.000; Tempo integral

Resumo da vaga

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.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

SQL

Data Modeling

Data Validation

Communication

Independent Work

Formação

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

Ferramentas

Snowflake

dbt

Power BI

Tableau

Pyramid

Looker

Descrição da vaga

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.