Analytics Engineer

Meltwater is seeking an experienced Analytics Engineer to join our Revenue Data & AI team and contribute to building a robust, AI-enriched data infrastructure that powers revenue-focused initiatives across Sales, Customer Success, Marketing, and Finance. This role will report directly to a Sr AI Analytics Engineer, based in our Toronto office.

• Design, build, and maintain scalable dbt models on Snowflake/Databricks/Big Query that transform raw source data into reliable, well-documented datasets for analytics and reporting.
• Build and orchestrate Airflow DAGs that coordinate dbt runs, Snowpark Container jobs, and external task sensors across 20+ source systems.
• Integrate data from Salesforce, Gong, Intercom, Google Ads, Zoom, Satismeter, Workday, Gainsight, Kantata, Jira, and other external APIs into a unified revenue data model.
• Develop incremental, merge-based models with appropriate unique keys, schema-change handling, and date-window filtering for cost-efficient refreshes.
• Apply Snowflake Cortex AI functions (COMPLETE, SENTIMENT, TRANSLATE, _RECURSIVE_CHARACTER) to enrich text-heavy datasets such as call transcripts, emails, and survey responses, and produce vector-ready chunks for Cortex Search.
• Collaborate on AI/ML pipelines that combine dbt transformations with Snowpark Container Services jobs (e.g., PII redaction) to produce safe, enriched 360° views of customer interactions.
• Optimize warehouse usage, query patterns, and model materializations for performance, scalability, and cost — including query tagging for cost attribution and audit.
• Establish and enforce data quality standards through dbt tests (uniqueness, not-null, referential integrity), source freshness checks, and Airflow short-circuit validators.
• Implement data governance best practices — RBAC-driven schema promotion, masking/PII handling, lineage documentation, and compliant access patterns across source and prod.
• Work closely with Revenue Operations, FP&A, Sales, CS, and Business Applications teams to translate business questions into well-structured datasets and semantic models.
• Support the deployment of data-driven models and algorithms (AI tagging for use cases, churn-risk signals, competitor mentions, sentiment scoring, semantic search over conversations) in close collaboration with stakeholders.
• Contribute to shared dbt macros, testing frameworks, and CI/CD practices (SQLFluff linting, Slack-based alerting).

• Warehouse:
  Snowflake (Cortex AI, Snowpark, Snowpark Container Services, dynamic warehouses, RBAC)
• Transformation: dbt (dbt-snowflake)
• Orchestration:
  Apache Airflow 3.x on SPCS
• Languages:
  
  SQL, Python
• Tooling: SQLFluff (Snowflake dialect), Docker, Git, Fivetran (upstream ingestion)
• Integrations:
  Salesforce, Gong, Intercom, Google Ads, Zoom, Satismeter, Workday, Gainsight, Kantata, Saleshood, Jira, GCS

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• 2-4 years of experience in data engineering, ETL development, and database management.
• Proficiency in SQL and Python, with experience using ETL and reverse ETL tools like Fivetran, Census, Hightouch, and DBT.
• Familiarity with data visualization tools (Tableau, Power BI, Looker, etc).
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and big data technologies.
• Strong problem-solving skills and attention to detail.
• Effective communication skills to collaborate with cross-functional teams.
• Preferred experience with data warehousing solutions such as Snowflake and Databricks.

• Flexible paid time off that allows you to have an enhanced work-life balance.
• Excellent medical, dental, and vision options.
• Complimentary Calm App subscription for you and your loved ones, because mental wellness matters.
• Energetic work environment with a hybrid work style, providing the balance you need.
• Thrive within our inclusive community and seize ongoing professional development opportunities to elevate your career.

At Meltwater, we believe great impact deserves great reward. Our compensation approach is data-driven, market-informed, and built to scale with your growth. We benchmark roles against external market data and use structured leveling frameworks to ensure fairness, consistency, and internal equity across teams and geographies.

These frameworks are based on objective, gender-neutral criteria in line with applicable pay transparency regulations.

For this role, the base salary range is $95,000 - $110,000 CAD.

Compensation may also include a performance-based bonus opportunity.

Actual offers are determined based on job-related skills, experience, demonstrated capabilities, and work location. We typically hire within the range in a way that supports long-term growth, recognizing that compensation evolves as scope, performance, and impact expand over time.

We regularly review our compensation practices and conduct pay equity analyses to help ensure our decisions remain fair, objective, and…