Build and maintain marketing data pipelines connecting Salesforce, Marketo, and cloud data warehouses. Automate campaign reporting, develop SQL datasets and views, improve attribution and data quality, support CRM and marketing automation configuration, and document data models and processes. Use AI tools such as Claude to accelerate analytics workflows while ensuring reporting accuracy. Partner with Marketing Analytics, Demand Generation, and Marketing Operations to support executive-level pipeline reporting.
At PointClickCare our mission is simple: to help providers deliver exceptional care. And that starts with our people. As a leading health tech company that’s founder-led and privately held, we empower our employees to push boundaries, innovate, and shape the future of healthcare.
With the largest long-term and post-acute care dataset and a Marketplace of 400+ integrated partners, our platform serves over 30,000 provider organizations, making a real difference in millions of lives. We also reinvest a significant percentage of our revenue back into research and development, ensuring our employees have the resources to innovate and make a lasting impact. Recognized by Forbes as a top private cloud company and honored as one of Canada’s Most Admired Corporate Cultures, we offer flexibility, growth opportunities, and meaningful work.
At PointClickCare, we empower our people to be the architects of a smarter healthcare future; one that is human-first and accelerated by AI to create meaningful and lasting change. Employees harness AI as a catalyst for creativity, productivity, and thoughtful decision-making. By integrating AI tools into our daily workflows, collaboration is enhanced, outcomes are improved, and every team member has the proficiency to maximize their impact. It all starts with our hiring practices where we uncover AI expertise that complements our mission, and we continue to invest in training and development to nurture innovation throughout the employee journey.
Join us in redefining healthcare — so it doesn’t just survive, it thrives. To learn more about PointClickCare, check out Life at PointClickCare and connect with us on Glassdoor and LinkedIn.
**Travel to Office expectations**
For Remote Roles: If this role is remote, there will be in-office events that will require travel to and from the Mississauga and/or Salt Lake City office. These will include, but not limited to, onboarding, team events, semi-annual and annual team meetings.
For Hybrid Roles: If this role is Hybrid, there will be an expectation to reside within commutable distance to the office/location specified in the job listing. This will include, but not limited to, weekly/bi-weekly/monthly events in the office with your specific team. This is a requirement for this role.
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.
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.
Required Skills & 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.
- 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.
Preferred Skills & Experience:
- 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.
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Field-based gastroenterology specialty sales role responsible for launching and growing GI products across Long Island. Builds compliant relationships with healthcare professionals, delivers approved product and disease-state messaging, supports reimbursement and patient access, prioritizes accounts, engages key opinion leaders, and collaborates cross-functionally. Requires territory travel, digital engagement, and strong knowledge of specialty pharmaceuticals, biologics, disease states, and reimbursement processes.
Top Skills:
Microsoft TeamsVeeva Engage
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads field medical strategy for Pfizer’s thoracic oncology portfolio across Michigan and Ohio. Engages healthcare professionals, delivers scientific education, provides medical information, gathers actionable insights, supports clinical trial site identification and investigator-sponsored research, leads advisory boards, and collaborates with Medical Affairs, Oncology R&D, and external stakeholders. The role requires substantial oncology expertise, strategic territory ownership, strong communication, frequent air travel, company-car operation, and 60–80% travel.
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Promotes Pfizer oncology products to healthcare providers, institutions, organized customers, and key opinion leaders across an Iowa territory. Develops strategic account and territory plans, generates product demand, educates customers on disease management and appropriate product use, builds institutional relationships, and addresses customer needs. Requires pharmaceutical or oncology healthcare experience, strong scientific communication, business acumen, digital proficiency, domestic travel, and a valid U.S. driver's license.
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
