Senior BI Developer/ Data Analyst
- Toronto, ON, Canada
Pay Rate: $93.63/hr - $108.22/hr · Full-time
Applications open in a new tab.
Job details
- Pay
- Pay Rate: $93.63/hr - $108.22/hr
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
- Location: Toronto, ON - Hybrid (Monday First Friday)
- Pay Rate: $93.63/hr - $108.22/hr
- Contract Length: 6 Months with possibility for extension
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.
- 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.
- 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.
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/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com
#FIN24
More about this job
Responsibilities
Design, develop, deploy, and optimize interactive Power BI dashboards and complex paginated reports, using advanced SQL, DAX, Power Query, and report configuration features. Lead BI delivery from requirements through stakeholder sign-off, validate data mappings and reporting outputs, and resolve data quality and reporting issues with business and technical partners.
Requirements
Requires 7–10 years of hands-on BI development experience, advanced Power BI and paginated reporting expertise, and strong SQL, DAX, and Power Query skills. Candidates should also have experience managing reports in Power BI Service and a solid understanding of data models, ETL concepts, and data transformation logic.
Skills
- Power BI
- Power BI Report Builder
- Paginated Reports
- SQL
- DAX
- Power Query
- RDL Expressions
- Data Modeling
- ETL
- Data Transformation
- Data Validation
- Data Reconciliation
- Report Performance Tuning
- Power BI Service
- Data Quality
- Stakeholder Management
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
Keywords
- Power BI
- Power BI Report Builder
- Paginated Reports
- Interactive Dashboards
- SQL
- DAX
- Power Query
- RDL
- Cascading Parameters
- Power BI Service
- Gateways
- Data Modeling
- ETL
- Data Transformation
- Data Extraction
- Data Validation
- Data Reconciliation
- Data Quality
- Reporting
- Performance Tuning
- Source-to-Target Mapping
- Central Reporting Platform
- RDAL
- Financial Services
- Data Governance
- Stakeholder Sign-Off
- Enterprise Reporting