Analytics Engineer: Data Models & Dashboards

FiscalNote; United States; On-site; USD 130,000 - 145,000; Full time

Job summary

FiscalNote is seeking an Analytics Engineer to build and maintain dbt models and analytics pipelines across finance, product, sales, and customer success. You will harden models, create dashboards in Metabase, and perform ad-hoc analyses to extract actionable insights.

You will collaborate with product and operations teams to deploy scalable analytics solutions, report to the Director of Data Analytics & BI, and contribute to enterprise decision making.

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 across departments.
• Harden analytics models via tests, freshness checks, constraints, etc.
• 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 design analytics solutions

Skills

SQL

dbt

Python

Data modeling

Analytics

Git

CI/CD

Looker/Metabase/Tableau

Tools

dbt

Metabase

Looker

Tableau

Snowflake

SnowSQL

Python

Job description

FiscalNote is seeking an Analytics Engineer to build and maintain dbt models and analytics pipelines across finance, product, sales, and customer success. You will harden models, create dashboards in Metabase, and perform ad-hoc analyses to extract actionable insights.

You will collaborate with product and operations teams to deploy scalable analytics solutions, report to the Director of Data Analytics & BI, and contribute to enterprise decision making.