Rq08930 - Business Intelligence Specialist - Senior
Rubicon Path
RQ08930 - Business Intelligence Specialist - SeniorAbout the jobNote: Candidate needs to be "Onsite" -3 days in a week
As part of the modernization of Social Assistance (SA) reporting platform (Legacy Cognos system), conduct a review of existing data model(s), report model(s) and redesign reporting products to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting.
The SA program area has identified several data and reporting products to support their efforts to modernize service delivery and streamline partnerships with municipalities. As the SA program area continues to develop the operational model implementation and evaluation plans, BIPD needs to establish a modernized, flexible reporting model to support reporting products and requirements. This will result in development of net new data and reporting products, including products to support Service Planning, continuous monitoring of operational indicators and outcome data through the contract cycle. At the same time BIPD needs to address the development of products in the SA reporting backlog, and the rationalization of the current 160+ operational and analytical products in the reporting catalogue.
Purpose:
To integrate, translate and oversee design of business-driven issues and priorities into enterprise-level business intelligence and data analytics solutions, using leading-edge data development approaches, with expertise/knowledge in data modelling, data architecture and infrastructure, data development (including dimensional modelling) as well as reporting (e.G. dashboard) development.
To project-manage (e.G. design, deliver and implement) complex I&IT projects and various agile, business solutions required to meet cross-ministry business intelligence and data analytics activities and priority projects, including leading and supporting enterprise-wide projects that may involve work with other ministries, jurisdictions and the broader public sector.
To work within the ministry's business analytics data warehouse environment, and support efforts to enhance and maintain infrastructure and applications, and providing technical expertise to the development and implementation of various I&IT solutions, while working with CYSSC, ITS and enterprise partners.
To lead data development and maintenance activities that support strategic initiatives and priority projects across the ministry, including the preparation of ad-hoc statistical information and developing research/analytical data for reporting and analytics, while ensuring appropriate data quality, integrity, privacy and security.
SkillsExperience and Skill Set Requirements
Experience:
Experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
Experience in other Microsoft BI stack e.G. SSAS, SSRS, SSIS
Experience with scripting and programming
Experience working with MS SQL Server on premise and within Azure Environment
Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing
Experience with designing and mapping multi-dimensional data models, report models into business insights
Experience building, testing and implementing complex reports, dashboards, and other objects
Experience prototyping to develop business requirements for future implementation
Ability to assist in the requirements gathering, analysis and subsequent developments
Ability to conduct unit tests and assist in test preparations to ensure data integrity
Work closely with Project Manager, UX/UI Designers, Quality Assurance Analysts and other Developers
Experience working within an Agile software development life cycle, e.G. Scrum/Kanban
Understanding of accessibility compliance requirements e.G. AODA, WCAG 2.0
Skills:
Must Have:
3+ years using Power BI software development, including using DAX queries and functions
SQL Server
Oracle
Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
Ability to present technical requirements to the business
Familiarity with accessibility compliance, usability testing e.G. AODA, WCAG 2.0
Nice to Have:
Some knowledge of user interface design and user interaction design is an asset but not required.
Knowledge of Golden Gate is an asset but not required.
Evaluation Criteria
Power BI Development (25%)
Demonstrated experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
Experience in development of data marts in Power BIBuilding data models optimized for business intelligence and analytic functions
Demonstrated experience in Extract, Transform & Load software development and a number of years of practical experience (minimum 8+ years)
Experience in Informatica/SISS and ETL/ELT
Development of pre-defined and ad hoc reports and meet coding and accessibility (WCAG 2.0) requirements
Design Documentation and Analysis Skills (25%)
Demonstrated experience in creating data documentation about algorithms, parameters, models using standard approaches e.G. Functional Design Documents (FDD) & Detailed Design Documents (DDD).
Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises, and reviews
Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
Work with the Client, Designer(s) & Developer(s) assigned to refine/confirm Business Requirements
Analyze and document solution complexity and interdependencies by function / track for purpose of effort and cost estimation.
Conduct research and prototyping of new business intelligence and analytics capabilities to support OPS business requirements
Analyze, Design, Build and Test databases based on business requirements
Analyze, Design, Build and Test Reports, Dashboards and other objects
Design functional test and technical deployment strategies
Database and Cloud Related (20%)
Demonstrated experience with T-SQL Server databases
Experience with Microsoft Azure services such as Power Apps, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.
Knowledge Transfer (5%)
The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
Development of documentation and materials as part of a review and knowledge transfer to other members
Conduct Analysis, Design, Development and execution of specific learning activities that are aligned to Informatica work packages to staff
Development of specific activities as part of a review, watch, do methodology and building block approach which, build on knowledge transfer and skills development from the previous stage with increasing levels of complexity, priority and responsibility and hands on experience
Development and facilitation of classroom based, or virtual instructor demo led sessions for Developers
Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed
Assist in the development of the pre-defined and ad hoc reports and meet the coding and accessibility (WCAG 2.0) requirements
Must Have:
3+ years using Power BI software development, including using DAX queries and functions
SQL Server
Oracle
Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
Ability to present technical requirements to the business
Familiarity with accessibility compliance, usability testing e.G. AODA, WCAG 2.0
Nice to Have:
Some knowledge of user interface design and user interaction design is an asset but not required.
Knowledge of Golden Gate is an asset but not required.
#J-18808-Ljbffr
As part of the modernization of Social Assistance (SA) reporting platform (Legacy Cognos system), conduct a review of existing data model(s), report model(s) and redesign reporting products to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting.
The SA program area has identified several data and reporting products to support their efforts to modernize service delivery and streamline partnerships with municipalities. As the SA program area continues to develop the operational model implementation and evaluation plans, BIPD needs to establish a modernized, flexible reporting model to support reporting products and requirements. This will result in development of net new data and reporting products, including products to support Service Planning, continuous monitoring of operational indicators and outcome data through the contract cycle. At the same time BIPD needs to address the development of products in the SA reporting backlog, and the rationalization of the current 160+ operational and analytical products in the reporting catalogue.
Purpose:
To integrate, translate and oversee design of business-driven issues and priorities into enterprise-level business intelligence and data analytics solutions, using leading-edge data development approaches, with expertise/knowledge in data modelling, data architecture and infrastructure, data development (including dimensional modelling) as well as reporting (e.G. dashboard) development.
To project-manage (e.G. design, deliver and implement) complex I&IT projects and various agile, business solutions required to meet cross-ministry business intelligence and data analytics activities and priority projects, including leading and supporting enterprise-wide projects that may involve work with other ministries, jurisdictions and the broader public sector.
To work within the ministry's business analytics data warehouse environment, and support efforts to enhance and maintain infrastructure and applications, and providing technical expertise to the development and implementation of various I&IT solutions, while working with CYSSC, ITS and enterprise partners.
To lead data development and maintenance activities that support strategic initiatives and priority projects across the ministry, including the preparation of ad-hoc statistical information and developing research/analytical data for reporting and analytics, while ensuring appropriate data quality, integrity, privacy and security.
SkillsExperience and Skill Set Requirements
Experience:
Experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
Experience in other Microsoft BI stack e.G. SSAS, SSRS, SSIS
Experience with scripting and programming
Experience working with MS SQL Server on premise and within Azure Environment
Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing
Experience with designing and mapping multi-dimensional data models, report models into business insights
Experience building, testing and implementing complex reports, dashboards, and other objects
Experience prototyping to develop business requirements for future implementation
Ability to assist in the requirements gathering, analysis and subsequent developments
Ability to conduct unit tests and assist in test preparations to ensure data integrity
Work closely with Project Manager, UX/UI Designers, Quality Assurance Analysts and other Developers
Experience working within an Agile software development life cycle, e.G. Scrum/Kanban
Understanding of accessibility compliance requirements e.G. AODA, WCAG 2.0
Skills:
Must Have:
3+ years using Power BI software development, including using DAX queries and functions
SQL Server
Oracle
Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
Ability to present technical requirements to the business
Familiarity with accessibility compliance, usability testing e.G. AODA, WCAG 2.0
Nice to Have:
Some knowledge of user interface design and user interaction design is an asset but not required.
Knowledge of Golden Gate is an asset but not required.
Evaluation Criteria
Power BI Development (25%)
Demonstrated experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
Experience in development of data marts in Power BIBuilding data models optimized for business intelligence and analytic functions
Demonstrated experience in Extract, Transform & Load software development and a number of years of practical experience (minimum 8+ years)
Experience in Informatica/SISS and ETL/ELT
Development of pre-defined and ad hoc reports and meet coding and accessibility (WCAG 2.0) requirements
Design Documentation and Analysis Skills (25%)
Demonstrated experience in creating data documentation about algorithms, parameters, models using standard approaches e.G. Functional Design Documents (FDD) & Detailed Design Documents (DDD).
Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises, and reviews
Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
Work with the Client, Designer(s) & Developer(s) assigned to refine/confirm Business Requirements
Analyze and document solution complexity and interdependencies by function / track for purpose of effort and cost estimation.
Conduct research and prototyping of new business intelligence and analytics capabilities to support OPS business requirements
Analyze, Design, Build and Test databases based on business requirements
Analyze, Design, Build and Test Reports, Dashboards and other objects
Design functional test and technical deployment strategies
Database and Cloud Related (20%)
Demonstrated experience with T-SQL Server databases
Experience with Microsoft Azure services such as Power Apps, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.
Knowledge Transfer (5%)
The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
Development of documentation and materials as part of a review and knowledge transfer to other members
Conduct Analysis, Design, Development and execution of specific learning activities that are aligned to Informatica work packages to staff
Development of specific activities as part of a review, watch, do methodology and building block approach which, build on knowledge transfer and skills development from the previous stage with increasing levels of complexity, priority and responsibility and hands on experience
Development and facilitation of classroom based, or virtual instructor demo led sessions for Developers
Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed
Assist in the development of the pre-defined and ad hoc reports and meet the coding and accessibility (WCAG 2.0) requirements
Must Have:
3+ years using Power BI software development, including using DAX queries and functions
SQL Server
Oracle
Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
Ability to present technical requirements to the business
Familiarity with accessibility compliance, usability testing e.G. AODA, WCAG 2.0
Nice to Have:
Some knowledge of user interface design and user interaction design is an asset but not required.
Knowledge of Golden Gate is an asset but not required.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Rq08930 - Business Intelligence Specialist - Senior in Winnipeg, MB vacancy
$95 - $100 per hour
Job Role: Business Intelligence Specialist – Senior (OBIEE experience)Location: Toronto, ON/OnsitePosition Type: Contract RoleStart Date2026-02-09End Date2026-12-31The candidate is required to work onsite 5 days a weekIdeal Rate: CAD 95-100/Hr (Depend upon experience)Must Have...SeniorDaily paidContract work- Position Summary The Senior Business Intelligence Specialist plays a critical role in transforming data into actionable business insights that support strategic decision-making across SSRU and Ryan Specialty Canada. This role serves as a key partner to business leaders,...Senior
- ...Business Intelligence Analyst Location: Winnipeg, MB (Onsite) Turning Information into Business Intelligence. Driving Better Decisions.... ...analytical and business-focused role working directly with ODRA's senior leadership team and company owners. The Business Intelligence...SeniorFull timeFor contractors
- Apply OBIEE, Oracle Analytics Cloud, and SQL expertise as a Senior Business Intelligence Specialist supporting the IFIS in Cloud Project. This assignment focuses on Oracle analytics solutions.The senior specialist validates requirements, updates designs, and develops customer...Senior
- RQ09097 - Business Intelligence Specialist - SeniorHybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week. Responsibilities Lead the report conversion activities from BOEXI...SeniorManual laborRemote work2 days per week3 days per week
- RQ06224 - Business Intelligence Specialist - Senior Toronto, ON, CanadaJob Openings RQ06224 - Business Intelligence Specialist - SeniorAbout the job RQ06224 - Business Intelligence Specialist - Senior Experience in business intelligence software development and a number...Senior
- RQ08739 - Business Intelligence Specialist - SeniorJob Openings RQ08739 - Business Intelligence Specialist - Senior About the job RQ08739 - Business Intelligence Specialist - SeniorResponsibilities: Document the new requirements and complete analysis and design document...SeniorFlexible hours
- ...innovation in all areas as we continue to grow our business into the future. Working with us means you’ll be... .... How You’ll Make an Impact As a Senior Technical Analyst, Data Engineering and Business Intelligence, at Fidelity Investments Canada, you will focus on...SeniorWork at officeFlexible hours
$96.9k - $136.8k per year
...Location:Toronto, Ontario, Canada Hours:37.5 Line of Business:Analytics, Insights, & Artificial Intelligence Pay Details:$96,900 - $136,800 CAD TD is... ...Description :Ready to be TD's top business intelligence specialist and to champion a significant and diverse set of...Work from home$75k - $90k per year
EmergiTEL is hiring a Business Intelligence Specialist for our client in the Energy / Nuclear industry. This is a Permanent role. Location: Toronto, OntarioWork Arrangement: Hybrid (1–3 days remote per week)Compensation: $75K to $90K per annum as base...Permanent employment3 days per week1 day per week- RQ09327 - Business Intelligence SpecialistAbout the job RQ09327 - Business Intelligenceh3 Responsibilities Supports Clients wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized...Manual laborWork at office
- RQ08214 - Sr. Business Intelligence Specialist About the job RQ08214 - Sr. Business Intelligence Specialist A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables:Validate business requirements and update...Senior
$76.8k - $115.2k per year
Work Location: Montréal, Quebec, CanadaHours: 37.5Line of Business: Analytics, Insights, & Artificial IntelligencePay Details: $76,800... ...campaigns using HTML and AMPscript.Provide guidance and train specialists on basic SFMC capabilities and deployment best practices.Bring...SeniorWork from home- RQ07952 - Sr. Business Intelligence SpecialistMust Haves: Demonstrates experience working and communicating directly with stakeholders Managing... ...Understanding ministry data challenges and issues BI Specialist mix of Dev and BA – 7+ years Must Haves: Demonstrated...SeniorWeekend work
- RQ07951 - Sr. Business Intelligence SpecialistPosition 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...Senior
- Design modern Business Intelligence solutions for Pet Valu in hybrid Markham, Ontario, using data architecture, ETL, and analytics expertise.As a hands-on Senior Business Intelligence Architect, you will work across source analysis, ETL development, analysis, and reporting...Senior
$94k - $130k per year
...talents are valued, your ideas matter, and your career can grow, we’d love to meet you. About the role:We are seeking a Senior Business Intelligence Analyst. Reporting to the Manager Data Analytics, our ideal candidate is responsible for monitoring, assessing and drawing...SeniorHourly payLong term contractInternshipWork at officeLocal area$73.5k - $116.85k per year
## Senior Analyst, Business IntelligenceApply: Hybrid: Canadian Head Office: Full time: Posted Today: R36167At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90...SeniorFull timeInternshipWork at officeFlexible hours- ...dashboards and data models at McKesson, using SQL to support Pharma Distribution business decisions. This role is within supply chain analytics.As Senior BI Analyst, you will create business intelligence content for McKesson Canada's largest business segment. You will collaborate...Senior
$93k - $110k per year
...growth is supported and your work makes a real impact. The Opportunity Reporting to the Senior Director, Technical Services, the Senior Developer, Business Intelligence plays a vital role in Atlantic's Technical Services Group, bringing expertise to the Power...SeniorFull timeWork at officeLocal areaShift work- Build scalable business intelligence solutions at Konrad using dashboards, data models, and advanced visualization. Partner with clients across custom digital experiences.As a Senior Data Analyst, you design and deliver analytics and reporting solutions that support operational...Senior
- ...Azure solutions, and enterprise analytics for Social Assistance reporting, working onsite three days each week.This senior Business Intelligence Specialist leads data development and maintenance for strategic initiatives and priority projects. You will create new products,...Senior3 days per week
$125.8k per year
...and interactive BI solutions to help small businesses thrive? Then Jobber might be the place for you! We’re looking for a Senior BI engineer to be part of our Data org. Jobber... ...your goals. The team: The Business Intelligence team is responsible for building core data...SeniorLong term contractInternshipWork at officeLocal area- Become a Senior Analyst at Viral Nation, focusing on enhancing marketing strategies through advanced analytics. Maximize campaign... ...with actionable insights. In this critical role within the Business Intelligence team, you will drive marketing strategies using data analysis...Senior
- Shape artificial intelligence solutions in Montreal’s hybrid consulting environment, using Python... ...teams.As an artificial intelligence specialist, you will design, develop, integrate, deploy... ...client transformations. Your work spans business analysis, model development, data...Senior
$110k - $140k per year
...people build meaningful careers while making a positiveimpact on pets and communities.What will you do? A hands-on Senior Architect, Business Intelligence who thrives in a dynamic workenvironment, this role involves working across the entire BI lifecycle, fromsource data...SeniorLong term contractTemporary workInternshipWork from homeFlexible hours- ...opérationnelle et la qualité des livrables.Spécialiste principal(e) en automatisation intelligente - Compétences obligatoires:• Expérience senior (10+ ans) en conception, développement et soutien de solutions d’automatisation d’entreprise avec SS&C Blue Prism.• Expérience...Senior3 days per week
- Turn complex scientific data into actionable intelligence as a Senior Business Intelligence Data Analyst with Sutherland Healthcare Solutions. Work across data, analytics, and business operations.This senior role sits within Sutherland Healthcare Solutions’ Enterprise Data...Senior
- Shape content portfolio strategy through business intelligence, KPI design, and executive storytelling at the globally distributed Coursera and Udemy.As a Senior Content Business Analyst, you will uncover trends across educational content and translate them into decisions. The...Senior
- ...".To learn more about the company, please visit: The opportunityReporting to the Finance Data & AI Lead, we are seeking a Senior Business Intelligence & AI Analyst to advance our data, analytics, automation, and AI capabilities. In this role, you will leverage the WELL Intelligence...SeniorRemote workShift work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Rq08930 - Business Intelligence Specialist - Senior. Be the first to apply!
Related searches
- business intelligence manager Winnipeg, MB
- business intelligence Winnipeg, MB
- spécialiste bi Winnipeg, MB
- senior financial accountant Winnipeg, MB
- senior sales consultant Winnipeg, MB
- senior communications specialist Winnipeg, MB
- senior bookkeeper Winnipeg, MB
- senior system administrator Winnipeg, MB
- senior technical recruiter Winnipeg, MB
- senior director Winnipeg, MB

