RQ09097 - Business Intelligence Specialist - SeniorHybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week.ResponsibilitiesLead the report conversion activities from BOEXI to Power BI reports estimated up to 900 for fiscal yearSupports Clients 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 objectivesConduct workshops and requirements-gathering sessions with clients on BI & Data Analytics InitiativeConduct data integration, data cleansing, data modeling and analyticsDevelop feedback processes to fix corrupt data in the source systemsSkillsExperience and Skill Set RequirementsGeneral SkillsExperience with analyzing data in source systems to identify data cleanliness issues (e.G. missing values, duplicate meanings, and invalid data)Experience with developing feedback processes to fix corrupt data in the source systemsExperience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL)



scriptsExperience with developing monitoring and error notification processes to ensure data is updated as designedExperience with developing automation extraction, cleansing and load scriptsExperience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)Proven troubleshooting and analytical experienceExperience in process decomposition/mapping and business process re-engineering and complex data models using UML.Experience in the use of development tools and business re-engineering softwareExperience in developing enterprise architecture deliverables (e.G. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelinesExperience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BIExperience with data modeling and design principles for data marts and data warehousesKnowledge and experience in developing data analysis applicationsKnowledge and understanding of Information Management principles, concepts, policies and practicesAbility to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processesExperience with developing monitoring and error notification processes to ensure data is updated as designedHands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applicationsExtensive experience with conceptual, logical and physical data modelling tools like Power Designer, and VisioKnowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standardsEvaluation CriteriaTechnical Proficiency - 40%Demonstrates advanced knowledge and expertise in various BI tools and technologies, such as data modeling, ETL processes, data visualization, and reporting.Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BIData Analysis Skills - 30%Exhibits solid data analysis capabilities, including data mining, data interpretation, and the ability to derive meaningful insights to support decision-making.Business Acumen - 20%Understands the organization's goals, processes, and industry context, and can translate business requirements into effective BI solutions that drive strategic outcomes.Communication Skills - 10%Effectively communicates complex technical concepts to both technical and non-technical stakeholders, and can collaborate with cross-functional teams to gather requirements and deliver BI solutions.Must HavesExperience 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 BIUnderstanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.#J-18808-Ljbffr

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