DataJobs.io
← Back to all jobs

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

Similar Jobs