Senior Business Intelligence Developer

Senior Business Intelligence Engineer

Job Type: Contract

Contract Duration: 4 Months (Potential Extension up to 12 Months)

Pay Rate/Salary: 70 on Inc

Location: 4 Days Onsite, Downtown Toronto, ON

What You Need to Do

· Design, develop, and maintain enterprise-grade Power BI semantic models, datasets, reports, and dashboards supporting Portfolio Analytics, Investments, and related business functions.

· Build visually compelling and decision-driven reports leveraging best practices in data storytelling and the "Call to Action" framework (Takeaway, Insight, Implication, and Action).

· Lead the technical design and implementation of Power BI solutions from requirements gathering through deployment and support.

· Optimize and troubleshoot complex Power BI reports, semantic models, DAX calculations, refresh processes, and overall report performance.

· Develop and maintain reusable semantic models and certified enterprise datasets to promote consistency across reporting solutions.

· Support production incidents, investigate root causes, and implement preventative improvements.

· Establish and promote BI engineering standards, best practices, and governance processes across reporting solutions.

· Apply Power BI development best practices including data modeling, performance tuning, security design, report usability, and governance standards.

· Build strong relationships with investment teams and business stakeholders to understand evolving analytical needs.

· Communicate technical concepts and analytical insights clearly to both technical and non-technical audiences.

· Create Power BI dashboards from scratch and present solutions directly to business stakeholders.

· Optimize and support existing reporting platforms and analytics solutions.

· Support Portfolio Analytics, Investments, and Capital Markets reporting initiatives.

What You'll Need to Succeed

· 5+ years of hands-on experience designing, developing, and supporting Power BI solutions in an enterprise environment.

· Bachelor’s degree in Computer Science, Data Analytics, Information Technology, Engineering, or a related discipline (or equivalent experience).

· Expert-level Power BI development experience including Power BI Desktop, Power BI Service, Power Query (M), DAX, Semantic Modeling, and Data Visualization Best Practices.

· Experience troubleshooting and optimizing complex Power BI solutions involving large data volumes and complex business logic.

· Experience with GitHub-based source control and CI/CD deployment practices for Power BI assets.

· Experience partnering with business stakeholders to deliver reporting and analytics solutions that drive business outcomes.

· Strong analytical and problem-solving skills with the ability to investigate and resolve complex technical issues independently.

· Experience supporting Investments, Portfolio Analytics, Asset Management, Capital Markets, Risk, Finance, or similar analytical domains.

· Ability to understand investment and portfolio management data concepts and translate business requirements into reporting solutions.

· Experience managing multiple initiatives simultaneously while balancing competing priorities.

· Strong communication skills with the ability to present technical solutions to senior business stakeholders.

· Hands-on experience with Microsoft Fabric and Power BI.

· Experience with Capital Markets data.

· Experience with Azure Data Factory, Databricks, Snowflake, Synapse Analytics, and SQL.

· Some level of Data Engineering experience is required.

Preferred Skills & Experience

· Experience implementing AI-enabled analytics capabilities within Power BI and Microsoft Fabric.

· Familiarity with Power BI Copilot, AI Instructions, Verified Answers, and semantic model optimization for AI-enabled experiences.

· Experience with Azure Data Factory, Databricks, Snowflake, Synapse Analytics, or similar modern data platforms.

· Familiarity with Microsoft Fabric Data Agents, Copilot Studio, Azure AI Foundry, or agentic analytics frameworks.

· Copilot Studio familiarity is considered an asset.

What You'll Get in Return

You will have the opportunity to join a Business Intelligence team focused on delivering analytics products that support Portfolio Analytics, Investments, Capital Markets, and related business functions. This role offers exposure to enterprise-scale analytics initiatives, senior business stakeholders, modern Microsoft analytics technologies, and the opportunity to contribute to AI-enabled analytics solutions within a highly collaborative environment.

What You Need to Do Now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.

Interview Process:

• Round 1: 90-minute In-Person Technical Interview
• Round 2: 30-minute In-Person Interview with Director

This posting is for an existing vacancy with the organization.

AI may be used to screen, assess or select applicants for the position.