At a Glance
- Tasks: Deliver advanced BI solutions and support diverse clients with data management and analytics.
- Company: Join a leading organization focused on innovative business intelligence solutions.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous learning and development.
- Why this job: Make an impact by transforming data into actionable insights for various sectors.
- Qualifications: 10+ years in analytics, strong communication skills, and expertise in BI tools.
The predicted salary is between 103500 - 126500 $ per year.
Position responsible for delivering and supporting advanced business intelligence (BI) solutions to a broad client portfolio. The role requires deep expertise in data management, analytics, and stakeholder engagement across diverse public sector and private sector environments.
Key Responsibilities
- Implement, support and maintain BI software solutions (Power BI, Tableau, R, Python), including custom dashboard and reporting packages.
- Design, develop and sustain data extraction, transformation and load (ETL) pipelines, schedule/dependency logic, and monitoring/alert mechanisms for data quality and integrity.
- Build and maintain query applications, guided analysis features and drill‑down functionality to enable users to explore key business metrics.
- Collaborate with stakeholders to document interface specifications, integrating BI solutions with external applications and data sources.
- Lead training sessions and workshops for business users, covering analytics tools, data modeling best practices, and advanced statistical techniques.
- Participate in project management activities, including detailed planning, risk assessment, proof‑of‑concepts, and knowledge transfer activities to ensure sustainable delivery.
Required Skills & Experience
- 10+ years in analytics, BI or database design (SQL Server, Oracle).
- Extensive experience with data modeling (conceptual, logical, physical) and large data environments.
- Proficiency in advanced analytics and statistical modelling (econometrics, regression, machine learning) and tools such as R, SAS, SPSS.
- Proven track record managing ETL development, automation, error‑notification and schedule management.
- Excellent communication skills, able to translate technical findings to non‑technical audiences and coordinate across multiple teams.
- Experience ensuring data quality, developing feedback loops for data cleansing, and documenting architectural artifacts.
- Knowledge of public sector data governance, accessibility standards (AODA) and government IT standards.
- Strong consulting and relationship‑management skills, with demonstrable success in eliciting requirements and delivering guidance.
- Familiarity with analytics platforms such as Power BI, Tableau, R Shiny and BI road‑mapping tools.
- Document management and version control experience using SharePoint, TFS, or equivalent.
Nice to Have
- Advanced data visualization or modeling tools (Power Designer, Visio, Google Analytics).
- Public sector or engineering background with experience on government platforms.
- Familiarity with R Shiny or Power BI Server requirement.
Knowledge Transfer
- Transfer all deliverables, design documents and training materials to the designated project repository one week prior to project completion or consultant departure.
- Conduct at least one walkthrough of documentation with project managers and ministry staff.
Sr. Business Intelligence Specialist in Toronto employer: Rubicon Path
As a Systems Testing/QA Specialist at our Toronto location, you will thrive in a collaborative and innovative work culture that prioritizes quality and continuous improvement. We offer competitive benefits, opportunities for professional growth, and a commitment to work-life balance, ensuring that you can excel in your role while contributing to meaningful projects that impact the community. Join us to be part of a dynamic team dedicated to delivering high-quality solutions in a supportive environment.
