Data Engineer - Semantic Layer & Power BI Specialist

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 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,