Remote AI-Powered Marketing Data Engineer

Openkrill; United States; Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Retirement Plan Matching

Flexible Paid Time Off

Wellness Support Programs andResources

Parental & Caregiver Leaves

Fertility & Adoption Support

Continuous Development Support Program

Employee Assistance Program

Allyship and Inclusion Communities

Job summary

PointClickCare is hiring a Marketing Data Analytics Engineer to build and maintain data infrastructure behind marketing analytics and pipeline reporting. You will work across Salesforce, Marketo, and our data warehouse, leveraging AI-assisted analytics tools to streamline campaign data capture and reporting.

You’ll partner with Marketing Analytics, Demand Generation, and Marketing Operations to translate recurring reporting needs into automated, trustworthy data flows that support

Qualifications

• Bachelor’s degree in software engineering, CS, data engineering, or related field.
• 0 - 2 years of applicable experience.
• Strong SQL skills: joins, aggregations, window functions on large relational datasets.
• Working knowledge of Python for scripting, automation, or ETL.
• Understanding of CRM/marketing data structures (leads, contacts, accounts, campaigns, opportunities).
• Highly analytical and detail-oriented with a bias toward automating repetitive work.

Responsibilities

• Design, build, and maintain data pipelines connecting Salesforce, Marketo, and the data warehouse (e.g., BigQuery) to support marketing performance reporting.
• Automate recurring campaign reporting workflows; write/optimize SQL for reusable datasets, views, and queries powering dashboards and leadership reporting.
• Strengthen campaign attribution logic and monitor data quality across Marketo, Salesforce, and downstream reporting tables.
• Apply AI tools such as Claude to accelerate data exploration, documentation, and query development while maintaining rigor in production reporting.
• Document data models, definitions, and processes so metrics stay consistent and self-serve for marketing stakeholders.

Skills

SQL

Python

Salesforce

Marketo

BigQuery

Claude

ETL/ELT

CRM data model

Education

Bachelor's degree in Software Engineering, Computer Science, Data Engineering or related

Tools

Salesforce

Marketo

BigQuery

Snowflake

Redshift

Power BI

Looker

Tableau

dbt

Airflow

Fivetran

Claude

Job description

PointClickCare is hiring a Marketing Data Analytics Engineer to build and maintain data infrastructure behind marketing analytics and pipeline reporting. You will work across Salesforce, Marketo, and our data warehouse, leveraging AI-assisted analytics tools to streamline campaign data capture and reporting.

You’ll partner with Marketing Analytics, Demand Generation, and Marketing Operations to translate recurring reporting needs into automated, trustworthy data flows that support