Back to jobs

Analytics Engineer

4789 Yonge St, Toronto, ON M2N 0G3, Canada

Actively hiring, first seen by us 3 days ago
Pay
$75,000–85,000/yearAnnual period assumed — pay source
Why This Role This is not a “maintain the status quo” hire. We have a real mandate to modernize how data is managed and delivered across the business, leadership that supports it, and the infrastructure investment already underway. If you are someone who gets energized by owning data end-to-end — from the pipeline that builds it to the dashboard that tells the story — this role was built for you. Compensation : $75-85k (Onsite Role)
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design and maintain data pipelines using PySpark and SQL, supporting a medallion architecture (bronze → silver → gold).

  • Build and maintain recurring business reports — sales performance, churn analysis, revenue variance, and commission reconciliation.

  • Document data models, transformation logic, and report definitions to an audit-grade standard.

From the employer’s posting
Data Engineering & Pipeline Development Design and maintain data pipelines using PySpark and SQL, supporting a medallion architecture (bronze → silver → gold). Build ingestion, transformation, and validation workflows that are clean, documented, and maintainable by others.
Reporting & Analytics Build and maintain recurring business reports — sales performance, churn analysis, revenue variance, and commission reconciliation. Develop and publish Power BI dashboards with DirectLake or import-mode datasets, using DAX for calculated measures and KPIs.
Use Power Query, Dataflow Gen2, and notebook-based pipelines to streamline data preparation. Document data models, transformation logic, and report definitions to an audit-grade standard. Collaboration & Delivery

What you’ll bring

All qualifications

Core experience

  • 3–5 years of experience in a data analyst, BI engineer, analytics engineer, or similar hands-on data role.
  • Hands-on experience with Microsoft Fabric: Lakehouses, Dataflow Gen2, Fabric Pipelines, OneLake.
  • Demonstrated experience building automated data processes that replaced manual work — not just improved it.
  • Experience using LLMs or ML tools in a practical data or automation context (even prototyping counts).
  • Strong SQL: complex queries, joins, aggregations, CTEs, and transformation logic.
  • Familiarity with agentic AI frameworks or AI-assisted workflow design.
Qualification wording
3–5 years of experience in a data analyst, BI engineer, analytics engineer, or similar hands-on data role.
Hands-on experience with Microsoft Fabric: Lakehouses, Dataflow Gen2, Fabric Pipelines, OneLake.
Demonstrated experience building automated data processes that replaced manual work — not just improved it.
Experience using LLMs or ML tools in a practical data or automation context (even prototyping counts).
Strong SQL: complex queries, joins, aggregations, CTEs, and transformation logic.
Familiarity with agentic AI frameworks or AI-assisted workflow design.
Apply at Wirelessdna

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Mar 12, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 7 and day 52.

From 1,781 similar postings that came down. Coming down is not always a hire.

Wirelessdna is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Excel
  • Power BI
  • Power Query
  • Spark
  • pandas
  • PySpark
Where the posting names them
Familiarity with agentic AI frameworks or AI-assisted workflow design. Python (pandas, data wrangling) as a complement to PySpark workflows. Exposure to telecom, dealer, or commission-based business models.
Data Engineering & Pipeline Development Design and maintain data pipelines using PySpark and SQL, supporting a medallion architecture (bronze → silver → gold). Build ingestion, transformation, and validation workflows that are clean, documented, and maintainable by others.
Demonstrated experience building automated data processes that replaced manual work — not just improved it. Strong SQL: complex queries, joins, aggregations, CTEs, and transformation logic. PySpark / Spark SQL: notebook-based data processing and transformation.
Strong SQL: complex queries, joins, aggregations, CTEs, and transformation logic. PySpark / Spark SQL: notebook-based data processing and transformation. Advanced Power BI: report development, data modelling, DAX measures, and performance optimization.
Power Query (M language): custom transformations and query optimization. Advanced Excel: pivot tables, dynamic arrays, Power Query integration. A genuine curiosity about AI tools and where they can be applied — you follow this space, you experiment, you have opinions.
Build and maintain recurring business reports — sales performance, churn analysis, revenue variance, and commission reconciliation. Develop and publish Power BI dashboards with DirectLake or import-mode datasets, using DAX for calculated measures and KPIs. Translate business questions from stakeholders into accurate, well-structured data outputs.
PySpark / Spark SQL: notebook-based data processing and transformation. Advanced Power BI: report development, data modelling, DAX measures, and performance optimization. Power Query (M language): custom transformations and query optimization.
At least one AI-assisted workflow is live and demonstrably replacing a previously manual process. Power BI dashboards are trusted by stakeholders as the definitive source of truth for key metrics. Data pipelines are clean, documented, and maintainable by the broader team without your involvement.
Identify manual, repetitive reporting processes and deliver automated replacements. Use Power Query, Dataflow Gen2, and notebook-based pipelines to streamline data preparation. Document data models, transformation logic, and report definitions to an audit-grade standard.
Advanced Power BI: report development, data modelling, DAX measures, and performance optimization. Power Query (M language): custom transformations and query optimization. Advanced Excel: pivot tables, dynamic arrays, Power Query integration.

Your next step

Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.

Applying through Dayforce

  • The application asks you to sign in to the employer’s Dayforce candidate portal, or create an account there.

Already applied? Track this application

Job description

View original posting ↗

Key Responsibilities : Data Engineering & Pipeline Development  Design and maintain data pipelines using PySpark and SQL, supporting a medallion architecture (bronze → silver → gold).  Build ingestion, transformation, and validation workflows that are clean, documented, and maintainable by others.  Apply schema validation, deduplication logic, and data integrity checks as standard practice.  Use Microsoft Fabric (Lakehouses, Dataflow Gen2, Fabric Pipelines) as the primary platform.  Reporting & Analytics  Build and maintain recurring business reports — sales performance, churn analysis, revenue variance, and commission reconciliation.  Develop and publish Power BI dashboards with DirectLake or import-mode datasets, using DAX for calculated measures and KPIs.  Translate business questions from stakeholders into accurate, well-structured data outputs.  Proactively surface anomalies and data quality issues.   Process Automation  Identify manual, repetitive reporting processes and deliver automated replacements.  Use Power Query, Dataflow Gen2, and notebook-based pipelines to streamline data preparation.  Document data models, transformation logic, and report definitions to an audit-grade standard.  Collaboration & Delivery  Work closely with business stakeholders to understand reporting requirements and validate outputs.  Scope clearly, execute promptly, and communicate blockers early.  Document data models, transformation logic, and report definitions to an audit-grade standard.  Maintain organized, version-controlled artifacts in SharePoint.    Requirements:  3–5 years of experience in a data analyst, BI engineer, analytics engineer, or similar hands-on data role.  Demonstrated experience building automated data processes that replaced manual work — not just improved it.  Strong SQL: complex queries, joins, aggregations, CTEs, and transformation logic.  PySpark / Spark SQL: notebook-based data processing and transformation.  Advanced Power BI: report development, data modelling, DAX measures, and performance optimization.  Power Query (M language): custom transformations and query optimization.  Advanced Excel: pivot tables, dynamic arrays, Power Query integration.  A genuine curiosity about AI tools and where they can be applied — you follow this space, you experiment, you have opinions.  Self-directed: you identify problems without being told and you drive solutions to completion.  Preferred / Assets  Hands-on experience with Microsoft Fabric: Lakehouses, Dataflow Gen2, Fabric Pipelines, OneLake.  Experience using LLMs or ML tools in a practical data or automation context (even prototyping counts).  Familiarity with agentic AI frameworks or AI-assisted workflow design.  Python (pandas, data wrangling) as a complement to PySpark workflows.  Exposure to telecom, dealer, or commission-based business models.  Experience building or maintaining medallion (bronze/silver/gold) data architectures.  Familiarity with Dataverse / Dynamics 365 data structures.  Background working in lean IT teams where you own the full stack from raw data to report.    Success in the First 6 Months  Success in this role is measured by reliability, trust, and manual work eliminated — not just deliverables shipped.  Core recurring reports — reconciliation, variance, churn, sales performance — are automated and running reliably with minimal manual intervention.  A material, trackable reduction in time spent by the business on recurring manual data tasks.  At least one AI-assisted workflow is live and demonstrably replacing a previously manual process.  Power BI dashboards are trusted by stakeholders as the definitive source of truth for key metrics.  Data pipelines are clean, documented, and maintainable by the broader team without your involvement.  Ad hoc analysis requests are turned around quickly with accurate, well-presented outputs.  The Sr. IT Manager’s time on routine data tasks is materially reduced.    Why This Role  This is not a “maintain the status quo” hire. We have a real mandate to modernize how data is managed and delivered across the business, leadership that supports it, and the infrastructure investment already underway. If you are someone who gets energized by owning data end-to-end — from the pipeline that builds it to the dashboard that tells the story — this role was built for you.  Compensation : $75-85k (Onsite Role)

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Why This Role This is not a “maintain the status quo” hire. We have a real mandate to modernize how data is managed and delivered across the business, leadership that supports it, and the infrastructure investment already underway. If you are someone who gets energized by owning data end-to-end — from the pipeline that builds it to the dashboard that tells the story — this role was built for you. Compensation : $75-85k (Onsite Role)
Location & working pattern

4789 Yonge St, Toronto, ON M2N 0G3, Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.