Engineer Jobs in Ontario, OR

1 job found

Include remote jobs

Today

Data Engineer

ML arteka Ontario, OR

Ontario, OR

Today

Full time Business Intelligence Data Analytics Data Architecture

Apply Now

Job Description

ML arteka is seeking a Data Engineer to support governed data platform engagements at regulated financial institutions in Ontario, OR. The role focuses on designing and delivering a production-ready semantic layer and Power BI reporting capability, including connectivity, workspaces, automated testing, and embedded collaboration with client technical teams.

Responsibilities

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, and deliver the agreed reports business users depend on.
Contribute engineering capacity to client-owned data engineering and ETL, working alongside client teams while supporting outcomes the client retains.
Author and execute test cases to validate the work across semantic layer and reporting deliverables.
Design and implement semantic layers over client Athena analytical tiers, structured for the reporting patterns needed by the business and consumed by Power BI and other analytical users.
Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and set up user workspaces in the client Power BI environment.
Deliver production-quality Power BI use case reports for confirmed business audiences, validated with client business partners during delivery.
Refine visualization requirements with client business stakeholders during delivery, staying within the agreed report scope and avoiding scope drift into custom UI territory.
Co-develop with the client technical lead on data ingestion, transformation, and gap handling, without taking outcome ownership from the client.
Author test specifications for semantic layer, Power BI reports, and ETL contributions; maintain automated tests that run as part of the client-provided deployment pipeline; investigate and remediate defects in your components.
Operate as an embedded member of an integrated delivery team, participating in daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.

Requirements

Experience designing and shipping semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) in production, not limited to modeling exercises.
Hands-on Power BI report-build depth, including DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns.
Evidence of shipping Power BI reports that business users actually use.
Pragmatic dimensional modeling experience, including decisions around normalization versus denormalization and what makes a semantic layer usable versus theoretically pure.
Comfort with AWS data stack components such as S3, Athena, Iceberg (or comparable formats), and Aurora PostgreSQL, including tracing query execution through the stack when performance issues arise.
Testing mindset applied to data pipelines and semantic models, with ability to distinguish between unit tests, integration tests, and data quality checks.
Experience contributing to ETL and data engineering with co-development that can be cleanly handed back to the client.
Ability to walk business partners through reports and iterate within the same session without requiring a UX designer for basic layout and interaction decisions.
Ability to work within a client team cadence while delivering ownership outcomes without behaving like an external vendor.

Technologies

Power BI
DAX
Athena
BigQuery
Snowflake
AWS
S3
Iceberg
Aurora PostgreSQL
Row Level Security

Benefits

Competitive Salary
Purposeful Work: autonomy, resources, and time you need to do what matters for clients and most importantly for you
Positive Environment: recognition with a flexible culture that celebrates diversity and inclusivity
Growth & Development: mentorship, training, and development programs
Transparency & Trust: clear direction, purpose, mission, and expectations
Exclusive Perks: discounts on shopping, gym, insurance, and mobile phone plans, plus an office smoothie bar and ample coffee
Meaningful Benefits: health, dental, vision, disability, travel insurance, and more
Unforgettable Events: team bonding, BBQs, office lunches (pizza, always pizza), gala dinners, and other social events

View full job page →

Get Engineer Jobs in Ontario, OR alerts

New Engineer Jobs in Ontario, OR, daily.