AI-Driven Marketing Data Analytics Engineer

Openkrill; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Retirement Plan Matching

Flexible PTO

Wellness Programs

Parental & Caregiver Leaves

Fertility & Adoption Support

Development Support Program

Employee Assistance Program

Job summary

PointClickCare is hiring a Marketing Data Analytics Engineer to build and maintain the data infrastructure behind marketing analytics and pipeline reporting. You will work cross-functionally with Marketing Analytics, Demand Gen, and Marketing Operations to automate reporting and deliver trustworthy data for leadership dashboards.

The role emphasizes backend data work, SQL optimization, and applying AI-assisted analytics tools such as Claude to streamline data exploration and documentation.

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.
• Familiarity with Python for scripting/ETL/automation.
• Understanding of relational data models and CRM/marketing data structures.
• Analytical, detail-oriented and eager to automate repetitive tasks.

Responsibilities

• Design, build and maintain data pipelines connecting Salesforce, Marketo, and data warehouse (e.g., BigQuery).
• Automate recurring campaign reporting and develop reusable datasets, views, and queries.
• Improve campaign attribution logic and data quality across marketing platforms.
• Apply AI tools to accelerate data exploration and reporting while maintaining accuracy.
• Document data models, definitions and processes for self-serve metrics.

Skills

SQL

Python

CRM data models

Analytics

Education

Bachelor's degree in Software Engineering/CS/Data Eng

Tools

BigQuery

Salesforce

Marketo

dbt

Airflow

Power BI

Looker/Tableau

Job description

PointClickCare is hiring a Marketing Data Analytics Engineer to build and maintain the data infrastructure behind marketing analytics and pipeline reporting. You will work cross-functionally with Marketing Analytics, Demand Gen, and Marketing Operations to automate reporting and deliver trustworthy data for leadership dashboards.

The role emphasizes backend data work, SQL optimization, and applying AI-assisted analytics tools such as Claude to streamline data exploration and documentation.