Marketing Data Analytics Engineer (US)

PointClickCare is a health technology company focused on helping care providers deliver exceptional care. The Marketing Data Analytics Engineer will build and maintain data infrastructure connecting Salesforce, Marketo, and the data warehouse to support marketing analytics and pipeline reporting. The role will automate reporting workflows, improve campaign attribution and data quality, apply AI-assisted analytics tools, and support backend systems administration and documentation.

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 and write/optimize SQL to build reusable datasets, views, and queries that power dashboards and leadership reporting
• 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
• Apply AI tools such as Claude to accelerate data exploration, documentation, and query development, while maintaining rigor and accuracy in production reporting
• 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

Requirements:

• Bachelor's degree (completed or in final year) in Software Engineering, Computer Science, Data Engineering, or a related technical field
• 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
• 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