RQ08930 - Business Intelligence Specialist - SeniorAbout the jobNote: Candidate needs to be "Onsite" -3 days in a weekAs 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 adaptable 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⁢ 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⁢ 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 RequirementsExperience: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, SSISExperience with scripting and programmingExperience working with MS SQL Server on premise and within Azure EnvironmentExperience with data-specific tasks including database management, SQL querying, data modelling, online analytical processingExperience with designing and mapping multi-dimensional data models, report models into business insightsExperience building, testing and implementing complex reports, dashboards, and other objectsExperience prototyping to develop business requirements for future implementationAbility to assist in the requirements gathering, analysis and subsequent developmentsAbility to conduct unit tests and assist in test preparations to ensure data integrityWork closely with Project Manager, UX/UI Designers, Quality Assurance Analysts and other DevelopersExperience working within an Agile software development life cycle, e.G. Scrum/KanbanUnderstanding of accessibility compliance requirements e.G. AODA, WCAG 2.0Skills:Must Have:3+ years using Power BI software development, including using DAX queries and functionsSQL ServerOracleAbility to translate wireframes,



low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboardsAbility to present technical requirements to the businessFamiliarity with accessibility compliance, usability testing e.G. AODA, WCAG 2.0Nice 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 CriteriaPower 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 functionsDemonstrated experience in Extract, Transform & Load software development and a number of years of practical experience (minimum 8+ years)Experience in Informatica/SISS and ETL/ELTDevelopment of pre-defined and ad hoc reports and meet coding and accessibility (WCAG 2.0) requirementsDesign 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 reviewsExperience 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 RequirementsAnalyze 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 requirementsAnalyze, Design, Build and Test databases based on business requirementsAnalyze, Design, Build and Test Reports, Dashboards and other objectsDesign functional test and technical deployment strategiesDatabase and Cloud Related (20%)Demonstrated experience with T-SQL Server databasesExperience with Microsoft Azure services such as Power Apps, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.Knowledge

📌 Rq08930 - Business Intelligence Specialist - Senior (Toronto)
🏢 Rubicon Path
📍 Toronto