Data Engineer

ML arteka; Ontario (OR); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive Salary

Flexible culture and autonomy

Mentorship and development programs

Transparency and trust

Job summary

ML arteka is seeking a Data Engineer to support governed data platform engagements at regulated financial institutions in Ontario, OR. You will design and deliver a semantic layer along with Power BI reporting capabilities, while contributing engineering capacity to client-owned data engineering and ETL.

You will also author and run automated tests to validate your work through deployment pipelines. In this embedded role, you will collaborate with client teams, configure Power BI connectivity,

Qualifications

• Shipped semantic layers for analytical tiers used by downstream consumers.
• Power BI report-build experience with connectivity to cloud stores, workspace setup, and RLS patterns.
• Experience delivering Power BI reports actually used by business users.
• Strong dimensional modeling with pragmatic normalization/denormalization decisions.
• Comfort with AWS data stack: S3, Athena, Iceberg, Aurora PostgreSQL; trace queries for performance.

Responsibilities

• Design and deliver semantic layer and Power BI reporting for governed data platform engagements.
• Own semantic model over analytical tier; configure Power BI connectivity and workspaces.
• Author and execute test cases; maintain automated tests in deployment pipelines.
• Design semantic layer over Athena analytical tiers and define the model for reporting patterns.
• Deliver production-quality Power BI reports validated with client stakeholders.
• Refine visualization requirements with client business stakeholders within agreed report scope.

Skills

Semantic modeling

Power BI

DAX

Row Level Security

AWS data stack

ETL

Test automation

Tools

Athena

BigQuery

Snowflake

Aurora PostgreSQL

Job description

ML arteka is looking for a Data Engineer to support governed data platform engagements at regulated financial institutions in Ontario, OR. In this embedded role, you will design and deliver a semantic layer alongside Power BI reporting capabilities, while contributing engineering capacity to client-owned data engineering and ETL. You will also author and run automated tests to validate your work through deployment pipelines.

What you’ll do

• 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 alongside client teams.
• Author and execute test cases that prove your work.
• Design and implement the semantic layer over client Athena analytical tiers, defining the model that Power BI and other analytical consumers read against for required reporting patterns.
• 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 reports for confirmed business audiences, validated with the client business partner during delivery.
• Refine visualization requirements with client business stakeholders within the agreed report scope, without expanding into custom UI territory.
• Co-develop as part of a client-owned delivery effort on data ingestion, transformation, and gap handling without taking outcome ownership the client retains.
• Author test specifications for the semantic layer, Power BI reports, and your ETL contributions; maintain automated tests that run as part of the client’s deployment pipeline; investigate and remediate defects on your components.
• Participate in an integrated delivery team cadence, including daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.

Requirements

• Designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) used in production by downstream consumers.
• Hands-on Power BI report-build experience, including DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns.
• Shipped Power BI reports that business users actually use.
• Strong dimensional modeling experience with pragmatic decisions on normalization versus denormalization and what makes a semantic layer usable versus purely theoretical.
• Comfortable in the AWS data stack: S3, Athena, Iceberg (or comparable formats), and Aurora PostgreSQL, with the ability to trace queries through the stack when performance is off.
• Testing as part of engineering craft, including testing data pipelines and semantic models and distinguishing between unit, integration, and data quality checks.
• Contributed to ETL and data engineering work through co-development and clean handback without treating ownership as a status question.
• Can walk a business partner through a report and iterate in the same session without needing a UX designer for basic layout and interaction decisions.
• Comfortable working inside a client team and delivering ownership outcomes without acting like a vendor visitor.

Technologies

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

Benefits

• Competitive Salary
• Purposeful Work with autonomy, resources, and time for what matters most for clients and for you
• Positive Environment with recognition, flexible culture, and a focus on diversity and inclusivity
• Growth & Development through mentorship, training, and development programs
• Transparency & Trust, with clear direction, purpose, mission, and expectations
• Exclusive Perks including discounts on shopping, the gym, insurance, and mobile phone plans, plus an office smoothie bar and enough coffee to keep you energized
• Meaningful Benefits including health, dental, vision, disability, travel insurance, and more
• Unforgettable Events such as team bonding, BBQs, office lunches (pizza, always pizza), gala dinners, and other fun activities