Senior Power BI Developer Consultant (PL867)

Paralucent Inc; Toronto; Hybrid; CAD 100,000 - 145,000; Full time

Job summary

Paralucent Inc is seeking a Senior Power BI Developer/Consultant for a 3‑month engagement to design and develop a mortgage portfolio dashboard for a financial services client. The dashboard will support executive reporting, portfolio analysis, drill‑down views, dynamic filtering, and knowledge transfer to the client’s internal team.

The consultant will build Power BI pages aligned to data, create an executive summary landing page, enable mortgage portfolio analysis, and provide walkthroughs and

Qualifications

• Senior Power BI development experience.
• Mortgage portfolio analysis experience beneficial.
• Hybrid work environment in downtown Toronto.

Responsibilities

• Design and develop Power BI dashboard pages aligned to the scope and data.
• Build an executive summary landing page and portfolio analysis views.
• Create drill-down reporting to support current month account-level analysis.
• Develop dynamic filters and visuals across mortgage portfolio attributes.
• Support heat map style analysis and colour-coded views within Power BI.
• Work with aggregate historical portfolio data and current month data from the client.
• Advise on practical data model structure, report performance, usability, and maintainability.
• Collaborate with client stakeholders to confirm priority visuals and simplify requirements.
• Provide walkthroughs and knowledge transfer to client team members.
• Work within client access, onboarding, workspace, and governance constraints.
• Identify risks, dependencies, and assumptions that may affect delivery.

Skills

Power BI

DAX

Data modelling

Dashboard design

Stakeholder communication

Independent work

Tools

Power BI (Desktop)

Job description

Duration: 3 months contract
Role: Senior Power BI Developer / Consultant
Location: Hybrid, downtown Toronto, 2 days per week
Client environment: Financial services
Experience level: Senior
Mortgage experience: Beneficial

Paralucent is looking for a Senior Power BI Developer / Consultant for a 3-month engagement supporting the design and development of a mortgage portfolio dashboard for a financial services client. The dashboard will support executive reporting, portfolio analysis, drill-down views, dynamic filtering, visual analysis, and knowledge transfer to the client’s internal team.

The Senior Power BI Developer / Consultant will support the design, build, and handover of a Power BI dashboard that enables mortgage portfolio analysis.

Key responsibilities include:

• Design and develop Power BI dashboard pages aligned to the agreed scope and available data.
• Build an executive summary landing page and portfolio analysis views.
• Create drill-down reporting to support current month account-level analysis.
• Develop dynamic filters and visuals across agreed mortgage portfolio attributes, such as geography, loan-to-value buckets, insured status, balances, and delinquency measures.
• Support heat map style analysis and colour‑coded ratio or scoring views where feasible within Power BI and the available data.
• Work with aggregate historical portfolio data and current month account-level data provided by the client.
• Advise on practical data model structure, report performance, usability, and maintainability.
• Collaborate with client stakeholders to confirm priority visuals and simplify requirements where needed to fit the timeline and budget.
• Provide walkthroughs and knowledge transfer to client team members so they can maintain and update the dashboard after the engagement.
• Work within client access, onboarding, workspace, and technology constraints.
• Identify risks, dependencies, and assumptions that may affect delivery.

The consultant will support the following deliverables:

Working Power BI dashboard prototype or report.

Portfolio analysis views, including executive summary and drill-down views. Knowledge transfer walkthrough covering dashboard structure, key measures, refresh/update approach, and maintainability considerations.

Working Style

The ideal candidate is a senior, hands‑on Power BI developer who can move quickly, communicate clearly, and balance technical depth with practical delivery. They should be comfortable working in a hybrid client environment, asking the right questions, and helping the client team understand how to maintain the dashboard after delivery.

Required Skills and Experience

• Strong Power BI dashboard development experience.
• Advanced experience with Power BI data modelling, DAX, measures, calculations, and report optimization.
• Experience designing executive dashboards and analytical reporting views.
• Ability to create intuitive visualizations, drill-down reports, slicers, filters, and interactive dashboard experiences.
• Experience working with large datasets and performance considerations in Power BI.
• Strong understanding of data quality, data readiness, and practical reporting constraints.
• Ability to work directly with business stakeholders to clarify dashboard needs and translate them into practical report designs.
• Strong communication skills and the ability to explain design decisions clearly.
• Ability to work independently while collaborating with client and internal teams.
• Comfortable supporting knowledge transfer and handover walkthroughs.

Beneficial Experience

• Mortgage portfolio, lending, credit risk, delinquency, or financial services reporting experience.
• Experience with loan‑level or account‑level financial data.
• Experience building dashboards that include delinquency measures, balance analysis, concentration views, or portfolio segmentation.
• Experience working in banking or regulated enterprise environments.
• Familiarity with client onboarding, access management, and enterprise reporting governance.