Analytics Engineer

remotetcx; United States; Remote; USD 57,000 - 64,000; Full time

Benefits offered by this job

Remote-first

Competitive CAD salary

Flexible work

Diversity & inclusion

Job summary

remotetcx is seeking a mid-level Analytics Engineer to turn raw data into actionable insights shaping organizational strategy within a remote-first, globally distributed team.

The role blends data engineering, advanced analytics, and applied ML to power AI-driven decision-making. You will design data models in Snowflake with dbt, develop Looker dashboards, and apply AI-enabled analytics using Cortex/AISQL, collaborating with product, engineering, and business teams.

Qualifications

• Bachelor's degree in Computer Science, Statistics, or related quantitative field; Master's preferred.
• Two+ years in data analytics with exposure to AI/ML applications.
• Advanced SQL skills, including optimization on large-scale datasets.
• Hands-on dbt experience for building, documenting, and testing data models.
• Strong data modeling and warehouse design knowledge (star schema, normalization, slowly changing dimensions).
• Experience with Snowflake and BI tools like Looker or equivalents.

Responsibilities

• Design, build, and maintain data models and pipelines in Snowflake using dbt.
• Write advanced SQL queries on large datasets to surface patterns and opportunities for decisions.
• Develop and optimize Looker dashboards and LookML, including conversational analytics features.
• Apply Snowflake Intelligence tools (Cortex Analyst/Agents/Search/AISQL) for AI-driven insights.
• Write production-grade Python for analysis, data processing, and automation in orchestrated workflows (Airflow).
• Collaborate with product, engineering, and business stakeholders to translate requirements into data solutions and identify AI/ML opportunities.

Skills

Advanced SQL

Data analytics

Communication

Education

Bachelor's in CS/Statistics

Master's preferred

Tools

dbt

Snowflake

Looker/LookML

Airflow

Job description

Role overview

A mid-level Analytics Engineer position focused on turning raw data into actionable insights that shape organizational strategy. The role blends data engineering, advanced analytics, and applied machine learning to power AI-driven decision-making across a remote-first, globally distributed team.

Responsibilities

• Design, build, and maintain data models and transformation pipelines inside a Snowflake data warehouse using dbt for testing and documentation.
• Write advanced SQL queries against large-scale datasets to surface patterns, trends, and opportunities that inform strategic decisions.
• Develop and optimize Looker dashboards and LookML, including conversational analytics features that let stakeholders query data with natural language.
• Apply Snowflake Intelligence capabilities such as Cortex Analyst, Cortex Agents, Cortex Search, and AISQL to deliver conversational and AI-driven insights.
• Write production-grade Python for analysis, data processing, and automation, integrating jobs into orchestrated workflows like Airflow.
• Partner with product, engineering, and business stakeholders to translate requirements into data solutions and identify opportunities for AI/ML/NLP adoption.

Requirements

• Bachelor's degree in Computer Science, Statistics, or a related quantitative field; a Master's degree is preferred.
• Two or more years of experience in data analytics or a closely related field, with meaningful exposure to AI and machine learning applications.
• Advanced SQL skills, including optimization across complex, large-scale datasets.
• Hands-on experience with dbt for building, documenting, and testing data models.
• Strong grasp of data modeling and warehouse design, including star schema, normalization, and slowly changing dimensions.
• Experience with the Snowflake Data Cloud platform and familiarity with BI tools such as Looker or equivalent enterprise platforms.

Nice to have

• Experience with AI agents or generative AI tools used to streamline workflows or build automated analytic assistants.
• Background working with real-time or streaming data pipelines and orchestration tools like Airflow.
• A portfolio (GitHub, public dashboards, or similar) showcasing end-to-end analytics work on cloud warehouse or BI platforms.

Benefits and work setup

• Remote-first position with the flexibility to work from any location with reliable internet connectivity.
• Base salary range of 81,990 to 91,100 CAD for Canadian residents, with geographic variation for other locations and a total rewards package that includes fair compensation and benefits.
• Culture emphasizing respect, trust, and flexibility, with a stated commitment to diversity, inclusion, and accessibility accommodations throughout hiring and employment.