Senior BI Developer/ Data Analyst

Ian Martin Group; Toronto; Híbrido; CAD 129.000 - 149.000; Jornada completa

Descripción de la vacante

The Ian Martin Group is seeking a Senior BI Developer/Data Analyst in Toronto, hybrid role (Mondays on-site, rest remote). You will design and build complex Power BI reports and interactive dashboards, implement paginated reports, optimize data models, and collaborate across teams to deliver trusted insights.

Ideal candidates have 7-10 years in BI, advanced Power BI, SQL, DAX, and Power Query, with experience in data governance and enterprise reporting platforms.

Formación

• 7–10 years of hands-on BI development experience.
• Advanced Power BI development experience with interactive dashboards.
• Expertise in Power BI Report Builder and paginated reports.
• Advanced SQL skills for data extraction, transformation and validation.
• Advanced DAX and Power Query experience.
• Experience deploying and managing reports in Power BI Service with gateways.

Responsabilidades

• Design and develop complex static and paginated reports using Power BI Report Builder.
• Develop interactive Power BI dashboards using advanced Power BI functionality.
• Implement cascading report parameters mapped to source SQL queries.
• Define report grouping, page breaks, and visibility-control properties.
• Design pixel-perfect report layouts and create RDL expressions.
• Manage paginated reports in Power BI Service and gateway configuration.
• Tune performance and troubleshoot reporting issues.
• Use SQL for data extraction, transformation and reporting support.
• Develop DAX calculations and Power Query transformations.
• Lead BI delivery from requirements gathering through stakeholder sign-off.
• Collaborate to integrate data from multiple sources into RDAL.
• Create data transformation mapping documents and data models reviews.

Conocimientos

Enterprise data experience

RDAL familiarity

Data governance

BI delivery leadership

Herramientas

Power BI Report Builder

Power BI Service

SQL

DAX

Power Query

RDL expressions

Descripción del empleo

Senior BI Developer/ Data Analyst

• Location: Toronto, ON - Hybrid (Monday First Friday)
• Pay Rate: $93.63/hr - $108.22/hr
• Contract Length: 6 Months with possibility for extension

We at Raise are hiring a Senior BI Developer/ Data Analyst for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.

Responsibilities:

• Design and develop complex static and paginated reports using Power BI Report Builder.
• Develop interactive Power BI dashboards using advanced Power BI functionality.
• Implement cascading report parameters mapped to source SQL queries.
• Define report grouping, repeating sections, page breaks, and visibility-control properties.
• Design precise, pixel-perfect report layouts.
• Create custom RDL expressions, including expressions that use scope arguments.
• Manage paginated reports in Power BI Service, including gateway assignment and configuration.
• Tune the performance of paginated reports and troubleshoot reporting issues.
• Use advanced SQL for data extraction, transformation, validation, reconciliation, and reporting support.
• Develop advanced DAX calculations and Power Query transformations.
• Lead BI delivery from requirements gathering through design, development, testing, deployment, and stakeholder sign-off.
• Collaborate with technology partners to integrate information from multiple sources into the central reporting platform, RDAL.
• Create and maintain mapping documents that define data transformation logic, source-to-target relationships, calculations, and reporting definitions.
• Review data models and transformation requirements to ensure reporting solutions are developed correctly.
• Use SQL to validate transformation mappings and confirm that reporting outputs align with documented requirements.
• Maintain strong data quality, integrity, accuracy, and consistency across all reporting outputs.
• Work closely with business and technical stakeholders to investigate data discrepancies and resolve reporting issues.

Must Have Requirement:

• 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 Skills:

• 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.

Looking for meaningful work? We can help!

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/