Business Intelligence Specialist

OverviewTitle: Business Intelligence SpecialistLocation: Toronto, ONDuration: 12+ MonthsDescriptionRequired Knowledge / Skills:ResponsibilitiesSupports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutionsDevelops and supports customized query applications which analyze key business dataDevelops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alertsProvides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectivesDevelop presentations for various audiences, as requiredWork with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignmentTransfer skills and knowledge to selected OPS staffKnowledge TransferTransfer From Business Intelligence Specialist to Designated CSC ResourceWhen Knowledge Will Be TransferredKnowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministryWhat Knowledge Will Be TransferredAll deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS, etc.)Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.How Knowledge Will Be TransferredKnowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the teamSkillsExperience and Skill Set RequirementsTechnical Skills - 40%Demonstrates business analysis experience in environments where Oracle, Informatica, SSIS, and SQL Server are utilized for data warehousing, ETL processes, and business intelligence solutions.Experience working with data warehouse systems and understanding the design and concepts of data migration across multiple platforms, ensuring seamless integration with Power BI and other BI tools.Demonstrates experience creating complex SQL scripting for data analysis, profiling, and data migration tasks, optimizing queries for large datasets, and ensuring data integrity across platforms (e.g., from Oracle to SQL Server or Cognos to Power BI).Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BIWorking knowledge of the entire Data Dictionary and data mappingWorking knowledge of the Business Process Design Re-engineering for applicationsExperience with analyzing data in source systems to identify data cleanliness issues (E.g., missing values, duplicate meanings, and invalid data)Experience with developing automation extraction, cleansing and load scriptsExperience generating research models and reports (scheduled and ad-hoc)Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reportingExperience working with Oracle Databases (version 10.x or higher), DB2 Database, and SQL Server for data migration and ETL-related tasks, ensuring smooth transitions between systemsDemonstrates strong MS Excel skills, including working knowledge of Power Query, Pivot TablesCore Skills – 30%Experience gathering and eliciting requirements for BI application (Cognos and Power BI) especially in the context of data migration and transitioning to cloud-based or modern BI platformsExperience with systems design and development, and related methods, techniques, practices, and standardsExperience performing the design of data warehouse and related componentsWorking Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projectsExperience Documenting applications designs and specifications, and draft policies and proceduresWorking Knowledge of aggregate reportingTroubleshooting of production issues and creating fixes for any unplanned deploymentsDefect investigation, resolution and assignment to team members using defect/issue management tools, e. g. Microfocus ALMProven troubleshooting and analytical experience, particularly related to resolving issues in data migration or ETL pipelines using SSISExperience in process decomposition/mapping and business process re-engineering and complex data models using UMLExperience in the use of development tools and business re-engineering softwareExperience Designing and developing enterprise-wide data analysis and reporting solutionsExperience reviewing and analyzing data from multiple internal and external sourcesAbility to communicate analysis results and making recommendations to senior managementAbility to use BI tools and data models effectively to help visualize or monitor dataProven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).Communication Skills - 20%Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specificationsAnalytical and problem-solving skills to assess clients\' business priorities and needs; to evaluate business and technical design alternativesExceptional organization and presentation skillsGood written, verbal, and interpersonal skillsProject Management Skills – 10%Experience in the development of various deliverables of various roles including, but not limited to, project coordinator, release management, requirements analyst, system designer, system tester, trainer, etc. throughout SDLCMust HaveMUST HAVE:Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutionsDemonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BIDemonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting Experience in ETL processes, particularly as it relates to migrating data into Power BI-compatible formats. Familiarity with ETL tools (e.g., SSIS, Informatica) #J-18808-Ljbffr