Analytics Engineer

Toronto /
Finance & Data /
Before you read any further: Our strength at Opencare relies on the diversity of perspective that we work hard to craft on our team. We are all solving the same set of problems from our own unique lenses, and this is fundamental to our success as a business. Experience means something different to each of us, and your unique combination of skills, passions, and experiences makes you a valuable asset to our team.

Don’t feel like you perfectly fit this role? Do us a favour and apply anyway! Take Eric for example. Eric did his undergraduate B.B.A with a specialization in Finance before joining a start-up in a growth marketing / analyst role. Bringing experience running offline marketing campaigns to Opencare, Eric has been focused on how to merge his operational experience with his data skills to provide strategic direction to our growth team. Working at the fast pace of Opencare’s Growth team, Eric has been able to level up the growth team with the insights that he drives, while continuing to develop his technical skills by taking on new projects and working with other analysts / data scientists on the team. Opencare would not be the same without him.

Opencare’s Vision

To enable people to have optimal health of mind and body, by ensuring they get the preventive care they need.

Opencare is re-designing the dentist visit with a focus on wellness. We live our most important life moments, from laughing and smiling to eating and talking, through our mouths. Yet for such an important body part, the thought of visiting the dentist instills fear and confusion in most people. To us, that doesn’t make any sense.

That’s why we’re rebuilding every moment of the dental experience; not only to be impactful during the visit, but life enriching afterward, too. If you never thought you’d say “Wow, I love my dentist!”, our goal is to get you there.

We believe that people reach their full potential at work when they are happy and healthy outside of work. You can learn more about our culture, as well as our professional and personal benefits here. You can also hear about it directly from our team here.

Our Data Team’s Vision
Our Data team is driven by providing meaningful insights across the business that will accelerate our growth. Our analysts and data scientists work on problems that dive deep into understanding how our customers behave and how we can serve them better because we know that when we can help someone find a great dentist and prioritize their mouth wellness it’s a win-win-win. This means that our team is focused on big problems like supply / demand balancing, multi touch attribution across multiple channels both online and offline, understanding the impact of complex communication flows, and digging deep into what makes a great patient for our dentists.

How will you help to get us there?
As we build out the next set of products to support dentists, we are integrating with multiple practice management systems (PMS) in order to provide smooth experiences for our dentists when it comes to insurance verification and billing. In order to do this, we need to build a custom data layer on top of all the different PMSs to enable our suite of products. As the Analytics Engineer, you’ll be responsible for diving deep into this data and working closely with the product, engineering, and data teams to understand how it will be used so that you can own how it should be structured. You’ll be the expert when it comes to this business critical data.

Your impact, six months into the role:

    • You will have a deep understanding of the different data structures coming out of each PMS system and how they compare. Because of this, you’ve created the ideal data model to normalize the data to enable the product features and analyses that are critical to the business.
    • Documenting what you’re doing is second nature, and that means that everyone around you from the engineering, product, and data teams knows how to interpret the data that’s available and relies on you to make sure it’s consistent.
    • By working with the product and engineering teams closely to understand and inform their roadmap, you’re staying one step ahead of the engineering team’s development, acting as their scout into the next projects and making sure that the data is understood and ready to use.
    • You’re partnering with the analysts and data scientists on the data team to understand and inform the key business questions about this data and taking those considerations into the data structures you're building.

Your impact, one year into the role:

    • Having mastered PMS systems and enabled the product and engineering teams to deliver on their key projects, you’ve turned your attention to the rest of the business and the rest of the work the data team is doing. You’ve had a chance to dig in to the tech stack on the data team (git, Fivetran, dbt, Snowflake, and Looker) and you’ve probably found some areas to bring your experience and make it more efficient. 
    • You’re a leader on the data team when it comes to writing clean code, structuring data and queries, and people would get tired of you talking about the importance of naming conventions if they didn’t agree with you so much.
    • You get really excited about self-serve analytics because you know that how the data has been structured and documented, you’ve enabled the whole business to move faster and focus on getting answers. 

What skills will you bring to the team from day one?

    • Super clear communication, especially on a remote team. You can look at a complex technical problem and you know how to break it down (in writing or over a Zoom call) to make sure everyone understands what’s going on.
    • You think in data structures and SQL queries. You got super excited when you learned about Snowflake’s QUALIFY clause because you realise how much time you’d save not writing CTEs to find the first / most recent event. (And you wouldn’t even think of writing a nested query - that wouldn’t be easily readable code!)
    • Whether or not you’ve read them, you probably agree with a lot of dbt’s best practices and coding conventions.
    • You’re passionate about fully understanding data in order to use it - you thrive when there’s nuance and fine details that need to be considered in a data model.
    • While you may not be writing production engineering code, you aren’t afraid to grab your own data from an API to play around with it. 
    • Our engineering team is mostly normalizing data through C# so while you wouldn’t be expected to write any yourself being able to read the code would help you dig deeper into how the data is currently being normalized.

What skills will you have the opportunity to develop?

    • Deepen your understanding of the entire product development process as you’ll be working closely with everyone across the business from start to finish (product managers, dental SMEs, engineers, data analysts and scientists). You’ll start with “what data is available and what can we do with it?” and keep going right past “how is this product performing with our customers?”
    • You’ll get to dig deep into the tools that most dentists work with - PMSs like Dentrix, Eaglesoft, Open Dental and ABELDent.
    • You’re probably familiar with at least a few of the tools we use already, but you can continue to dig in to git, dbt, Fivetran, Looker, Snowflake and postgres. You’ll also have the opportunity to learn with and from our engineering team - by joining the microservices study group, for example.
    • You might be curious about how the business uses data and want to dive deeper into modelling, creating KPIs, building predictive data models, or finding really compelling ways to tell a story with data - all things that you can learn alongside the other members of the data team.