Senior Business Intelligence Analyst

About FaireFaire 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 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 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 roleWe'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 Faire. 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 Faire, including Accounting, Finance & Strategy, Engineering, and Data Infrastructure. It has a tremendous impact on Faire 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 scalableAct 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 changesCollaborate 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 organizationImplement 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 pipelinesLead 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 organizationDrive workflow automation and innovation across Finance, including identifying and implementing Gen-AI–enabled productivity solutions to modernize processes and increase team leverageQualificationsMust have:5+ years of work experience in Analytics Engineering, Business Intelligence, Data Analytics, or a comparable functionExpert in SQL, with a focus on data modeling, large-scale data processing, and tool development for analytics or financial use casesProven 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 toolingComfortable working with CI/CD practices and version control (Git) for production data pipelines, including command-line tooling for workflow automationStrong communication and collaboration skills for working with both technical and business partnersNice to have:Familiarity with Faire's data stack & systems, and experience with marketplace or transactional business modelsExperience with monitoring and alerting systems for data pipelinesFinance or accounting experience — or experience supporting Finance/Accounting teams and building the pipelines behind financial reportingExperience supporting SOX compliance requirements (e.g., controls, audit trails, change management) in a data or finance systems contextBA/BS degree, ideally in computer science, math, or another quantitative fieldPassionate about the potential of Generative AI to improve team leverage and productivitySalary RangeSan Francisco and New York City: the pay range for this role is $174,500 to $240,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.Hybrid Faire 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 FaireMove 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 Faire employee has equal access to opportunities, growth, and success.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 (PrivacyFor information about the type of personal data Faire collects from applicants, as well as your choices regarding the data collected about you, please visit Faire’s Privacy Notice (