Senior Analytics Engineer 12 Month Contract - Coconut Software

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.

[Note: On Call] We strive to provide service excellence in all areas, as such, 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.

Data @ Coconut:

• We are currently in an exciting phase of growth, migrating our entire data estate from legacy Postgres and Redshift environments to a modern Databricks Lakehouse.
• Our stack is built for scale: Databricks for storage and compute, dbt for our transformation and semantic layer, and Looker (LookML) for business intelligence.
• We don't follow rigid Scrum, but we do work in an agile, iterative way, and try to continuously improve and implement what works for us.
• We work in a blameless culture and have a continuous improvement mindset.

YOU’RE FIRED UP ABOUT:

Team Elevation

• 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.

Technical Delivery & Ownership

• 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.

Data Architectu