Senior Platform Analytics Engineer

Rozgoo; Kitchener; On-site; CAD 90,000 - 130,000; Full time

Job summary

Faire is building a data-driven analytics platform to accelerate insights across the business. We’re seeking an experienced analytics engineer to partner with stakeholders and deliver scalable data models and pipelines.

You will work with SQL, Python, Airflow, dbt, and Snowflake to improve data quality, governance, and availability, enabling teams across Strategy, Finance, and product to make data-informed decisions in a fast-growing marketplace.

Qualifications

• Strong SQL and Python skills with data modeling experience.
• Experience building platform datasets and enabling business functions.
• Analytics engineering focus on data modeling and large-scale processing.
• Knowledge of Airflow, dbt and Snowflake is valuable.
• Bachelor's degree required.

Responsibilities

• Partner with internal customers to develop analytics capabilities.
• Improve development patterns and guide foundational datasets evolution.
• Lead scalable data models and pipelines across key domains.
• Tackle data quality, integrity, and reliability for insights.
• Plan and execute tech projects at scale; contribute to analytics architecture.
• Engage in planning, prioritization, and mentorship.

Skills

SQL

Python

Data modeling

Data pipelines

Airflow

dbt

Snowflake

Communication

Big data

Education

Bachelor's degree

Tools

Airflow

dbt

Snowflake

ETL

Data warehousing

Job description

About Faire

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