Data Analyst

About us:

PurposeMed was founded in 2019 with the mission of improving access to complex care for underserved communities. We've grown quickly in our first few years, and now our exceptional team serves thousands of patients each month across our multiple verticals.

PurposeMed consists of three complex care business units: Freddie, Frida, and Foria, and partners with Affirming Care Pharmacy. Freddie is focused on improving sexual health through education, prevention, and treatment with a focus on the LGBTQ2S+ community—we're the #1 rated PrEP provider in North America, serving patients in both Canada and the USA Frida is changing the lives of patients with easier access to adult ADHD diagnosis, and fast and affordable treatment. Foria Clinic provides trans, non-binary, and gender-diverse Canadians with gender-affirming healthcare. Affirming Care Pharmacy is a specialty pharmacy with locations in Calgary, Alberta, and Mississauga, Ontario. This partnership provides our patients with an end-to-end healthcare experience, from treatment, to prescription delivery, to continuous affirming care.

We're proud to be ranked #2 on Deloitte's 2024 list of Canada's 50 fastest-growing tech companies and recognized as one of Canada's Most Admired Corporate Cultures for two consecutive years. Driven by a strong mission, our team is passionate about making healthcare accessible to those who need it most—and we make sure to have fun along the way

Permanent, full-time opportunity
Location: Remote (Canada)

Though we have an office based in Calgary, this is a remote position that is open to candidates across Canada. PurposeMed's office is located on the unceded and traditional territories of the peoples of the Treaty 7 region which includes the nations of the Siksika, the Piikani, the Kainai, the Îethka Stoney Nakoda which consists of the Chiniki, Bearspaw, and Good Stoney Bands, and people of the Tsuut'ina First Nation. The city of Calgary is also homeland to the historic Northwest Métis and to the Otipemisiwak Métis government, Métis Nation Battle River Territory, Nose Hill Métis District 5 and Elbow Métis District 6.

Who we hope to find:

We're looking for an analytically strong Data Analyst who loves building clean, reliable data foundations just as much as uncovering insights. In this role, you'll sit at the intersection of analytics engineering, data modeling, and stakeholder-facing analysis, helping us turn messy, multi-source data into well-designed tables, intuitive models, and clear insights that drive decisions.

This role is ideal for someone who enjoys partnering closely with stakeholders to understand their needs and translate those into purpose-built data tables and meaningful metrics. This role will focus on designing data structures, mapping data flows, and building scalable models, with a goal to grow into a full-stack analyst who can own everything from data modeling to dashboarding. You'll thrive here if you're comfortable with ambiguity, love creating structure where none exists, and enjoy working in a hybrid data modeling and analysis environment.

In this role, you'll make an impact by:

Owning analytics engineering fundamentals (50%)

• Building the data foundation by owning the architecture of key analytics tables including mapping inputs, designing transformations, planning model structures, and creating clean, intuitive datasets (e.g., patient journey funnels, provider supply/demand models, marketing attribution)
• Translating stakeholder questions into well-structured tables, transformations, and documentation
• Ensuring accuracy, reconciliation, and data quality across a complex set of sources in partnership with product and engineering teams

Building the tools and metrics that run the business (30%)

• Turning business needs into reliable data solutions by working directly with operations, growth, and product stakeholders to understand goals, clarify the "why," and delivering trusted data assets
• Defining KPIs and building dashboards and monitoring tools to help teams understand performance and unlock stronger patient outcomes
• Organizing and simplifying complex datasets so downstream users can self-serve
• Enabling experimentation and impact measurement of new business initiatives, from new service offerings to improvements in patient communications

Answering high-impact business questions (20%)

• Using SQL, BI tools, and statistical reasoning to explore data, run investigations, and communicate insights to non-technical teams
• Partnering with cross-functional teams (such as Growth, Clinical, Product, and Patient Care) to scope analyses, identify root causes of performance changes (e.g., decreases in retention, demand spikes, capacity bottlenecks), and recommend actionable insights

We need someone who has:

• 3–5+ years of experience in data analytics or analytics engineering
• Strong SQL skills and experience designing or maintaining ETL/ELT-style data models (dbt experience is an asset but not required)
• Understanding of data modeling concepts, table architecture, and how to structure data for downstream use
• Experience with BI tools (Looker, Tableau, Superset, Mode, or similar)
• A strong sense of ownership and ability to break down open-ended questions into structured, solvable problems
• Comfort talking to stakeholders and translating ambiguous needs into clear technical plans
• Strong analytical and problem-solving skills
• Excellent communication skills

It would also be great if you have:

• Proficiency in Python or R for advanced analytics and modelling
• Experience at a startup or in healthcare

Compensation:

• $90,000 - $105,000 CAD a year
• Earn stock options through our Equity Incentive Plan—connect your efforts to PurposeMed's growth as we work together to improve the lives of our patients across North America.
• The compensation listed above refers to a yearly base salary that may vary depending on a candidate's relevant qualifications, knowledge, competencies and work experience, and other factors including market conditions. Base pay is just one aspect of our total rewards at PurposeMed—see our other exciting benefits below (Please note that the benefits listed are specific to Canadian, full-time team members and may be adjusted based on your location or employment type).

Do you think you could be our next Data Analyst? We look forward to seeing your application

#LI-Remote

Why you should join us:

• Be part of a team of great people who don't take themselves too seriously. While we're serious about the problems we solve, we believe in having fun along the way.
• Make an impact, every single day. We're providing compassionate, affirming care to many people who have never received the proper support before.
• Be confident in bringing your whole self to work. Inclusivity is core to how we take care of our patients, our teammates, and ourselves. We create spaces that are safe and affirming.

What we're offering (based on full-time, permanent roles in Canada):

Work/life flexibility and time off:

• Work flexibly within a team that's remote friendly; we believe that work should fit around your life*
• 20 vacation days and a team that will remind you to use them
• Annual winter break closure

Care for your physical and mental health:

• Extended medical, dental, and vision care starting on your first day of work
• 8 wellness days
• $500 health and wellness spending account
• $2,000 mental health coverage with additional free online counseling through Inkblot Therapy and FeelingBetterNow mental health assessments
• $20,000 of lifetime coverage for gender-affirming care and procedures

Investment in your learning and growth:

• $500 learning fund to use towards courses and other professional development
• Our unique People Potential program, in which you'll partner with your manager to identify opportunities to grow and achieve your full potential

Family care:

• $3,400 lifetime coverage for fertility drugs
• Parental leave program for birthing and non-birthing parents–your choice of:
• • Short term: 4 weeks off to use flexibly in your first year of parenting
• Long-term: 13 weeks EI top-up

Eligible team members and their dependents** also receive no-cost access to PurposeMed's services:

• Freddie: PrEP assessment and follow-up appointments
• Frida: ADHD assessment
• Foria: Gender-affirming care services

If you are looking for a place that sparks your creativity, helps others, and will push you to be your best, then you'll love PurposeMed.

PurposeMed is committed to being an equal-opportunity employer, and we highly encourage those from excluded and marginalized communities to apply. This includes groups such as (but not limited to): Indigenous, Black, and racialized communities, trans and non-binary, LGBTQ2S+, disabled, and HIV-positive people. You don't have to check every single box above. If the job description gets you excited and you think you could contribute your expertise to our team—we hope you'll apply

• Most of our roles are performed virtually from home across Canada and the USA. Team members working onsite at Affirming Care pharmacies do need to be physically present.

**Permanent team members (employees) and their dependents are eligible, however, the person receiving the assessment must live in a province or state in which Freddie, Frida, or Foria operates, and be over the age of 18. Additional restrictions apply.

---