Analytics Engineer
About the Position
At FiscalNote, we build platforms that connect people to their governments, and our Data Analytics team builds tools, processes, and reporting capabilities to integrate operational data and enable enterprise decision making. As an Analytics Engineer on the Data Analytics team, you recognize the value of properly managing, analyzing and reporting data to improve operational efficiencies, customer experience, and financial performance, and want to build the data models and analytics capabilities that empower decision making across the company. You will work closely with our product and operations teams to build clean, scalable analytics models which are the backbone of our reporting and advanced analytics capabilities. This role reports to the Director of Data Analytics & Business Intelligence.
About the Team
The Data Analytics team sits at the intersection of data, technology, and strategy at FiscalNote. We build and maintain the systems, models, and reporting infrastructure that enable the entire business to operate with clarity and confidence. Our work connects every function from sales to finance to customer success, ensuring that the right data reaches the right people at the right time to drive informed decisions. Our core mission is to understand the business and impact decision-making across all departments through the effective use of data. We are AI-forward but we do not vibe code. Experience with AI and agentic harnesses is a plus but not required for this role.
About You
You are curious, thoughtful, and detail-oriented. You see technical challenges as puzzles to solve, and can generalize a solution to an individual problem out to an entire class of problems. You dislike doing the same thing manually over and over and enjoy automating systems. You take pride in your work and do not like leaving things half-done. You can operate independently, but have support from your team as needed. You are proficient in SQL and have hands-on experience building data models in dbt. You know how to explore and analyze unfamiliar datasets and find insights in the data. You want to deepen your technical expertise and may have experience with Python or other general-purpose programming languages.
What To Expect In This Position
- 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
What Sets You Apart
- 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)
Skills
As published by lever · 9 questions · 6 written answers
Basics
Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL, GitHub (publicly accessible) URL, Other website
Pick from a list (2)
- If you receive an offer, how much notice would you need to provide to your current employer?
- Will you require any visa or sponsorship assistance, now or in the future, to accept a position with FiscalNote?
Written answers (6)
- Do you have production experience building and maintaining data models in dbt? If so, briefly describe a dbt project you worked on and your specific role in it. If not, please tell us about your closest relevant experience.
- Describe a complex SQL query or data model you've built, including your use of window functions, CTEs, or complex joins.
- This team is AI-forward but values engineers who fully understand the code they ship. How do you use AI tools in your technical work, and how do you make sure you can stand behind what you produce?
- Please provide your current residential address:
- Please share your compensation expectations (including currency) and please be as specific as possible. [Example: base salary, annual commission for relevant positions, etc]:
- Please provide any details you can on the type of visa or sponsorship you require, any current visa or work permit status, and any other details that would be helpful to understanding your sponsorship needs.
Attachments (1)
- Please submit a cover letter no more than 200 words.