Data Modeler with Power BI

Role : Data Modeler with Power BI

Location : Ottawa/Toronto (Hybrid)

Long-term Contract

Position Overview

We are seeking an experienced Data Modeler with strong expertise in Power BI, data modeling best practices, and a solid background in the financial domain, particularly Capital Markets. The ideal candidate will design and optimize complex data models, enable advanced analytics, and partner closely with business stakeholders to deliver insights into trading, risk, portfolios, regulatory reporting, and financial performance.

Key Responsibilities

Data Modeling & Architecture

• Design, develop, and maintain conceptual, logical, and physical data models for financial and capital markets datasets.
• Build efficient star/snowflake schemas, semantic models, and optimized data structures for reporting and analytics.
• Create scalable Power BI data models, optimizing for performance, incremental refresh, DAX efficiency, and query folding.
  Define data standards, metadata structures, and documentation for business and technical users.

Power BI Development

• Develop complex dashboards, reports, and data visualizations using Power BI Desktop & Power BI Service.
• Write optimized DAX measures, calculated columns, tabular models, and data transformations.
• Implement Row-Level Security (RLS), deployment pipelines, governance best practices, and workspace management.
  Work closely with BI developers and analysts to ensure consistent KPIs and definitions across enterprise reporting.

Financial Domain Expertise

• Work with data related to equities, fixed income, derivatives, FX, market data, trading systems, risk data, P&L, and regulatory reporting.
• Understand trade lifecycle, valuation concepts, positions, exposures, reference data, and market data structures.
  Collaborate with financial controllers, risk teams, traders, and compliance stakeholders to understand data needs and processes.

Required Skills & Qualifications

Technical Skills

• Strong hands-on experience with Power BI (Desktop, DAX, Power Query, Dataflows, Service).
• Expertise in data modeling techniques, dimensional modeling, Kimball methodologies.
• Proficiency in SQL (T-SQL, PL/SQL or equivalent) and relational database design.
• Familiarity with Capital Markets data (trades, orders, positions, risk, pricing, market data).
• Experience with cloud data platforms such as Azure (preferred), Snowflake, or AWS Redshift.
• Understanding of ETL/ELT using tools like ADF, Databricks, SSIS, Synapse.

Domain Skills

• Strong understanding of banking, financial markets, asset management, trading systems, and risk management.
• Knowledge of regulatory frameworks: Basel, MiFID, Dodd Frank, etc. (optional but preferred).

Professional Skills

• Strong communication skills-able to translate complex data concepts to business stakeholders.
• Ability to manage multiple priorities, work in agile teams, and deliver high-quality outputs.
• Problem-solving mindset with an analytical, detail-oriented approach.