Senior Platform Analytics Engineer at Faire

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: Our Engineering organization owns the software that makes our marketplace work. The Platform group empowers teams across Faire: Product Engineering, Data Science, Product Management, Strategy, Analytics, Finance, etc. Enabling these functions to do their best work without concern about underlying infrastructure. We enable product engineering teams to build and operate software with unmatched speed and quality. We care about good engineering practices, excellent developer experience, security, testability, ease of maintenance, and scaling to serve millions of users. We value best practices to achieve excellent availability and performance. The Analytics Platform team builds capabilities to accelerate data-driven analytics, improve productivity and accuracy at Faire. Its mandate is to reduce time from data to insights. The team focuses on the following areas and capabilities: • Data warehousing optimization, including performance, efficiency, cost • Capabilities for data quality, metadata enrichment, lineage, privacy • Tooling and capabilities to accelerate productivity of analytics subject matter experts; automation of analytics functions • Development patterns and practices for foundational assets • Elements of data security, privacy, and governance The team also owns relationships with select infrastructure vendors. We’re looking for: • An experienced analytics engineer to work alongside our highly talented team, develop and deliver technical projects, and engage with other teams in the organization. What you’ll do: • Partner with key internal customers of the analytics function across business verticals, Strategy, Finance, others to develop capabilities based on their needs • Improve development patterns and guide the broader analytics function on evolution of foundational datasets • Lead technical execution in building scalable data models and pipelines for key domains, defining architecture, feature requirements, roadmaps • Tackle challenges of data quality, integrity, relevance, and other analytics related concerns, for accurate and reliable insights • Plan and execute on technology projects that scale with our growth; contribute to our architecture with a focus on analytics • Engage with team planning and prioritization, balancing urgent and near-term needs with long-term goals. • Provide technical guidance and mentorship on difficult open-ended problems. Qualifications: • Strong SQL and Python skills and demonstrated competencies in designing well-architected data models and optimizing query performance • Experience building and evolving platform / foundational datasets and enabling other business functions that consume them • Analytics engineering experience with a focus on data modeling, large-scale data processing, and tool development for analytics or data science use cases • Experience with Airflow, dbt or similar analytics workflow tools; Snowflake experience especially valuable • Knowledge of data warehousing concepts, ETLs, big data technologies, and analytics platforms • Data warehousing experience at Petabyte scale • Understanding of performance, capacity, cost trade-offs in data processing systems • Strong communication skills • A bachelor's degree in Computer Science / Engineering or equivalent industry experience Technologies we use and teach: • AWS • Snowflake • Airflow • Spark • Python • Kotlin Salary range: Canada: the pay range for this role is $156,000 - $214,500 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 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 ([Upgrade to PRO to see link] Privacy For 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 ([Upgrade to PRO to see link]