Power Platform and Data Visualization Specialist

Buchanan Technologies is hiring for Power Platform and Data Visualization Specialist for one of our clients based at Toronto, Ontario.

Job Type: Hybrid.

Location: Toronto

Contract Length: 12 months.

Reporting to the Director, Business Solutions and Data Services, the Power Platform and Data Visualization Specialist will continuously evaluate reporting system needs, and design, develop, streamline and automate reporting processes. The Specialist will work across all business departments, source systems owners and support vendors to ensure that current applications meet the service levels. This includes evaluating existing reporting, analytics and BI platforms, and coming up with recommendations and migration plan based on company requirements and business growth

Job Responsibilities:

• Conducts business analysis at varying levels of projects and phases of project to assess clients' business problems or opportunities; document the business requirements that makes sense to both Business and IT.
• Perform day-to-day tracking, reporting, and facilitation of issue resolution and risks for all data service applications.
• Ensure defined Change Management Process is followed for any change from agreed upon scope, schedule, or quality.
• Provide technical support on the platform and data management processes related to solution architecture and incoming and outgoing data integration.
• Develop and modify the infrastructure and architecture of the platform, from model management to data integration.
• Advise and provide support to data managers, other system owners and to the database management technical staff.
• Work with Application support vendors, users, and source system experts to establish data governance, and resolve any data quality issues or technical problems related to data integration.
• Create test strategies and test plans to ensure data integrity, accuracy and completeness.
  • Coordinate and participate in discussions with the business and Solution Architect regarding any changes required to business and/or system requirements.
  • Assist project leads with project issues and risk, milestone tracking, work coordination, etc.
  • Bachelor’s degree in Computer Science, Information Systems, or related degree.
  • Minimum of 10 years Business Intelligence Solution Design experience in a multi-platform IT environment and in business process improvement.
  • Expert in Advanced Analytics - Power BI / Data Visualization / UI/UX design
  • Expert MS Data Platform: SSIS, SSAS, SSRS / SharePoint / Power APP / Power Automate
  • Expert in SQL Server Database including Stored Procedures, Functions, and optimizing execution plans
  • Solid experience Building and maintaining Data Warehouse / Tabular Models / Cube
  • Solid experience MS Excel including Macros and VB scripts.
  • Solid understanding of Kimball’s Data Warehousing architecture
  • Experience in supporting and managing other Business applications.
  • Excellent analytical and problem-solving skills.
  • In depth knowledge of everything related to data, data profiling, and data integration.
  • Experience in vendor management and fostering effective partnerships with vendors.
  • Excellent interpersonal, written and verbal communication skills; ability to determine client needs and explain technical concepts to non-technical and technical audiences.

Qualification Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or related degree.
• Minimum of 10 years Business Intelligence Solution Design experience in a multi-platform IT environment and in business process improvement.
• Expert in Advanced Analytics - Power BI / Data Visualization / UI/UX design
• Expert MS Data Platform: SSIS, SSAS, SSRS / SharePoint / Power APP / Power Automate
• Expert in SQL Server Database including Stored Procedures, Functions, and optimizing execution plans
• Solid experience Building and maintaining Data Warehouse / Tabular Models / Cube
• Solid experience MS Excel including Macros and VB scripts.
• Solid understanding of Kimball’s Data Warehousing architecture
• Experience in supporting and managing other Business applications.
• Excellent analytical and problem-solving skills.
• In depth knowledge of everything related to data, data profiling, and data integration.
• Experience in vendor management and fostering effective partnerships with vendors.
• Excellent interpersonal, written and verbal communication skills; ability to determine client needs and explain technical concepts to non-technical and technical audiences.