Product Analytics Engineer
KOHO
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇨🇦 Canada
Visit company websiteSalary
💰 CA$110,000 - CA$140,000 per year
Job Level
Mid-LevelSenior
Tech Stack
Amazon RedshiftCloudSQL
About the role
- Lead complex product pipeline builds: Design and develop scalable data pipelines supporting cross-domain product launches in Payments, Credit, and Subscriptions, from scoping through delivery
- Collaborate cross-functionally: Partner with Product Analysts and Product Managers to define data requirements, while analysts continue owning pipelines alongside you
- Build product reporting infrastructure: Create reliable, performant marts and models that power product dashboards and self-service analytics
- Design scalable data models: Apply modeling frameworks (one big table, entity tables, Kimball) tailored to product analytics use cases
- Optimize and monitor: Maintain pipeline health, optimize query performance, and implement data quality monitoring
- Enable the team: Document solutions, establish best practices, and help upskill Product Analysts on pipeline development
- Integrate cross-functional data: Work across domain boundaries to unify product data into cohesive reporting structures
Requirements
- 3+ years of experience in analytics engineering, data engineering, or similar data roles
- Advanced DBT expertise: Comfortable with various materializations, such as incremental, table, view, etc. Familiar with snapshots, variables, macros, and jinja.
- Strong SQL skills with a focus on query optimization and performance
- Experience with modern data stack: DBT Core and/or DBT Cloud, Git. A plus if experience with Redshift.
- Collaborative mindset: You thrive working alongside analysts, PMs, and engineers to translate business requirements into technical solutions
- Strong communicator: You adapt communication to different audiences and connect technical work to product outcomes
- Proactive problem-solver: You identify opportunities for improvement and take initiative without waiting to be asked
- AI-curious: Experience or strong interest in leveraging AI tools for development workflows
Benefits
- Competitive compensation & equity
- Generous vacation + Wellness days + Flex Days + holiday closure
- Remote-first environment + coworking support + yearly all hands retreat
- Access to coaching & growth programs
- Parental top-up & leave policies
- Comprehensive health benefits
- Power-up budgets for books, home office setup, phone & internet, AI tools, and professional development
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data pipelinesdata modelingquery optimizationDBTSQLdata quality monitoringreporting infrastructuredata martsanalytics engineeringdata engineering
Soft skills
collaborative mindsetstrong communicatorproactive problem-solver