Marketing Data Analytics Engineer (CA)

Key Responsibilities:

• 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.
• 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.
• #LI-TW1 #LI-Remote
• PointClickCare Benefits & Perks: Benefits starting from Day 1! Retirement Plan Matching Flexible Paid Time Off Wellness Support Programs and Resources Parental & Caregiver Leaves Fertility & Adoption Support Continuous Development Support Program Employee Assistance Program Allyship and Inclusion Communities Employee Recognition ... and more! It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact [email protected] should you require any accommodations. As part of our commitment to a streamlined and equitable hiring experience, PointClickCare uses AI tools to assist with candidate screening and assessment. When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: [email protected] PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information.

Required Skills & Qualifications:

Preferred Skills & Experience:

Additional information

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.
• 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.
• Familiarity with marketing funnel metrics (MQLs, opportunities, pipeline) or B2B demand generation.