RQ07254 - Business Intelligence Specialist - Senior

Responsibilities :

• SupportsClient s wideranging business information requirements implementingand supporting business intelligence softwaresolutions
• Developsand supports customized query applications which analyze keybusinessdata
• Developsand supports guided analysis and drilldown functionality routinescheduling and notification of report generation and effectiveimplementation of opportunity and keytrendalerts
• ProvidesClients with approach options and tools for managingbusinessrelated data in a manner that assists in quantitativeanalysis of progress and the relationship between operationalactions and their effect on businessobjectives
• Conductworkshops and requirementsgathering sessions with clients on BI& Data AnalyticsInitiative
• Conductdata integration data cleansing data modeling andanalytics
• Developfeedback processes to fix corrupt data in the sourcesystems

Requirements

Experienceand Skill SetRequirements

MustHaves :

• Experiencein using Power BI and other data visualization tools to createreports and dashboards perform data exploration and managedatasets.
• Expertisein designing interactive and visually appealing reports anddashboards using Power BI Desktop including selecting appropriatevisualizations and arranging elements forclarity.
• Experiencein performing DAX formulas and functions for performingcalculations aggregations and custom calculations in PowerBI
• Understandingof good UI design in delivering rich user experience by creatingcustom visuals and themes in Power BI to enhance report aestheticsandfunctionality.

GeneralSkills :

• Experiencein using Power BI and other data visualization tools to createreports and dashboards perform data exploration and managedatasets.
• Expertisein designing interactive and visually appealing reports anddashboards using Power BI Desktop including selecting appropriatevisualizations and arranging elements forclarity.
• Experiencein performing DAX formulas and functions for performingcalculations aggregations and custom calculations in PowerBI
• Understandingof good UI design in delivering rich user experience by creatingcustom visuals and themes in Power BI to enhance report aestheticsandfunctionality.
• Experiencein converting raw data into meaningful information by creatinginteractive dashboards andreports.
• Experiencewith analyzing data in source systems to identify data cleanlinessissues (e.g. missing values duplicate meanings and invaliddata)
• Expertisein optimizing report and dashboard performance by optimizingqueries data models and visualizationrendering.
• Understandthe development of data extraction transformation and load programs(daily and initial load) functionality on a wide range of datarepositories (structured and semistructured files relational andmultidimensional datastores)
• Experiencewith developing monitoring and error notification processes toensure data is updated asdesigned.
• Experiencewith developing automation extraction cleansing and load scriptswithin PowerBI
• Stronganalytical and problemsolving abilities to interpret data identifytrends and provide actionable insights. The capacity to translatebusiness requirements into data visualization solutionsExperiencein process decomposition / mapping and business processre engineering and complex datamodels usingUML.
• Experiencein the use of development tools and business reengineeringsoftware
• Experiencewith the Microsoft suite of technology including : Azure DataFactory Azure SQL Database Azure Data Lake and PowerBI
• Experiencewith data modeling and design principles for data marts and datawarehouses

DesirableSkills :

• Knowledgeand experience in Power BI and SAP BusinessObject Enterprise 4.2Crystal Report Web Inteligence Report Universe Design Reportsas
• Knowledgeand understanding of Information Management principles conceptspolicies andpractices
• Abilityto provide expert advice in developing and integrating process andinformation models to enable identifying and eliminating redundantbusinessprocesses
• Experiencewith developing monitoring and error notification processes toensure data is updated asdesigned
• Handson experience working with stakeholders to develop and documentinterface specifications design between Business Intelligencesolutions and externalapplications
• Extensiveexperience with conceptual logical and physical data modellingtools like Power Designer andVisio
• Knowledgeand understanding of Accessibility for Ontarians with DisabilityAct (AODA) and related regulations andstandards
• Knowledgeand experience with the Amazon Redshift technology such as S3 datalake ML & analytics services Amazon Athena etc.
7 hours ago