Analytics Engineer: Data Modeling & Insights

FiscalNote; Northern (KY); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Retirement accounts

Equity packages

Job summary

FiscalNote is a data-driven policy and global intelligence platform seeking an Analytics Engineer to build scalable analytics models and reporting capabilities across the company. You will work closely with product and operations teams to enable decision making and improve operational efficiency and financial performance.

The role emphasizes SQL, dbt, and data modeling, with opportunities to work in Python and various visualization tools to empower stakeholders across finance, product, sales,

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 like Pandas/Polars and Jupyter Notebooks (preferred).

Responsibilities

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

Skills

SQL

dbt

Data modeling

Python

Data analysis

Data visualization concepts

Git

CI/CD

Tools

Snowflake

SnowSQL

Metabase

Looker

Tableau

Jupyter Notebooks

Pandas

Polars

Job description

FiscalNote is a data-driven policy and global intelligence platform seeking an Analytics Engineer to build scalable analytics models and reporting capabilities across the company. You will work closely with product and operations teams to enable decision making and improve operational efficiency and financial performance.

The role emphasizes SQL, dbt, and data modeling, with opportunities to work in Python and various visualization tools to empower stakeholders across finance, product, sales,