DeveloperJobs.io
← Back to all jobs

Job Description

Design and deliver governed analytics capabilities for regulated financial institutions, with a focus on a semantic layer and production Power BI reporting.

Responsibilities

  • Design and deliver a semantic layer and Power BI reporting capability for governed data platform engagements.
  • Own the semantic model for the analytical tier, including configuring Power BI connectivity and workspaces.
  • Deliver the agreed set of reports business users depend on.
  • Contribute engineering capacity to client-owned data engineering and ETL work alongside client teams.
  • Author and execute test cases that validate your work.
  • Design and implement the semantic layer over client Athena analytical tiers, structured to support 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 use case reports as production-quality Power BI deliverables, validated with the client business partner during delivery.
  • Refine visualization requirements with client business stakeholders within the agreed report scope, avoiding scope drift into custom UI work.
  • Co-develop client-owned data engineering and ETL contributions alongside the client technical lead (data ingestion, transformation, gap handling) without taking outcome ownership the client retains.
  • Author test specifications for the semantic layer, Power BI reports, and ETL contributions; maintain automated tests that run in the client deployment pipeline.
  • Investigate and remediate defects on your components.
  • Participate as an embedded team member in daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.

Requirements

  • Have designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) for production downstream consumer use.
  • Hands-on Power BI experience at report-build depth: DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns.
  • Have shipped Power BI reports that business users actually use.
  • Know dimensional modeling and apply it pragmatically (including when to normalize or denormalize) to keep the semantic layer usable in practice.
  • Comfortable in the AWS data stack: S3, Athena, Iceberg (or comparable formats), Aurora PostgreSQL, and able to trace query execution across the stack when performance issues arise.
  • Treat testing as part of engineering craft, including test cases for data pipelines and semantic models; distinguish unit tests, integration tests, and data quality checks.
  • Have contributed to ETL and data engineering as a co-developer, returning clean handoffs without treating ownership as a status question.
  • Can walk a business partner through a report and iterate in the same session without requiring a dedicated UX designer for basic layout and interaction decisions.
  • Comfortable working inside a client team and delivering ownership outcomes within the team cadence.

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 to focus on what matters
  • Positive Environment with recognition and a flexible culture that supports 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; office smoothie bar and ample coffee
  • Meaningful Benefits covering health, dental, vision, disability, and travel insurance
  • Unforgettable Events such as team bonding, BBQs, office lunches (pizza), gala dinners, and other team activities

Location: Ontario, OR (onsite)

Similar Jobs