Marketing Data Analytics Engineer (US)

PointClickCare; United States; On-site; USD 87,000 - 97,000; Full time

Benefits offered by this job

Benefits starting from Day 1!

Retirement Plan Matching

Flexible Paid Time Off

Wellness Support Programs andResources

Parental & Caregiver Leaves

Fertility & Adoption Support

Employee Assistance Program

Allyship and Inclusion Communities

Employee Recognition

Job summary

PointClickCare's Marketing Data Analytics Engineer role focuses on building and maintaining data infrastructure for marketing analytics across Salesforce, Marketo, and data warehouses. You will drive automated reporting and AI-assisted insights to support executive-level metrics for Senior Care and Acute & Payer businesses.

The role demands strong SQL and Python skills, plus familiarity with CRM data models and data quality practices.

Qualifications

• Bachelor's degree in Software Engineering, Computer Science, Data Engineering or related field.
• 0–2 years of applicable experience.
• Strong SQL skills with joins, aggregations and window functions.
• Knowledge of Python for scripting, automation or ETL.
• Understanding of CRM/marketing data structures (leads, contacts, campaigns).
• Analytical, detail‑oriented, and eager to automate repetitive work.

Responsibilities

• Design, build, and maintain data pipelines connecting Salesforce, Marketo and the data warehouse.
• Automate recurring campaign reporting workflows and optimize SQL for datasets and dashboards.
• Strengthen campaign attribution logic and monitor data quality across systems.
• Apply AI tools to accelerate data exploration, while keeping production reporting rigorous.
• Support backend administration and document data models and processes for self‑serve metrics.

Skills

SQL

Python

CRM data models

Automation

Data analysis

Attention to detail

Education

Bachelor's degree

Tools

Salesforce

Marketo

BigQuery

Power BI

Looker

Tableau

Job description

At PointClickCare our mission is simple: to help providers deliver exceptional care. And that starts with our people. As a leading health tech company that’s founder-led and privately held, we empower our employees to push boundaries, innovate, and shape the future of healthcare.

With the largest long-term and post-acute care dataset and a Marketplace of 400+ integrated partners, our platform serves over 30,000 provider organizations, making a real difference in millions of lives. We also reinvest a significant percentage of our revenue back into research and development, ensuring our employees have the resources to innovate and make a lasting impact. Recognized by Forbes as a top private cloud company and honored as one of Canada’s Most Admired Corporate Cultures, we offer flexibility, growth opportunities, and meaningful work.

At PointClickCare, we empower our people to be the architects of a smarter healthcare future; one that is human-first and accelerated by AI to create meaningful and lasting change. Employees harness AI as a catalyst for creativity, productivity, and thoughtful decision-making. By integrating AI tools into our daily workflows, collaboration is enhanced, outcomes are improved, and every team member has the proficiency to maximize their impact. It all starts with our hiring practices where we uncover AI expertise that complements our mission, and we continue to invest in training and development to nurture innovation throughout the employee journey.

Join us in redefining healthcare — so it doesn’t just survive, it thrives. To learn more about PointClickCare, check out Life at PointClickCare and connect with us on Glassdoor and LinkedIn.

Travel to Office expectations

For Remote Roles: If this role is remote, there will be in-office events that will require travel to and from the Mississauga and/or Salt Lake City office. These will include, but not limited to, onboarding, team events, semi-annual and annual team meetings.

For Hybrid Roles: If this role is Hybrid, there will be an expectation to reside within commutable distance to the office/location specified in the job listing. This will include, but not limited to, weekly/bi-weekly/monthly events in the office with your specific team. This is a requirement for this role.

Position Summary

PointClickCare's Marketing organization is hiring a Marketing Data Analytics Engineer to build and maintain the data infrastructure behind marketing analytics and pipeline reporting. This hands-on, backend-focused role works across Salesforce, Marketo, and the data warehouse, increasingly leveraging AI-assisted analytics tools such as Claude, to streamline how campaign performance data is captured, connected, and reported. The role partners closely with Marketing Analytics, Demand Generation, and Marketing Operations to turn recurring reporting needs into automated, trustworthy data flows that directly support executive-level reporting on marketing-sourced pipeline across the Senior Care and Acute & Payer businesses.

Key Responsibilities

• Data Pipelines & Integrations: Design, build, and maintain data pipelines connecting Salesforce, Marketo, and the data warehouse (e.g., BigQuery) to support marketing performance reporting.
• Reporting Automation & Analytics Enablement: Automate recurring campaign reporting workflows and write/optimize SQL to build reusable datasets, views, and queries that power dashboards and leadership reporting.
• Campaign Attribution & Data Quality: Strengthen campaign attribution logic (campaign codes, UTM/campaign member data, lead-to-opportunity linkage) and monitor, troubleshoot, and improve data quality across Marketo, Salesforce, and downstream reporting tables.
• AI-Enabled Analytics Workflows: Apply AI tools such as Claude to accelerate data exploration, documentation, and query development, while maintaining rigor and accuracy in production reporting.
• Systems Support & Documentation: Support backend administration and configuration in Salesforce and Marketo (fields, objects, sync rules, campaign structures), and document data models, definitions, and processes so metrics stay consistent and self-serve for marketing stakeholders.

Required Skills & Qualifications

• Bachelor's degree (completed or in final year) in Software Engineering, Computer Science, Data Engineering, or a related technical field. New graduates are encouraged to apply.
• 0 – 2 years of applicable experience.
• Strong SQL skills: comfortable writing joins, aggregations, and window functions against large relational datasets.
• Working knowledge of at least one programming language used in data work (e.g., Python) for scripting, automation, or ETL.
• Understanding of relational data models and how CRM/marketing-automation data is structured (leads, contacts, accounts, campaigns, opportunities).
• Highly analytical and detail-oriented, with a strong bias toward automating repetitive work.
• Intellectually curious and open-minded, with a genuine thirst to learn new tools, systems, and business context.

Preferred Skills & Experience

• Hands‑on exposure to Salesforce (SOQL, reports, campaign objects, admin concepts) or Marketo (programs, smart campaigns, field sync).
• Experience with a cloud data warehouse (BigQuery, Snowflake, Redshift) and BI tools (Power BI, Looker, Tableau).
• Familiarity with AI‑assisted development or analytics tools, such as Claude or similar large language model platforms.
• Exposure to ETL/ELT tooling, APIs, or workflow orchestration (e.g., dbt, Airflow, Fivetran, or equivalent scripting).
• Familiarity with marketing funnel metrics (MQLs, opportunities, pipeline) or B2B demand generation.
• Co‑op, internship, or project experience in a data engineering, analytics engineering, or revenue operations context.

PointClickCare Benefits & Perks

• Benefits starting from Day 1!
• Retirement Plan Matching
• Flexible Paid Time Off
• Wellness Support Programs and Resources
• Parental & Caregiver Leaves
• Fertility & Adoption Support
• Employee Assistance Program
• Allyship and Inclusion Communities
• Employee Recognition … and more!

At PointClickCare, base salary is one of the many components that make up our total rewards package. The US base salary range for this position is $87,000 - $97,000 + bonus + benefits, non-overtime eligible. Our salary ranges are determined by job and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all US locations. Within the range, individual compensation is determined by job‑related skills and knowledge, relevant experience including professional and lived experience, and/or work location. Your recruiter can share more information about our total rewards package during the hiring process.