AI-Driven Marketing Data Analytics Engineer

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

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.