Data Engineer

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