Back to jobs

Data Engineer — Schematic and Reporting Focus

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design and deliver the semantic layer and Power BI reporting capability for governed data platform engagements at regulated financial institutions.

From the employer’s posting
The Role : Design and deliver the semantic layer and Power BI reporting capability for governed data platform engagements at regulated financial institutions. Own the semantic model over the analytical tier, configure Power BI connectivity and workspaces, deliver the agreed set of reports business users depend on, and contribute engineering capacity to client-owned data engineering and ETL work alongside client teams. Author and execute the test cases that prove your work. You Will :

About ML arteka

ML arteka is one of the fastest-growing IT Services and Consulting companies in Canada and serves some of the most iconic brands, including Google, Loblaws, Staples, Telus, Bell, Rogers, CIBC, BMO, CMLS, Fossil, Fitbit and more.

In the employer’s words · Read in context

Apply at ML arteka

Posting record

Report an error

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

Status in our records
Live
First seen by us
Nov 18, 2026today
Recorded sightings
2
Last seen by us
Nov 19, 2026
Employer says posted
Sep 29, 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 0

Early. Similar jobs usually come down between day 6 and day 56.

From 14,186 similar postings that came down. Coming down is not always a hire.

ML arteka is hiring

4 open jobs

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.

  • AWS
  • BigQuery
  • Iceberg
  • PostgreSQL
  • Power BI
  • S3
  • Snowflake
Where the posting names them
- You know dimensional modeling and can apply it pragmatically — you have opinions on when to normalize, when to denormalize, and what makes a semantic layer usable versus theoretically pure. - You are comfortable in the AWS data stack: S3, Athena, Iceberg or comparable formats, Aurora PostgreSQL. You can trace a query through the stack when performance is off. - You treat testing as part of your engineering craft — you write test cases as you build, you understand how to test data pipelines and semantic models (not just application code), and you can distinguish between a unit test, an integration test, and a data quality check.
Who You Are : - You have designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) — not just as a modeling exercise, but as the layer downstream consumers depend on in production. - You have hands-on Power BI experience at report-build depth: DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns. You have shipped Power BI reports business users actually use.
The Role : Design and deliver the semantic layer and Power BI reporting capability for governed data platform engagements at regulated financial institutions. Own the semantic model over the analytical tier, configure Power BI connectivity and workspaces, deliver the agreed set of reports business users depend on, and contribute engineering capacity to client-owned data engineering and ETL work alongside client teams. Author and execute the test cases that prove your work. You Will :
You Will : - Design and implement the semantic layer over client Athena analytical tiers — the model Power BI and other analytical consumers read against, structured for the reporting patterns the business needs. - Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and configure user workspaces in the client Power BI environment.
- Design and implement the semantic layer over client Athena analytical tiers — the model Power BI and other analytical consumers read against, structured for the reporting patterns the business needs. - Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and configure user workspaces in the client Power BI environment. - Deliver the agreed set of use case reports — production-quality Power BI reports built for the confirmed business audiences, validated with the client business partner during delivery.
- Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and configure user workspaces in the client Power BI environment. - Deliver the agreed set of use case reports — production-quality Power BI reports built for the confirmed business audiences, validated with the client business partner during delivery. - Refine visualization requirements with client business stakeholders during delivery, within the agreed report scope, without allowing scope to drift into custom UI territory.
- Contribute to client-owned data engineering and ETL work as a co-developer alongside the client technical lead — data ingestion, transformation, gap handling — without taking the outcome ownership the client retains. - Author test specifications for the semantic layer, Power BI reports, and your ETL contributions. Author and maintain automated tests that run as part of the deployment pipeline provided by the client. Investigate and remediate defects on your components. - Work as an embedded member of an integrated delivery team: participate in daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.
- You have designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) — not just as a modeling exercise, but as the layer downstream consumers depend on in production. - You have hands-on Power BI experience at report-build depth: DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns. You have shipped Power BI reports business users actually use. - You know dimensional modeling and can apply it pragmatically — you have opinions on when to normalize, when to denormalize, and what makes a semantic layer usable versus theoretically pure.

Your next step

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

Already applied? Track this application

Job description

View original posting ↗

Who we are

ML arteka  is one of the fastest-growing IT Services and Consulting companies in Canada and serves some of the most iconic brands, including Google,  Loblaws, Staples, Telus, Bell, Rogers, CIBC, BMO, CMLS, Fossil, Fitbit and more.

Over the last decade, we have achieved 100% client retention and earned more than 20 notable industry recognition. This reflects our reliability in delivering what we promise and the quality we bring to every engagement.

Join our growth-driven culture and help us lead, innovate, and simplify. We are looking for a team members who embody our values:
  • Empathetic - we listen, we understand, and are considerate of everyone
  • Persevering - we dont give up on challenges or people and go all the way
  • Inclusive - we value everyone and their perspectives
  • Reliable - we deliver what we promise, and more
  • Innovative - we make things better than they were yesterday
The Role :

Design and deliver the semantic layer and Power BI reporting capability for governed data platform engagements at regulated financial institutions. Own the semantic model over the analytical tier, configure Power BI connectivity and workspaces, deliver the agreed set of reports business users depend on, and contribute engineering capacity to client-owned data engineering and ETL work alongside client teams. Author and execute the test cases that prove your work.

You Will :
  • Design and implement the semantic layer over client Athena analytical tiers — the model Power BI and other analytical consumers read against, structured for the reporting patterns the business needs.
  • Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and configure user workspaces in the client Power BI environment.
  • Deliver the agreed set of use case reports — production-quality Power BI reports built for the confirmed business audiences, validated with the client business partner during delivery.
  • Refine visualization requirements with client business stakeholders during delivery, within the agreed report scope, without allowing scope to drift into custom UI territory.
  • Contribute to client-owned data engineering and ETL work as a co-developer alongside the client technical lead — data ingestion, transformation, gap handling — without taking the outcome ownership the client retains.
  • Author test specifications for the semantic layer, Power BI reports, and your ETL contributions. Author and maintain automated tests that run as part of the deployment pipeline provided by the client. Investigate and remediate defects on your components.
  • Work as an embedded member of an integrated delivery team: participate in daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.
Who You Are :
  • You have designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) — not just as a modeling exercise, but as the layer downstream consumers depend on in production.
  • You have hands-on Power BI experience at report-build depth: DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns. You have shipped Power BI reports business users actually use.
  • You know dimensional modeling and can apply it pragmatically — you have opinions on when to normalize, when to denormalize, and what makes a semantic layer usable versus theoretically pure.
  • You are comfortable in the AWS data stack: S3, Athena, Iceberg or comparable formats, Aurora PostgreSQL. You can trace a query through the stack when performance is off.
  • You treat testing as part of your engineering craft — you write test cases as you build, you understand how to test data pipelines and semantic models (not just application code), and you can distinguish between a unit test, an integration test, and a data quality check.
  • You have contributed to ETL and data engineering work without treating ownership as a status question — you can co-develop and hand back cleanly.
  • You can walk a business partner through a report and iterate on it in the same session, without needing a UX designer for basic layout and interaction decisions.
  • You are comfortable working inside a client team, participating in their cadence, and delivering ownership outcomes without behaving like a vendor visitor.
What to expect
 
Besides Competitive Salary and working for one of Canadas Best Managed and Top 50 Technology Companies, you should expect: 
  • Purposeful Work: autonomy, resources, and time you need to do what matters for our clients and most importantly - you
  • Positive Environment: recognition coupled with a flexible environment that celebrates diversity, inclusivity and encourages everyone to achieve their best
  • Growth & Development: opportunities to grow professionally and personally through mentorship, training, and development programs
  • Transparency & Trust: direction, purpose, mission, and expectations are never a secret; you will always know where you stand as well as where you are going
  • Exclusive Perks: discounts on shopping, the gym, insurance, mobile phone plans, not to mention an office smoothie bar and enough coffee to make you vibrate
  • Meaningful Benefits: life happens. You will get health, dental, vision, disability, travel insurance, and much more all covered by us
  • Unforgettable Events: team bonding, BBQs, office lunches (pizza, always pizza), gala dinners, and any other excuse to have fun

Inclusion and equal opportunity employment 

ML arteka is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans status, Aboriginal/Native American status, or any other legally-protected factors. Disability-related accommodation during the application process is available upon request.

Are you ready to join the award-winning team and help us accelerate digital transformation?

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
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 Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

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 data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

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

No pay amount identified in the saved description.

Location & working pattern

Toronto or Montreal, Ontario

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.