Data & Analytics Engineer

Data & Analytics Engineer

Posted Date Feb 21, 2026 Employment Type Full-time Experience Level Mid-Senior level Location Canada Annual Salary 110,000 CAD Category ** Data Science ** Company **format **

Title: **Data & Analytics Engineer

****Reports to: VP, Engineering

****Location: Remote (CA)

****About Zenfolio Inc.

** Zenfolio Inc. offers multiple e-commerce solutions for photographers to showcase their work, manage their business, and build their brand. For almost two decades, Zenfolio Inc. has proudly served photographers around the globe.

With team members hailing from all over the world with diverse backgrounds, personalities, and talents, Zenfolio Inc. prides itself on offering a truly unique work environment. You’ll be supported by bright and talented individuals who come together to work and play in a fun, collaborative, supportive and creative work environment. If you love photography and helping businesses succeed, then we’d love to hear from you!

**About The Role

** The Data Engineer will be a key leader on the Data & Analytics team, responsible for our department's data stack, pipelines, and business intelligence platforms. You will design, build, and maintain DBT-based data models and our core data stack (DBT, Snowflake, Tableau), ensuring our data infrastructure and tools empower business stakeholders with reliable reporting and analytics capabilities. Collaborating with the Data & Analytics team and wider business stakeholders, you will define requirements, analyze data, and deploy robust data pipelines to drive informed decision-making across all Zenfolio brands.

**Duties And Responsibilities

** As a Data and Analytics Engineer, you will:

• Craft a long-term strategic vision for how we access, model, analyze, and visualize valuable business data and information with minimal oversight
• Architect and lead development of data warehousing, data modeling and visualization, and customizable reporting strategies, architectures, and roadmaps
• Leverage and implement AI tools and agents to automate routine tasks, reduce operational burden, enable new solutions and opportunities, and drive productivity gains
• Apply your knowledge of SQL, data modeling/design, programming, statistics, and mathematics to recognize patterns and anomalies and derive actionable insights
• Regularly communicate your findings and recommendations to the broader team via data visualization and storytelling
• Work closely with Engineering, Product, UX and executive stakeholders to support critical initiatives via data analysis
• Define and measure key performance indicators across various departments and strategic initiatives
• Formulate our long-term data and analytics strategy with respect to data warehousing, data visualization, and customizable reporting
• Collaborate with engineering team members as needed on more involved, custom development tasks
• Directly plan, implement, and test application instrumentation code as part of production web and mobile applications
• Rapidly analyze and comprehend complex, unfamiliar code, leveraging AI tools for accelerated understanding and facilitation of effective solutions
• Articulate findings and insights effectively via written and verbal communication, including the ability to engage stakeholders to understand their data and reporting needs and guide them towards optimal solutions Interested in remote work opportunities in Data Science? Discover Data Science Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.
• Mentor and support more junior team members in their professional development

**Qualifications

** To excel in this role, you will bring:

• 4-8+ years of experience working with large data stacks and data sets across multiple sources, ideally in a SaaS-based environment
• Deep understanding of relational database concepts, such as normalization and data integrity
• Expert-level experience writing complex, performant SQL queries, especially within DBT models
• Deep knowledge of multi-stage ETL and data ingestion pipelines, ideally in terms of SaaS-based application instrumentation
• Demonstrated habit of incorporating AI assistants into everyday data engineering work (writing queries, generating tests, drafting documentation, troubleshooting pipelines, etc)
• Experience translating complex data into business insights
• Ability to survey and assess third-party tools for evaluating potential solutions and additions to the data stack.
• Experience with cloud databases and data warehouses (ideally using Snowflake, Amazon Aurora, etc.)
• Experience with programming languages and tools commonly used with data and analytics (especially Python)
• Experience with data cleansing and validation
• Proven ability to work independently to deliver on projects with minimal oversight
• Ability to self-organize, manage your time, and deliver on your commitments
• Experience working with ETL, Reverse ETL, and BI tools such as Amplitude, Census, Segment, Fivetran, Stitch, etc.

**Preferred Skills

**

• Experience with analytics platforms and other business intelligence tools a plus (e.g. Tableau, Power BI, Mode etc.) Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.
• Experience with data warehousing ETL processes and supporting tools a plus (e.g. AWS Glue, FiveTran etc.)
• Experience with SaaS metrics and reporting a plus (e.g. customer churn, lifetime value, etc.)
• Experience using AI tools across a range of tasks beyond just code generation (data profiling, anomaly investigation, stakeholder communication, pipeline debugging, etc.)

BONUS POINTS: any good examples of your work that you are particularly proud of and are able to share

**Compensation

** The salary range for this position is CAD 110,000 to CAD 150,000 (median to high). Total compensation includes salary, annual bonus and comprehensive benefits coverage from day 1 of employment.

**Why you should work with us

** We are built on the values we believe in—ownership and collaboration being key to driving the way we work. We move fast, solve important problems and continuously aim to do and be better. At Zenfolio, the work of every team member matters—whether it’s for our members, company, team, or culture—we all strive to make an impact with ideas that are better, smarter, and more innovative. Our team members make important decisions every day that have direct and tangible impacts on our users.

As a remote-only growing team (100+), we care deeply about fostering a company that our team is extremely proud to work for—a healthy organizational culture, competitive salaries, flexible work arrangements, great health benefits and other perks.

We have an amazing team that will be eager to help you succeed in your role and grow in your career.

**What To Expect

** If this sounds like the right place for you, then get in touch! We can’t wait to meet you. Your resume will be reviewed by a human as soon as possible. Selected applicants will be invited for an initial screening with someone from our team, where we will converse about the role and the organization. We usually have 3 rounds of interviews - One 30-minute screening video call, followed by two 60-minute video calls.

**Estimated Timelines For Interviews

** Round 1: Between 1-3 weeks from date of application

Round 2: Between 3-6 weeks from date of application

Round 3: Between 6-9 weeks from date of application

Note: These are estimated timelines. We may be able to complete the rounds faster, or they may get delayed due to unavoidable circumstances.

_Studies have shown that women and people of colour are less likely to apply to jobs unless they meet every single qualification. At Zenfolio Inc., we are dedicated to building a diverse, inclusive and authentic workspace, so if you are excited about this role but your experience aligns differently with some qualifications in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles across Zenfolio.

Zenfolio Inc. is proud to be an equal opportunity employer and is committed to building a work environment that is both diverse and inclusive. All qualified applicants are highly encouraged to apply and will receive consideration for employment regardless of race, religion, gender, gender identity or expression, sexual orientation, ethnicity, creed, disability, or age. We are committed to working with applicants requesting accommodation at any stage of the hiring process.

_Please note that while all our roles are remote, we are hiring for this role only in Canada and will not be sponsoring visas for this position. You must be located in and eligible to work in Canada to be considered for the role.

Показать контакты