Data Analyst

Job Description

<p><h3>About PurposeMed</h3>
<p>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.</p>
<p>PurposeMed consists of three complex care business units: Freddie, Frida, and Foria, and partners with Affir­ming 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, affordable treatment. Foria Clinic provides trans, non‑binary, and gender‑diverse Canadians with gender‑affirming healthcare. Affir­ming 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.</p>
<p>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!</p>
<p><b>Location</b>: Remote (Canada)<br/><b>Job type</b>: Permanent, full‑time opportunity</p>
<p><b>Application note</b>: Though we have an office based in Calgary, this is a remote position that is open to candidates across Canada.</p>
<h3>Role Overview</h3>
<p>We are 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.</p>
<p>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. You’ll focus on designing data structures, mapping data flows, and building scalable models, with the goal of growing 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.</p>
<h3>Key Responsibilities</h3>
<ul>
<li>
<b>Owning analytics engineering fundamentals (50%)</b>
<ul>
<li>Build 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).</li>
<li>Translate stakeholder questions into well‑structured tables, transformations, and documentation.</li>
<li>Ensure accuracy, reconciliation, and data quality across a complex set of sources in partnership with product and engineering teams.</li>
</ul>
</li>
<li>
<b>Building the tools and metrics that run the business (30%)</b>
<ul>
<li>Turn business needs into reliable data solutions by working directly with operations, growth, and product stakeholders to understand goals, clarify the "why," and deliver trusted data assets.</li>
<li>Define KPIs and build dashboards and monitoring tools to help teams understand performance and unlock stronger patient outcomes.</li>
<li>Organize and simplify complex datasets so downstream users can self‑serve.</li>
<li>Enable experimentation and impact measurement of new business initiatives, from new service offerings to improvements in patient communications.</li>
</ul>
</li>
<li>
<b>Answering high‑impact business questions (20%)</b>
<ul>
<li>Use SQL, BI tools, and statistical reasoning to explore data, run investigations, and communicate insights to non‑technical teams.</li>
<li>Partner with cross‑functional teams (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.</li>
</ul>
</li>
</ul>
<h3>Required Experience and Skills</h3>
<ul>
<li>3–5+ years of experience in data analytics or analytics engineering.</li>
<li>Strong SQL skills and experience designing or maintaining ETL/ELT‑style data models (dbt experience is an asset but not required).</li>
<li>Understanding of data modeling concepts, table architecture, and how to structure data for downstream use.</li>
<li>Experience with BI tools (Looker, Tableau, Superset, Mode, or similar).</li>
<li>A strong sense of ownership and ability to break down open‑ended questions into structured, solvable problems.</li>
<li>Comfort talking to stakeholders and translating ambiguous needs into clear technical plans.</li>
<li>Strong analytical and problem‑solving skills.</li>
<li>Excellent communication skills.</li>
</ul>
<h3>Desired (Nice to Have)</h3>
<ul>
<li>Proficiency in Python or R for advanced analytics and modelling.</li>
<li>Experience at a startup or in healthcare.</li>
</ul>
<h3>Compensation</h3>
<ul>
<li>$90,000 - $105,000 CAD a year</li>
<li>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.</li>
<li>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).</li>
</ul>
<h3>Benefits</h3>
<ul>
<li><b>Work/life flexibility and time off</b>
<ul>
<li>Work flexibly within a team that’s remote friendly; we believe that work should fit around your life.</li>
<li>20 vacation days and a team that will remind you to use them!</li>
<li>Annual winter break closure.</li>
</ul>
</li>
<li><b>Care for your physical and mental health</b>
<ul>
<li>Extended medical, dental, and vision care starting on your first day of work!</li>
<li>8 wellness days.</li>
<li>$500 health and wellness spending account.</li>
<li>$2,000 mental health coverage with additional free online counseling through Inkblot Therapy and FeelingBetterNow mental health assessments.</li>
<li>$20,000 of lifetime coverage for gender‑affirming care and procedures.</li>
</ul>
</li>
<li><b>Investment in your learning and growth</b>
<ul>
<li>$500 learning fund to use towards courses and other professional development.</li>
<li>Our unique People Potential program, in which you’ll partner with your manager to identify opportunities to grow and achieve your full potential.</li>
</ul>
</li>
<li><b>Family care</b>
<ul>
<li>$3,400 lifetime coverage for fertility drugs.</li>
<li>Parental leave program for birthing and non‑birthing parents – your choice of:<br/>
<ul>
<li>Short term: 4 weeks off to use flexibly in your first year of parenting.</li>
<li>Long‑term: 13 weeks EI top‑up.</li>
</ul>
</li>
</ul>
</li>
<li>Eligible team members and their dependents also receive no‑cost access to PurposeMed’s services:
<ul>
<li>Freddie: PrEP assessment and follow‑up appointments.</li>
<li>Frida: ADHD assessment.</li>
<li>Foria: Gender‑affirming care services.</li>
</ul>
</li>
</ul>
<p>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 apply!</p>
<p>Referrals increase your chances of interviewing at PurposeMed by 2x.</p></p>
#J-18808-Ljbffr