Senior Business Intelligence Analyst

Faire; San Francisco (CA); Hybrid; USD 170,000 - 234,000; Full time

Job summary

An innovative company is seeking a Senior Business Intelligence Analyst to enhance its data capabilities. In this role, you will build and maintain systems that drive financial insights and support decision-making across various departments. You will collaborate with teams to automate key accounting procedures and improve access to critical business data. This position offers the chance to shape the future of data strategy in a rapidly growing organization dedicated to empowering small businesses. Join a passionate team that values entrepreneurship and leverages technology to create impactful solutions.

Benefits

Equity options

Flexible remote work

Health benefits

Professional development opportunities

Qualifications

• 5+ years in Business Intelligence or Data Analytics.
• Expert in SQL and data modeling for financial use cases.
• Experience with ETL processes and data warehousing.

Responsibilities

• Design and manage ETL flows for key business metrics.
• Collaborate with teams to enable data-driven decisions.
• Lead initiatives for data strategy and workflow automation.

Skills

Business Intelligence

Data Analytics

SQL

Data Modeling

Data Warehousing

ETL Processes

Analytical Skills

Education

BA/BS degree in Computer Science or related field

Tools

Airflow

Docker

dbt

Snowflake

BigQuery

Redshift

Tableau

Looker

Job description

About Faire

Faire is an online wholesale marketplace built on the belief that the future is local — independent retailers around the globe are doing more revenue than Walmart and Amazon combined, but individually, they are small compared to these massive entities. At Faire, 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 that small businesses everywhere can compete with these big box and e-commerce giants.

By supporting the growth of independent businesses, Faire is driving positive economic impact in local communities, globally. 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 are looking for an experienced Senior Business Intelligence Analyst to scale a critically important function responsible for building and maintaining systems, processes and services that enable us to understand financial performance and unlock key business insights at Faire. The ideal candidate for this role will ensure key accounting procedures are automated in ways that are accurate, efficient, easy-to-understand, and scalable. This role will sit in the Finance department and collaborate with team members from a breadth of functional groups across Faire, including Accounting, Finance & Strategy, Engineering and Data Infrastructure. This role will have a tremendous impact on the ability for Faire employees to use data effectively in order to report numbers externally and make impactful decisions internally. As an early member of a burgeoning team, you will have the opportunity to 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, create, and manage complex ETL flows that aggregate and synthesize key business performance metrics and financial reporting, ensuring efficient, accurate, and scalable data models using best practices.
• Act as a trusted analytical partner to the Accounting and Finance teams providing technical expertise, gathering requirements from product and operational teams, and enabling data-driven decision-making and accountability by ensuring core ledgers accurately reflect business changes.
• Collaborate closely with Engineering, Data Infrastructure, and other stakeholders as a key translator and process improver, gathering requirements and delivering impactful data solutions that ensure alignment and efficiency across the organization.
• Lead initiatives to drive data strategy, roadmap planning, and prioritization, ensuring alignment with business objectives.
• Act as a thought leader to expand the team’s influence and impact throughout the Finance team and the broader organization.
• Unlock workflow automation with use of the latest capabilities made possible by Generative AI.

Qualifications:

Must have:

• 5+ years of work experience in Business Intelligence, Analytics Engineering, Data Analytics, or comparable function.
• Expert in SQL with focus on data modeling, large-scale data processing, and tool development for analytics or Financial use cases.
• Experience and knowledge of data warehousing concepts, ETLs, big data technologies, and analytics platforms.
• Experience with analytics workflow tools (examples: Airflow, Docker, dbt), data warehousing and storage (examples: Snowflake, BigQuery, Redshift, S3), and data visualization tools (examples: Mode, Tableau, Looker).

Nice to have:

• Experience with Python, R or other programming languages.
• BA/BS degree, ideally in computer science, math or another quantitative field.
• Familiarity with version control using Git and proficiency in command-line tools for workflow automation and data manipulation.

Salary Range

California: the pay range for this role is $170,000 - $234,000 per 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.

This role will be in-office on a hybrid schedule - Faire employees will be expected to go into the office 2 days per week on Tuesdays and Thursdays, effective the week of January 13, 2025. Additionally, in-office roles will have the flexibility to work remotely up to 4 weeks per year.

Why you’ll love working at Faire

• We are entrepreneurs: Faire is being built for entrepreneurs, by entrepreneurs. We believe entrepreneurship is a calling and our mission is to empower entrepreneurs to chase their dreams. Every member of our team is taking part in the founding process.
• We are using technology and data to level the playing field: We are leveraging the power of product innovation and machine learning to connect brands and boutiques from all over the world, building a growing community of more than 350,000 small business owners.
• We build products our customers love: Everything we do is ultimately in the service of helping our customers grow their business because our goal is to grow the pie - not steal a piece from it. Running a small business is hard work, but using Faire makes it easy.
• We are curious and resourceful: Inquisitive by default, we explore every possibility, test every assumption, and develop creative solutions to the challenges at hand. We lead with curiosity and data in our decision making, and reason from a first principles mentality.

Faire 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 Faire and our customers, you can read more on our blog.

Faire 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.

Faire is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. Accommodations are available throughout the recruitment process and applicants with a disability may request to be accommodated throughout the recruitment process. We will work with all applicants to accommodate their individual accessibility needs. To request reasonable accommodation, please fill out our Accommodation Request Form.