Senior Business Intelligence Analyst

Faire; Carlsbad (CA); Hybrid; USD 175,000 - 240,000; Full time

Benefits offered by this job

Equity

Benefits

Hybrid work

Job summary

the company is seeking a Senior Finance Analytics Engineer to scale a critical analytics function. You will design and maintain ETL/ELT pipelines, models, and data flows to understand financial performance and deliver insights to multiple teams.

The role collaborates with Accounting, Finance, Engineering, and Data Infrastructure to automate processes and improve data quality. You will drive data strategy, implement monitoring and Gen-AI enabled productivity, and help the finance organization

Qualifications

• 5+ years of work experience in Analytics Engineering, BI, Data Analytics, or a comparable function.
• Expert in SQL, with data modeling and large-scale data processing and tool development for analytics or financial use cases.
• Proven ability to design and maintain production-grade ETL/ELT workflows, including Airflow, Docker, dbt, data warehousing, and visualization tools.
• Experience with analytics tools (Mode, Tableau, Looker) and data visualization.
• Proficient in Python for pipeline development and tooling.
• Familiar with CI/CD and Git for production data pipelines.

Responsibilities

• Scope, design, build, and maintain complex ETL/ELT pipelines for financial metrics and reporting.
• Partner with Accounting and Finance to ensure ledgers reflect business changes accurately.
• Collaborate with Engineering and Data Infra to improve data integrations and ingestion patterns.
• Implement monitoring, testing, and CI/CD for data workflows to ensure reliability.
• Lead data strategy, roadmap planning, and prioritization across Finance; drive automation incl. Gen-AI solutions.
• Support SOX compliance in data/finance systems and maintain audit trails.

Skills

SQL

Python

Airflow

dbt

Data modeling

Data warehousing

Looker/Tableau

CI/CD

Education

BA/BS in CS, math, or quantitative field

Tools

Fivetran

S3 pipelines

Snowflake

BigQuery

Redshift

dbt

Job description

About the company

the company is a technology wholesale platform built on the belief that the future is local. Independent retailers around the globe collectively represent a multi-hundred-billion-dollar wholesale market that has historically been fragmented and offline. At the company, we're using the power of tech, data, and machine learning to connect this thriving community of entrepreneurs across the globe. Picture your favorite boutique in town — we help them discover the best products from around the world to sell in their stores. With the right tools and insights, we believe that we can level the playing field so businesses can grow and local communities can thrive.

We’re looking for smart, resourceful and passionate people to join us as we power the shop local movement. If you believe in community, come join ours.

About this role

We're looking for an experienced Senior Finance Analytics Engineer to scale a critically important function responsible for building and maintaining the systems, pipelines, and data models that let us understand financial performance and unlock key business insights at the company. The ideal candidate will ensure key accounting procedures are automated in ways that are accurate, efficient, easy to understand, and scalable. This role sits in the Finance department and collaborates with team members from a breadth of functional groups across the company, including Accounting, Finance & Strategy, Engineering, and Data Infrastructure. It has a tremendous impact on the company employees' ability to use data effectively — both to report numbers externally and to make impactful decisions internally. As a senior member of a growing team, you'll help write the roadmap for how we improve access to business-critical data and unlock automation that amplifies the impact of a variety of functions.

What you’ll do

• Scope, design, build, and maintain complex ETL/ELT pipelines that aggregate and synthesize key business performance metrics and financial reporting, using engineering best practices to keep data models efficient, accurate, and scalable

• Act as a trusted analytical and technical partner to the Accounting and Finance teams — gathering requirements, providing technical expertise, and enabling data-driven decision-making by ensuring core ledgers accurately reflect business changes

• Collaborate closely with Engineering and Data Infrastructure to manage and improve data integrations (e.g., Fivetran connectors, S3 pipelines, and other ingestion patterns) and ensure alignment and efficiency across the organization

• Implement and maintain monitoring, alerting, and testing for data workflows to ensure high data quality and reliability, and champion CI/CD and other engineering best practices within the team's pipelines

• Lead initiatives to drive data strategy, roadmap planning, and prioritization, ensuring alignment with business objectives, and act as a thought leader who expands the team's influence and impact throughout Finance and the broader organization

• Drive workflow automation and innovation across Finance, including identifying and implementing Gen-AI–enabled productivity solutions to modernize processes and increase team leverage

QualificationsMust have:

• 5+ years of work experience in Analytics Engineering, Business Intelligence, Data Analytics, or a comparable function

• Expert in SQL, with a focus on data modeling, large-scale data processing, and tool development for analytics or financial use cases

• Proven ability to design and maintain production-grade ETL/ELT workflows, including experience with analytics workflow tools (e.g., Airflow, Docker, dbt), data warehousing (e.g., Snowflake, BigQuery, Redshift, S3), and data visualization tools (e.g., Mode, Tableau, Looker)

• Working proficiency in Python (or a similar language) for pipeline development, automation, and tooling

• Comfortable working with CI/CD practices and version control (Git) for production data pipelines, including command-line tooling for workflow automation

• Strong communication and collaboration skills for working with both technical and business partners

Nice to have:

• Familiarity with the company's data stack & systems, and experience with marketplace or transactional business models

• Experience with monitoring and alerting systems for data pipelines

• Finance or accounting experience — or experience supporting Finance/Accounting teams and building the pipelines behind financial reporting

• Experience supporting SOX compliance requirements (e.g., controls, audit trails, change management) in a data or finance systems context

• BA/BS degree, ideally in computer science, math, or another quantitative field

• Passionate about the potential of Generative AI to improve team leverage and productivity

Salary Range

San Francisco and New York City: the pay range for this role is $174,500to $240,000per year.

This role will also be eligible for equity and benefits. Actual base pay will be determined based on permissible factors such as transferable skills, work experience, market demands, and primary work location. The base pay range provided is subject to change and may be modified in the future.

*Hybrid the company employees currently go into the office 3 days per week on Tuesdays, Thursdays, and a third flex day of their choosing (Monday, Wednesday, or Friday).* Additionally, hybrid in-office roles will have the flexibility to work remotely up to 4 weeks per year. Specific Workplace and Information Technology positions may require onsite attendance 5 days per week as will be indicated in the job posting.*

Why you’ll love working at the company

• Move fast: You'll own meaningful problems that serve customers around the globe with the agency to move fast and see your results clearly.

• Equipped to scale: We invest in what matters, including the latest enterprise AI tools, to help you work smarter and get more out of every day.

• Best in class: Our team is full of sharp, kind, and generous colleagues who care about their craft and about helping you grow in yours.

• Real rewards. Competitive pay, equity, and comprehensive benefits designed to support your life inside and outside of work.

• Belonging: We're intentional about building an environment where every the company employee has equal access to opportunities, growth, and success.

the company was founded in 2017 by a team of early product and engineering leads from Square. We’re backed by some of the top investors in retail and tech including: Y Combinator, Lightspeed Venture Partners, Forerunner Ventures, Khosla Ventures, Sequoia Capital, Founders Fund, and DST Global. We have headquarters in San Francisco and Kitchener-Waterloo, and a global employee presence across offices in Toronto, London, and New York. To learn more about the company and our customers, you can read more on our blog.

the company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, sexual orientation, gender identity or gender expression.

the company is committed to providing access, equal opportunity and rea