Business Intelligence Developer managing finance processes and data visualization at McCarthy Tétrault. Responsible for developing dashboards and automating reports across multiple platforms.
About the role
- SSRS / Power BI Engineer supporting reporting modernization for a large healthcare organization. Reverse-engineering SSRS to Power BI solutions focusing on dashboards and reports.
Responsibilities
- Analyze and reverse engineer an existing SSRS reporting estate, including RDLs, shared datasets, data sources, subscriptions, and dependencies.
- Extract and document report logic from SSRS, including parameters, expressions, grouping, drill-through behavior, subreports, conditional formatting, and embedded code.
- Translate SSRS datasets and T-SQL logic into Power BI solutions using Power Query, DAX, and optimized data models.
- Rebuild SSRS pixel-perfect reports as Power BI reports and dashboards or as Power BI paginated reports where strict layout fidelity is required.
- Partner with GenAI engineering teams to refine prompts, retrieval context, and guardrails that support accurate conversion of report definitions and business rules.
- Define and implement reporting governance standards, including naming conventions, certified datasets, semantic models, workspace structure, and documentation.
- Implement security and access controls in Power BI, including row-level security, workspace permissions, and data sensitivity labeling.
- Validate functional parity between SSRS and Power BI outputs through reconciliations, golden datasets, automated checks, and stakeholder sign-offs.
- Optimize reporting performance through SQL tuning, data model optimization, aggregation strategies, incremental refresh, and capacity planning.
- Support UAT, training, and adoption through user enablement, report catalogs, release notes, and post-migration stabilization.
Requirements
- 3+ years of hands-on experience developing SSRS reports in enterprise environments.
- Hands-on experience with Power BI, including Power Query, DAX, data modeling, and workspace management.
- Strong proficiency in T-SQL, including complex joins, window functions, CTEs, stored procedures, and performance considerations.
- Deep understanding of SSRS report design concepts, including parameters, expressions, grouping, sorting, drilldown, and formatting.
- Experience working with SQL Server objects such as views, stored procedures, and indexing fundamentals.
- Familiarity with SSRS deployment and operations, including Report Manager or Web Portal, shared data sources, shared datasets, and subscriptions.
- Strong debugging and validation skills to reconcile data, validate outputs, and resolve defects.
- Experience building Power BI paginated reports using Power BI Report Builder.
- Exposure to SSAS (Tabular or Multidimensional) as part of a broader BI ecosystem.
- Experience modernizing or migrating reporting platforms from legacy tools to Power BI.
- Familiarity with data warehouse concepts such as facts, dimensions, and star schemas.
- Exposure to SSIS or other ETL tools.
- Experience with basic automation or scripting for deployments.
- Familiarity with row-level security patterns and audit requirements.
Benefits
- Health insurance
- Professional development opportunities
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
BI Analyst responsible for ETL development and management of dashboards in Power BI at Minsait, driving data insights across various sectors.
Business Intelligence Consultant utilizing market - leading technology to address client analysis and reporting needs. Developing solutions for big data, data flow, and advanced analytics models with AI expertise.
Data & BI Specialist transforming raw data into business insights for marketing and commercial areas. Collaborating on data analysis and automating processes in SQL and Google Sheets.
Data Analytics Engineer supporting development and maintenance of Exasol's data infrastructure and reporting solutions. Collaborating across teams to transform data into actionable insights.
Junior PowerBI Developer responsible for creating advanced data solutions. Joining SDG Group, a global leader in Data & Analytics consulting.
Power BI Consultant at a Canadian technology company delivering high - performance BI solutions. Engage stakeholders, design models, and collaborate with data engineering.
Power BI Engineer contributing to the development of reports and dashboards. Supporting testing activities for a global mining client with a focus on data science and AI.
Senior Business Intelligence Analyst supporting client insights and delivering high - impact analysis at Cox Automotive. Collaborating across teams to drive client success through actionable insights.
Senior BI Developer creating data - driven insights and services for sonnen's clean energy solutions. Collaborating with cross - functional teams to enhance product offerings through data visualization.