Marketing Data Analytics Engineer

Pointclickcare; United States; On-site; USD 85,000 - 120,000; Full time

Job summary

PointClickCare's Marketing team seeks a Marketing Data Analytics Engineer to build data infrastructure for marketing analytics and reporting. You will connect Salesforce, Marketo, and the data warehouse to automate campaigns and leadership dashboards.

You will design scalable pipelines, optimize SQL, and strengthen attribution while applying AI tools to accelerate exploration and documentation. Collaboration with Marketing Analytics and Ops is essential.

Qualifications

• Bachelor's degree completed or in final year in a technical field.
• Proficiency with Python for scripting, automation, or ETL.
• Curiosity to learn new tools and business context.
• Strong analytical mindset with emphasis on automation.
• 0–2 years of applicable experience.
• Understanding of relational data models and CRM/marketing data structure.
• Strong SQL skills: joins, aggregations, window functions.
• Hands-on exposure to Salesforce (SOQL, reports, campaign objects) or Marketo.
• Experience with a cloud data warehouse (BigQuery, Snowflake, Redshift) and BI tools.
• Familiarity with AI-assisted analytics tools like Claude.
• Exposure to ETL/ELT tooling or workflow orchestration (dbt, Airflow, Fivetran).
• Familiarity with marketing funnel metrics (MQLs, pipeline).
• Co-op, internship, or project experience in data roles.

Responsibilities

• Build and maintain data pipelines connecting Salesforce, Marketo, and data warehouse.
• Automate recurring marketing reporting workflows and optimize SQL for datasets.
• Strengthen campaign attribution logic and monitor data quality.
• Document data models, definitions, and processes for self-serve metrics.
• Apply AI tools to accelerate data exploration and query development while ensuring accuracy.
• Support backend administration in Salesforce and Marketo and maintain data sync rules.

Skills

Python

SQL

SOQL

Education

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

Tools

Salesforce

Marketo

BigQuery

Power BI

Looker

Tableau

Snowflake

Redshift

dbt

Airflow

Fivetran

Job description

Marketing Data Analytics Engineer

• 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
• 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

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
• Working knowledge of at least one programming language used in data work (e.g., Python) for scripting, automation, or ETL
• Intellectually curious and open-minded, with a genuine thirst to learn new tools, systems, and business context
• Highly analytical and detail-oriented, with a strong bias toward automating repetitive work
• 0- 2 years of applicable experience
• Understanding of relational data models and how CRM/marketing-automation data is structured (leads, contacts, accounts, campaigns, opportunities)
• Strong SQL skills: comfortable writing joins, aggregations, and window functions against large relational datasets
• 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