Senior Analytics Engineer (12 Month Contract)

Coconut Software

4h•Remote

About The Position

At Coconut Software, we’re not just building data pipelines, we’re architecting the source of truth that powers the future of financial connections. As a Senior Analytics Engineer, you will be the glue between our technical data infrastructure and our business outcomes. While your primary focus is building a world-class modeling layer in dbt and Looker, you are equally comfortable putting on your Data Analyst hat to help stakeholders uncover the "why" behind the numbers. Your role extends beyond technical modeling; you will be a mentor, a guide, and an advocate for data best practices. You’ll help foster an inclusive, psychologically safe environment where data professionals can do their best work. By proactively improving our data modeling standards and strengthening cross-functional collaboration, you will ensure our team delivers high-quality, actionable insights that meet both user needs and business goals. Roles in our Engineering department are expected to contribute to our collaborative on-call rotation, working with your team to support our systems and ensuring application availability/reliability. Each team will have their own rotation schedule. The company is currently in an exciting phase of growth, migrating its entire data estate from legacy Postgres and Redshift environments to a modern Databricks Lakehouse. The stack is built for scale: Databricks for storage and compute, dbt for transformation and semantic layer, and Looker (LookML) for business intelligence. The team works in an agile, iterative way, and tries to continuously improve and implement what works for them, operating in a blameless culture with a continuous improvement mindset.

Requirements

5+ years of applied experience in an Analytics Engineering or Data role with a solid track record of technical leadership in B2B/SaaS environments.
Extensive experience architecting dbt projects and managing complex Looker environments.
Solid experience using Looker (or similar BI tools like Tableau or Power BI) to build dashboards and solve complex data requests.
Strong architectural understanding of modern data stacks, with proven experience in Databricks.
Expertise in writing, improving, and troubleshooting complex SQL queries.
The ability to successfully collaborate cross-functionally, gathering requirements and delivering results to different teams and departments.
Excellent interpersonal and communication skills; you can relay complex technical ideas to anyone in the building.

Nice To Haves

A passion for learning and exploring how AI/LLMs (like Google Gemini) can be integrated into the data lifecycle.

Responsibilities

Mentor and support data analysts, data engineers and developers, fostering a collaborative and psychologically safe environment.
Set high standards for technical excellence in SQL, dbt modeling, and LookML architecture.
Collaborate with other analytics engineers on the migration of legacy logic from Redshift/Postgres into performant Databricks silver and gold layers.
Independently implement complex data models in dbt, demonstrating expertise in modularity, testing, and performance optimization on Spark.
Own the LookML layer, ensuring our explores and dashboards are performant, intuitive, and accurate.
Act as a "Hybrid Analyst," comfortably balancing long-term engineering projects with ad-hoc requests to support the business.
Translate stakeholder questions into Looker-based reports and visualizations, ensuring the business has the right insights at the right time.
Lead technical data planning through discovery, design, and release, ensuring clear documentation for data catalogs and version tracking.
Identify opportunities for "data debt" reduction and architectural improvements in our Lakehouse and semantic layers.
Proactively address system characteristics like latency and throughput, ensuring our data pipelines are optimized for cost and speed.
Act as a subject matter expert in your data domain, contributing to business strategy to ensure we are measuring what matters.
Provide engineering perspectives on the product roadmap, clearly communicating data feasibility and reporting limitations.
Contribute to our collaborative on-call rotation, working with your team to support our systems and ensuring application availability/reliability.

Benefits

Find your flow with Cabana Days. We offer flex-time and flex-days so you can recharge and be your best self.
Ability to do your job in a supported, but flexible environment
Supported professional development, learning, & career opportunities - be supported in your growth journey!
Regular 1:1 coaching with your leader and regular connection to a passionate executive team
Work in a team big enough for growth but lean enough to make a real impact
A full range of benefits to keep you happy & healthy
Competitive Salaries - we pay fairly based on experience and expertise, not your ability to negotiate!
Health & Dental Benefits, Virtual Care, & Disability top up - all starting from day 1!
Virtual mental health and EAP platform
WealthSimple GRSP & Matching
Annual Wellness Benefit ($1000 per year)
Opportunity to work remote - anywhere in Canada!
Employee Options - everyone shares in our success!
Internet Subsidy on each paycheck
Tiki Bucks Incentive Program - everyone is entitled to earn bonuses!