Marketing Data Analytics Engineer

Join PointClickCare's Marketing organization as a Marketing Data Analytics Engineer. In this hands-on, backend-focused role, you will build and maintain the data infrastructure behind marketing analytics and pipeline reporting. You will work closely with Marketing Analytics, Demand Generation, and Marketing Operations to automate reporting workflows and improve data quality. This position requires a bachelor's degree in a related technical field, strong SQL skills, and familiarity with Salesforce or Marketo.

• Design, build, and maintain data pipelines connecting Salesforce, Marketo, and the data warehouse 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 and monitor, troubleshoot, and improve data quality across Marketo, Salesforce, and downstream reporting tables.

• 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