ottawa, on financial modeler Jobs – 2 Openings This Week

Data Modeler with Power BI
Recutify Inc. —Ottawa, ON
- Full-time
- Hybrid work
- Azure
- SQL
- AWS
Quick apply
Senior Financial Systems Manager
Lightspeed Commerce, Inc. —Ottawa, ON
- $140,000–$180,000 a year
- Full-time
- Remote
- Salesforce
- Finance
- SQL
- Disability insurance
- Dental care
Quick apply

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

AVP, Underwriter, SCOR Business Solutions (SBS)
SCOR —Toronto, ON
Bachelor’s degree required - an engineering degree preferred, but not mandatory. But we also want you to support the development of our submission pipeline and…
$160,000–$195,000 a year
Chief Agent & Head of SGL Canada
SCOR —Toronto, ON
The incumbent ensures that SGL Canada operates in full compliance with applicable laws and regulatory expectations, while driving profitable growth,…
5d

Show more jobs in cities nearby

I want to receive the latest job alerts for financial modeler in ottawa, on

By signing in to your account, you agree to Workopolis's Terms of Service and consent to our Cookie and Privacy Policy.

Data Modeler with Power BI

Recutify Inc.
Ottawa, ON

Quick apply

Job details

Full-time

Skills

Pricing
Power BI
Data modeling
Azure
SQL
AWS
Metadata
SSIS
Redshift
PL/SQL
Communication skills
Data warehouse
T-SQL

Full job description

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.

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.

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.

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.

Quick apply

Refine Your Search

financial modeler jobs in ottawa, on

Data Modeler with Power BI

Senior Financial Systems Manager

Explore jobs in cities nearby

I want to receive the latest job alerts for financial modeler in ottawa, on

Job seeker tools

Employer Tools

Browse

Stay Connected