Senior BI Developer / Data Analyst - DAX and Power QueryLocation: Toronto, ON
Onsite Flexibility: Hybrid - Monday and first Friday on-site
Contract Details- Position Type: Contract
- Contract Duration: 6 months (with potential for extension)
- Pay Rate: C$85.00–C$100.00 / Hour (CAD)
- Shift / Schedule: 9:00 AM – 5:00 PM, 37.5 hours per week
Job SummaryThe Senior BI Developer will design and develop complex static and paginated reports using Power BI Report Builder, along with interactive Power BI dashboards. This individual will support the MPL Strategic project, where changes to back-end data sourcing and structures are creating significant reporting impacts. The successful candidate will provide end-to-end BI development support, including requirements gathering, report design, SQL development, data transformation mapping, testing, deployment, troubleshooting, and stakeholder sign-off. The role requires advanced Power BI and SQL expertise, strong knowledge of DAX and Power Query, and an understanding of data models and ETL concepts.
The contractor will collaborate with technology and data partners who own the underlying data models and ETL implementation. While this individual will not be expected to build data models or ETL pipelines directly, they must be able to understand transformation requirements, prepare detailed data mapping documentation, and use SQL to verify that the defined mappings and transformations work correctly. Python is not required for this role.
Key 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 Requirements- 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 Requirements- 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.
Required Skills- Strong analytical and problem-solving skills.
- High attention to detail, particularly when developing pixel-perfect reports and validating data.
- Clear written and verbal communication skills.
- Ability to translate business reporting requirements into technical reporting solutions.
- Strong documentation skills, particularly for data mappings, transformation rules, and reporting definitions.
- Ability to work independently and take ownership of deliverables.
- Collaborative approach when working with business stakeholders, project managers, technology partners, and data teams.
Important Notes- Interview process: 1 interview (virtual via MS Teams) with the Hiring Manager and Senior Leadership, approximately 1 hour in duration. A SQL test may be required; a possible second round may occur if candidates are closely matched.
About the ClientThis client is a large, full-service multinational financial services and banking institution offering a comprehensive range of banking, wealth management, and capital markets products and services to individuals, businesses, and institutional clients. It serves millions of clients across its home market and operates internationally, with significant commercial and investment banking presence in the United States and other global markets. The organization employs professionals across technology, risk intelligence, data and analytics, capital markets, and enterprise programs functions, and is recognized for its collaborative culture, structured career development frameworks, and meaningful commitments to inclusion and diversity.
About GTTGTT is an NMSDC-certified Minority Business Enterprise (MBE) headquartered in Portsmouth, New Hampshire. GTT is a subsidiary of Chenega Corporation, an Alaska-based company and one of the largest Alaska Native-owned corporations. An Inc. 5000 honoree and one of SIA's Best Staffing Firms to Work For, GTT connects professionals with Fortune 500 organizations across IT, engineering, construction, utilities, life sciences, financial services, and healthcare throughout the U.S. and Canada. We're committed to diverse, inclusive workplaces and to placing people in roles where they can do their best work.
Job Number: 26-18624 Industry: Software Engineering
