Analytics Engineer: Data Models, dbt & Dashboards

FiscalNote; United States; Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive compensation

Equity package

Retirement plan

Job summary

FiscalNote is seeking an Analytics Engineer to build scalable analytics models and data pipelines. You will work with product and operations teams to create reliable data models, dashboards, and reports that empower enterprise decision making.

You will automate workflows, implement tests, and collaborate with stakeholders to design analytics solutions across finance, product, sales, and customer success. The role requires strong SQL, dbt, and data modeling skills, with a preference for Snowflake

Qualifications

• 4+ years in analytics engineering, data analysis, or a related technical role.
• Excellent data modeling proficiency with an eye toward simplicity and modularity.
• Advanced proficiency in SQL, including complex joins, window functions, and CTEs.
• Production experience in at least one dbt project.
• Strong dimensional, relational, or semantic data modeling skills.
• Familiarity with structured, semi-structured and unstructured data formats.
• Experience with data visualization products such as Metabase, Looker, and Tableau.
• Ability to explore and analyze complex datasets.
• Strong communication skills and ability to write thorough, high-quality documentation.
• Basic statistical analysis to identify trends, outliers, etc.
• Git-based development, pull requests, code review, and CI/CD.
• Experience with Snowflake and SnowSQL (preferred).
• Experience with Metabase (preferred).
• Python proficiency (preferred).
• Experience performing data munging and analysis with tools and environments like Pandas/Polars and Jupyter Notebooks (preferred).

Responsibilities

• Build and maintain dbt models with SQL and Jinja for analytics and dataops across departments including finance, product, sales, and customer success
• Harden analytics models via tests, freshness checks, constraints, etc. to ensure the quality and correctness of our data
• Create reports and dashboards in Metabase using the visual query builder
• Conduct ad-hoc analysis to understand our data in depth and answer business questions
• Collaborate with stakeholders across the organization to understand their respective business domains and design analytics solutions for them

Skills

Advanced SQL

Data modeling

Data analysis

Git & CI/CD

Python

Tools

dbt

Metabase

Looker

Tableau

Snowflake

SnowSQL

Jupyter Notebooks

Pandas/Polars

Job description

FiscalNote is seeking an Analytics Engineer to build scalable analytics models and data pipelines. You will work with product and operations teams to create reliable data models, dashboards, and reports that empower enterprise decision making.

You will automate workflows, implement tests, and collaborate with stakeholders to design analytics solutions across finance, product, sales, and customer success. The role requires strong SQL, dbt, and data modeling skills, with a preference for Snowflake