Senior BI Developer / Data Analyst (7–10 years)
First seen by Alion on Nov 6, 2026.
Our financial services client is seeking a Senior BI Developer / Data Analyst (7–10 years) to deliver Power BI paginated reports and interactive dashboards using Power BI Report Builder, SQL, and DAX
Join a strategic reporting transformation within a Risk Intelligence Office, where back-end data changes are reshaping enterprise reporting. This role updates and develops Power BI solutions, authors data transformation mappings, validates data via advanced SQL, and supports integration into the central reporting platform, RDAL. Expect hands-on ownership of complex paginated reports and interactive dashboards with end-to-end BI delivery across requirements, development, testing, deployment, and stakeholder sign-off. The engagement offers strong visibility with technology partners and stakeholders, with potential for extension based on project needs.
Contract, Hybrid Monday First Friday
81 Bay Street
6 months
Must Haves:
7-10 years of hands-on BI development experience, including responsibility for complex enterprise reporting solutions.
Advanced Power BI development experience, including interactive dashboards and reports.
Advanced experience with Power BI Report Builder and paginated reports, including complex parameters, grouping, page breaks, visibility rules, RDL expressions, scope arguments, and pixel-perfect formatting.
Advanced SQL skills for complex querying, data extraction, transformation validation, reconciliation, troubleshooting, and reporting.
Advanced DAX and Power Query experience.
Experience deploying and managing reports in Power BI Service, including gateways and report performance troubleshooting.
Demonstrated understanding of data models, ETL concepts, and data transformation logic.
Nice to Have:
Previous experience supporting enterprise-scale data or reporting transformation initiatives.
Experience integrating reporting data from multiple source systems.
Experience working with centralized reporting or analytical data platforms such as RDAL.
Experience in financial services or another highly governed enterprise environment.
Familiarity with data governance, controls, reconciliation, and reporting-quality practices.
- Experience working closely with separate data-modelling and ETL development teams.
Responsibilities
- Design and develop complex static and paginated reports using Power BI Report Builder
- Develop interactive Power BI dashboards using advanced functionality
- Implement cascading report parameters mapped to source SQL queries
- Create custom RDL expressions, including expressions that use scope arguments
- Manage paginated reports in Power BI Service, including gateway assignment and configuration
- Use advanced SQL for data extraction, transformation validation, reconciliation, and reporting support
- Create and maintain mapping documents defining data transformation logic, source-to-target relationships, calculations, and reporting definitions
AI may be used in evaluating candidates.
This posting is for an existing vacancy.