HM Note: This hybrid role is three (3) days in office
Description:
Responsibilities:
- Supports and nbsp;Clients and nbsp;wideranging and nbsp;business and nbsp;information and nbsp;requirements and nbsp;implementing and nbsp;and and nbsp;supporting and nbsp;business and nbsp;intelligence and nbsp;software and nbsp;solutions
- Develops and nbsp;and and nbsp;supports and nbsp;customized and nbsp;query and nbsp;applications and nbsp;which and nbsp;analyze and nbsp;key and nbsp;business and nbsp;data
- Develops and nbsp;and and nbsp;supports and nbsp;guided and nbsp;analysis and nbsp;and and nbsp;drilldown and nbsp;functionality and nbsp;routine and nbsp;scheduling and nbsp;and and nbsp;notification and nbsp;of and nbsp;report and nbsp;generation and nbsp;and and nbsp;effective and nbsp;implementation and nbsp;of and nbsp;opportunity and nbsp;and and nbsp;keytrend and nbsp;alerts
- Provides and nbsp;Clients and nbsp;with and nbsp;approach and nbsp;options and nbsp;and and nbsp;tools and nbsp;for and nbsp;managing and nbsp;businessrelated and nbsp;data and nbsp;in and nbsp;a and nbsp;manner and nbsp;that and nbsp;assists and nbsp;in and nbsp;quantitative and nbsp;analysis and nbsp;of and nbsp;progress and nbsp;and and nbsp;the and nbsp;relationship and nbsp;between and nbsp;operational and nbsp;actions and nbsp;and and nbsp;their and nbsp;effect and nbsp;on and nbsp;business and nbsp;objectives
- Conduct and nbsp;workshops and nbsp;and and nbsp;requirementsgathering and nbsp;sessions and nbsp;with and nbsp;clients and nbsp;on and nbsp;BI and nbsp; and amp; and nbsp;Data and nbsp;Analytics and nbsp;Initiative
- Conduct and nbsp;data and nbsp;integration and nbsp;data and nbsp;cleansing and nbsp;data and nbsp;modeling and nbsp;and and nbsp;analytics
- Develop and nbsp;feedback and nbsp;processes and nbsp;to and nbsp;fix and nbsp;corrupt and nbsp;data and nbsp;in and nbsp;the and nbsp;source and nbsp;systems
Skills
Experience and Skill Set Requirements
General and nbsp;Skills:
- Experience in using Power BI and other data visualization tools to create reports and dashboards perform data exploration and manage datasets.
- Expertise in designing interactive and visually appealing reports and dashboards using Power BI Desktop including selecting appropriate visualizations and arranging elements for clarity.
- Experience in performing DAX formulas and functions for performing calculations aggregations and custom calculations in Power BI
- Understanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.
- Experience in converting raw data into meaningful information by creating interactive dashboards and reports.
- Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values duplicate meanings and invalid data)
- Expertise in optimizing report and dashboard performance by optimizing queries data models and visualization rendering.
- Understand the development of and nbsp;data extraction transformation and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semistructured files relational and multidimensional data stores)
- Experience and nbsp;with and nbsp;developing and nbsp;monitoring and nbsp;and and nbsp;error and nbsp;notification and nbsp;processes and nbsp;to and nbsp;ensure and nbsp;data and nbsp;is and nbsp;updated and nbsp;as and nbsp;designed.
- Experience and nbsp;with and nbsp;developing and nbsp;automation and nbsp;extraction and nbsp;cleansing and nbsp;and and nbsp;load and nbsp;scripts within Power BI
- Strong analytical and problemsolving abilities to interpret data identify trends and provide actionable insights. The capacity to translate business requirements into data visualization solutionsExperience and nbsp;in and nbsp;process and nbsp;decomposition/mapping and nbsp;and and nbsp;business and nbsp;process and nbsp;re and nbsp;engineering and complex data models using UML.
- Experience and nbsp;in and nbsp;the and nbsp;use and nbsp;of and nbsp;development and nbsp;tools and nbsp;and and nbsp;business and nbsp;reengineering and nbsp;software
- Experience and nbsp;with and nbsp;the and nbsp;Microsoft and nbsp;suite and nbsp;of and nbsp;technology and nbsp;including: and nbsp;Azure and nbsp;Data and nbsp;Factory and nbsp;Azure and nbsp;SQL and nbsp;Database and nbsp;Azure and nbsp;Data and nbsp;Lake and nbsp;and and nbsp;Power and nbsp;BI
- Experience and nbsp;with and nbsp;data and nbsp;modeling and nbsp;and and nbsp;design and nbsp;principles and nbsp;for and nbsp;data and nbsp;marts and nbsp;and and nbsp;data and nbsp;warehouses
Desirable and nbsp;Skills:
- Knowledge and nbsp;and and nbsp;experience and nbsp;in and nbsp;Power BI and SAP BusinessObject Enterprise 4.2 Crystal Report Web Inteligence Report Universe Design Reports as
- Knowledge and understanding of Information Management principles concepts policies and practices
- Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes
- Experience with developing monitoring and error notification processes to ensure data is updated as designed
- Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications
- Extensive experience with conceptual logical and physical data modelling tools like Power Designer and Visio
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
- Knowledge and experience with the Amazon Redshift technology such as S3 data lake ML and amp; analytics services Amazon Athena etc. and nbsp;
Evaluation and nbsp;Criteria
Technical and nbsp;Proficiency and nbsp; and nbsp;40%
- Demonstrates and nbsp;advanced and nbsp;knowledge and nbsp;and and nbsp;expertise and nbsp;in and nbsp;various and nbsp;BI and nbsp;tools and nbsp;and and nbsp;technologies and nbsp;such and nbsp;as and nbsp;data and nbsp;modeling and nbsp;ETL and nbsp;processes and nbsp;data and nbsp;visualization and nbsp;and and nbsp;reporting.
- Experience and nbsp;with and nbsp;the and nbsp;Microsoft and nbsp;suite and nbsp;of and nbsp;technology and nbsp;including: and nbsp;Azure and nbsp;Data and nbsp;Factory and nbsp;Azure and nbsp;SQL and nbsp;Database and nbsp;Azure and nbsp;Data and nbsp;Lake and nbsp;and and nbsp;Power and nbsp;BI
- Expertise in designing interactive and visually appealing reports and dashboards using Power BI Desktop including selecting appropriate visualizations and arranging elements for clarity.
Data and nbsp;Analysis and nbsp;Skills and nbsp; and nbsp;30%
- Exhibits and nbsp;strong and nbsp;data and nbsp;analysis and nbsp;capabilities and nbsp;including and nbsp;data and nbsp;mining and nbsp;data and nbsp;interpretation and nbsp;and and nbsp;the and nbsp;ability and nbsp;to and nbsp;derive and nbsp;meaningful and nbsp;insights and nbsp;to and nbsp;support and nbsp;decisionmaking.
Business and nbsp;Acumen and nbsp; and nbsp;20%
- Understands and nbsp;the and nbsp;organizations and nbsp;goals and nbsp;processes and nbsp;and and nbsp;industry and nbsp;context and nbsp;and and nbsp;can and nbsp;translate and nbsp;business and nbsp;requirements and nbsp;into and nbsp;effective and nbsp;BI and nbsp;solutions and nbsp;that and nbsp;drive and nbsp;strategic and nbsp;outcomes.
Communication and nbsp;Skills and nbsp; and nbsp;10%
- Effectively and nbsp;communicates and nbsp;complex and nbsp;technical and nbsp;concepts and nbsp;to and nbsp;both and nbsp;technical and nbsp;and and nbsp;nontechnical and nbsp;stakeholders and nbsp;and and nbsp;can and nbsp;collaborate and nbsp;with and nbsp;crossfunctional and nbsp;teams and nbsp;to and nbsp;gather and nbsp;requirements and nbsp;and and nbsp;deliver and nbsp;BI and nbsp;solutions.
Must Haves:
- Experience in using Power BI and other data visualization tools to create reports and dashboards perform data exploration and manage datasets.
- Expertise in designing interactive and visually appealing reports and dashboards using Power BI Desktop including selecting appropriate visualizations and arranging elements for clarity.
- Experience in performing DAX formulas and functions for performing calculations aggregations and custom calculations in Power BI
- Understanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.