Analytics Engineer Toronto (Remote)

Movable Ink; Edmonton; On-site; CAD 110,000 - 135,000; Full time

Job summary

Movable Ink is seeking a mid-level Analytics Engineer to join our Business Intelligence team. You will bridge business stakeholders and data models, translating reporting needs into clear metrics and ensuring consistent definitions across systems.

You will work in dbt to build from the silver to the gold layer in Redshift, create Tableau dashboards, and help stakeholders ask better questions of the data. This role emphasizes modeling and reporting over full-stack data ingestion.

Qualifications

• 4+ years of experience in analytics engineering, data analytics, or a similar role.
• Hands-on dbt experience, you've written models, tests, and documentation in a production environment.
• Strong SQL skills, particularly in a cloud data warehouse context (Redshift experience a plus).
• Familiarity with dimensional modeling concepts (facts, dimensions, slowly changing dimensions).
• Experience delivering analysis or dashboards to business stakeholders, not just building pipelines.
• Proficiency in a business intelligence tool (Tableau preferred).
• Comfort working in Git-based workflows (branching, PRs, code review).

Responsibilities

• Build and maintain dbt models from our business vault layer through to the data mart.
• Add fields, refine calculations, and extend existing mart models in collaboration with the BI team and our Enterprise Data team.
• Build net-new Kimball-style datasets from business vault sources when the data is available and no new ingestion is required.
• Build and maintain AI-ready datasets designed for consumption by internal AI systems, ensuring data is structured, documented, and reliable enough to serve as a trusted source for machine learning and AI applications.
• Maintain and enrich our data dictionary in OpenMetadata, keeping definitions, lineage, and field-level documentation current as models evolve.
• Partner with business stakeholders to define the right metrics for reporting; translating ambiguous business questions into clear, agreed-upon definitions before they become model changes.
• Partner with BI Analysts to translate insight needs into modeling requirements, removing blockers so analysts can focus on analysis rather than data prep.
• Build Tableau dashboards and reports that bring data mart outputs to life for stakeholders, keeping logic in the data layer and Tableau data sources free from complex calculations.

Skills

dbt

SQL

Tableau

Redshift

Git

Tools

OpenMetadata

Job description

Movable Ink scales content personalization for marketers through data-activated content generation and AI decisioning. The world’s most innovative brands rely on Movable Ink to maximize revenue, simplify workflow and boost marketing agility. Headquartered in New York City with close to 600 employees, Movable Ink serves its global client base with operations throughout North America, Central America, Europe, Australia, and Japan.

Movable Ink scales content personalization for marketers through data-activated content generation and AI decisioning. The world’s most innovative brands rely on Movable Ink to maximize revenue, simplify workflow and boost marketing agility. Headquartered in New York City with close to 600 employees, Movable Ink serves its global client base with operations throughout North America, Central America, Europe, Australia, and Japan.

We're looking for a mid-level Analytics Engineer to sit within our Business Intelligence team and accelerate the speed at which we turn available data into insights. You'll serve as a key bridge between business stakeholders and our data models translating reporting needs into well-defined metrics and ensuring those definitions are reflected correctly across all systems.

On the modeling side, you'll work in dbt to build from our established silver layer to consumption-ready gold layer in Redshift, operating within the standards and best practice. On the insights side, you'll build Tableau dashboards and reports, bring analytical rigor to conversations about what metrics matter and how they should be defined, and help stakeholders ask better questions of the data we already have.

This is not a full-stack data engineering role; you won't be ingesting new systems or building raw pipelines. You'll be a force multiplier on a rich, well-modeled data foundation, helping the team move faster and ensuring the right data gets in front of the right people.

Responsibilities:

• Build and maintain dbt models from our business vault layer through to the data mart


• Add fields, refine calculations, and extend existing mart models in collaboration with the BI team and our Enterprise Data team


• Build net-new Kimball-style datasets from business vault sources when the data is available and no new ingestion is required


• Build and maintain AI-ready datasets designed for consumption by internal AI systems, ensuring data is structured, documented, and reliable enough to serve as a trusted source for machine learning and AI applications


• Maintain and enrich our data dictionary in OpenMetadata, keeping definitions, lineage, and field-level documentation current as models evolve


• Partner with business stakeholders to define the right metrics for reporting; translating ambiguous business questions into clear, agreed-upon definitions before they become model changes


• Partner with BI Analysts to translate insight needs into modeling requirements, removing blockers so analysts can focus on analysis rather than data prep


• Build Tableau dashboards and reports that bring data mart outputs to life for stakeholders, keeping logic in the data layer and Tableau data sources free from complex calculations

Qualifications:

• 4+ years of experience in analytics engineering, data analytics, or a similar role


• Hands-on dbt experience, you've written models, tests, and documentation in a production environment


• Strong SQL skills, particularly in a cloud data warehouse context (Redshift experience a plus)


• Familiarity with dimensional modeling concepts (facts, dimensions, slowly changing dimensions)


• Experience delivering analysis or dashboards to business stakeholders, not just building pipelines


• Proficiency in a business intelligence tool (Tableau preferred), and conducting analyses involving multiple data sources and systems


• Comfort working in Git-based workflows (branching, PRs, code review)

The base pay range for this position is $110,000 - $135,000/year CAD, which can include additional bonus depending on the position ultimately offered, in addition to a full range of medical, financial, and/or other benefits. The base pay offered may vary depending on job-related knowledge, skills, and experience.

Studies have shown that women, communities of color, and historically underrepresented people are less likely to apply to jobs unless they meet every single qualification. We are committed to building a diverse and inclusive culture where all Inkers can thrive. If you’re excited about the role but don’t meet all of the abovementioned qualifications, we encourage you to apply. Our differences bring a breadth of knowledge and perspectives that makes us collectively stronger.

We welcome and employ people regardless of race, color, gender identity or expression, religion, genetic information, parental or pregnancy status, national origin, sexual orientation, age, citizenship, marital status, ethnicity, family or marital status, physical and mental ability, political affiliation, disability, Veteran status, or other protected characteristics. We are proud to be an equal opportunity employer.