We believe small businesses are at the heart of our communities, and championing them is worth fighting for. We empower small business owners to manage their finances fearlessly, by offering the simplest, all-in-one financial management solution they can't live without.
About the Role:
The Senior Analytics Engineer is a builder and curator of the data warehouse at Wave, bridging concepts from the business domain into data models that enable Analysts and other data consumers to surface insights and drive decisions. The role demands a command of the Analytics workflow, a strong dimensional modelling acumen in dbt, and excellent communication skills. Analytics Engineers collaborate widely within the Data & AI team and across Wave’s business units (e.g. Product, Risk, Finance) to design and build data models that strengthen data-driven decision-making in service of our customers and our business.
Here’s How You Make an Impact:
- You are obsessed with building a strong analytics workflow. You will develop efficient, reusable and reliable data models that others depend on to create business and customer value.
- You are an expert in your craft with a depth of knowledge and experience using dbt to transform data from staging to reusable dimensional marts. You will work within dbt Cloud and with Amazon Redshift.
- You will partner with analysts and other stakeholders to understand business needs, document source-to-target mappings, design and document data models, and ensure the output is accepted by stakeholders.
- You will implement validation rules and conduct audits of data models, enforcing governance standards that promote the proper use of data assets. You’ll help to develop data quality tests and documentation to support ongoing data modeling work.
- You’ll help to guide and mentor others, sharing your expertise in data modeling with the goal of improving data literacy across Wave.
- You’ll design and implement processes and tools that drive data-driven decisions across Wave. Your work will mean something and have an impact for the company, empowering teams to make smarter business decisions.
These will help you succeed:
- At least 3 years of experience in Analytics Engineering (or Business Intelligence), particularly data modeling, transformation and data engineering. This is important because this is what you’ll be doing most of the time, and we need someone experienced to do it.
- Must be proficient in dbt. dbt is our transformation tool for SQL models.
- At least 2 years of experience working with cloud infrastructure, including container development with Kubernetes, GitOps or other infrastructure automation. We work on AWS.
- Experience using dbt to implement an automated data transformation layer in a modern data warehouse, (ideally using the Data Vault 2.0 methodology) running on Redshift.
- Comfortable coding in Python. You’re able to read, update, and maintain code that powers our data pipelines.
You Thrive Here By Possessing the Following:
- At least 5 years of experience in Analytics Engineering, particularly in data modelling and transformation.
- Strong experience designing and implementing scalable and efficient dimensional data models.
- Proficient in dbt. This includes developing in dbt, as well as dbt project structuring, developing and testing models, leveraging popular packages, and adhering to best practices.
- Experience writing SQL optimized for large and complex datasets. Comfortable coding in Python. You’re able to read, update, and maintain code that powers the AWS Glue jobs in our data lake and pipelines.
- Experience with BI tools, preferably Looker. Experience developing a semantic layer.
- Comfortable using version control systems like Git and CI/CD workflows.
- Practical knowledge of data warehouse design frameworks (e.g., Kimball, data mesh) and best practices, with the ability to coach team members on these concepts.
- You are all about collaboration. You’ll be working with different teams across Wave who have different perspectives and data needs.
- You are a stellar communicator. This means you know how to translate technical terms into non-technical language which your grandma could understand.
- You’re self-motivated and have the ability to work autonomously. We count on you to get your work done and produce high-quality work.
- You value personal and team development. You enjoy helping your team to identify the most important aspects of engineering and best practices.
At Wave, you’re treated like the incredible human being you are.
Work From Where You Work Best: We will always have a welcoming, energizing, and world-class office (in Toronto) with a space for you. Or, if you’re more comfortable working from home, the choice is yours.
We Care About Future You: You will stretch yourself and you will grow at Wave. You will also be supported on this journey with diverse learning experiences, educational allowances, mentorship, and so much more.
We Support the Full You: We make a serious investment in your health & wellness. When we think about benefits we think about body, mind, & soul and we take this stuff very seriously.
We Take Care of the Fundamentals: Fair compensation, all the office perks you’d want, and the various goodies you’d expect from a growing tech company. This is the obvious stuff, but we don’t want you to think we forgot!
We believe that a diverse and inclusive culture creates the best workplace. We embrace our differences, value individuality, and the broad spectrum of every Waver's skills and abilities. We challenge each other from a place of respect and pursuit of continuous growth. We trust each other and encourage everyone to bring their authentic selves to work, everyday. As Wavers, our voices matter, our opinions are met with an open mind. The best ideas win, no matter whose they are. Contributing to an inclusive culture is a part of all of our job descriptions.
We’ve been continuously recognized as one of Canada's Top Ten Most Admired Corporate Cultures and one of Canada’s Great Places to Work in categories including Technology, Millennials, Mental Health, Inclusion and Women.
Are you ready to be a Waver? Join us!
