Marketing Data Analytics Engineer
Posted Updated
Description
- 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
- 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