RQ10262 - Business Intelligence Specialist - Senior

Job DescriptionExperience: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.0RequirementsExperience and Skill Set Requirements:Must Haves:3+ years using Power BI software development, including using DAX queries and functionsMicrosoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.SQL ServerOracleAbility to translate wireframes, lo-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.0 Skill Set Requirements:Skills:Must Have:3+ years using Power BI software development, including using DAX queries and functionsMicrosoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.SQL ServerOracleAbility to translate wireframes, lo-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. Power BI Development: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 Data Injection: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/ELTDevelopment of pre-defined and ad hoc reports and meet coding and accessibility (WCAG 2.0) requirements Design Documentation and Analysis Skills: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 strategies Database and Cloud Related: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 Transfer: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 membersConduct Analysis, Design, Development and execution of specific learning activities that are aligned to Informatica work packages to staffDevelopment 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 experienceDevelopment and facilitation of classroom based, or virtual instructor demo led sessions for DevelopersMonitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completedAssist in the development of the pre-defined and ad hoc reports and meet the coding and accessibility (WCAG 2.0) requirementsRequirementsExperience and Skill Set Requirements: Must Haves: 3+ years using Power BI software development, including using DAX queries and functions Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc. SQL Server Oracle Ability to translate wireframes, lo-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 Skill Set Requirements: Skills: Must Have: 3+ years using Power BI software development, including using DAX queries and functions Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc. SQL Server Oracle Ability to translate wireframes, lo-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. Power BI Development: 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 BI Building data models optimized for business intelligence and analytic functions Data Injection: 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: 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: 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: 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