Senior Analytics Engineer

present of AI; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

FINNY AI in New York City is seeking a Senior Analytics Engineer to own the data warehouse layer and model raw data into clean, tested tables for a financial advisor growth platform.

The role emphasizes building analytics foundations with careful data quality, definitions, and trust, leveraging dbt, Snowflake, and SQL. This position offers a hands-on opportunity to shape data standards in finance-related domains.

Qualifications

• Proven expertise with SQL, dbt, and Snowflake in building analytics foundations.
• Experience designing and modeling data warehouses with tested, documented tables.
• Ability to establish conventions and standards from scratch for data quality and trust.
• Finance/insurance data domain knowledge is a plus.

Responsibilities

• Own the data warehouse layer and model raw data into clean, tested tables.
• Set conventions and standards for data quality and trust from scratch.
• Collaborate with teams querying the warehouse via AI assistants.
• Develop documentation and tests for data models.

Skills

SQL

dbt

Snowflake

Data modeling

Data testing

Tools

dbt Core

Snowflake

Job description

AI & Data · New York City · FullTime · Senior level

A senior analytics engineer typically owns the data warehouse layer: modeling raw data into clean, tested, documented tables that others can trust. A strong candidate brings solid SQL, hands on dbt and Snowflake work, and the judgment to set conventions from scratch. Here that means building the first analytics foundation for a financial advisor growth platform, so care with money related and prospect data matters.

How it fits the AI era

AI tools speed up writing SQL, generating models and drafting documentation, so the craft shifts toward review, testing and deciding what the data should mean. Judgment about data quality, definitions and trust stays human, and becomes more important as more people query the warehouse through AI assistants. A first analytics engineer sets those standards early.

How it builds AI experience

The role offers a chance to learn how AI assisted querying and modeling fit into a warehouse built on dbt and Snowflake, and how to keep AI generated models honest with tests. Building familiarity with dbt tests, documentation and version control shows readiness. Interest in finance and insurance data adds a useful edge.

Worth showing

• dbt Core modeling
• Snowflake warehouse design
• Advanced SQL
• Data testing and docs

This is our own read, written from the employer's posting and the company's Spotlight. The employer's posting is the source of truth for the role.

About FINNY AI

AI organic growth engine and prospect intelligence platform for financial advisors, per the company.