Business Intelligence Specialist – Senior (ETL,Strong Azure Expertise,ADF,SQL)

Arthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years. 

We are a minority owned staff augmentation and technology consulting company
To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.

Position: RQ07958 - Business Intelligence Specialist - Senior

Location: 777 Bay Street, Toronto, Ontario (Hybrid)

Hybrid - 3 days on site and 2 remote

Duration: Long Term Contract

Rate: CAD 700-800/Day

Client: Flextrack (Ontario Public Service) / Ministry of Education

Last date for submission: 6th January

Must Haves:

7+ years - BI Development

• Demonstrates experience with designing and developing using the Microsoft suite of BI tools (SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, Power BI) 
• Demonstrates design and development experience as a BI Programmer/ Developer 
• Demonstrates experience developing and using re-usable components to assist with BI processes, and providing detailed documentation for the tools that are developed Demonstrates experience with developing, debugging and enhancing the performance of complex SQL queries 
• Demonstrates experience designing and developing solutions on Microsoft Azure or other cloud infrastructure and services 

Experience and Skill Set Requirements

Technical Skills - 35% 

• Demonstrates experience with designing and developing using the Microsoft suite of BI tools (SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, Power BI) 
• Demonstrates design and development experience as a BI Programmer/ Developer 
• Developing cubes, reports and dashboards using SSAS and SSRS and Power BI 
• Demonstrates experience with documenting code changes 
• Demonstrates experience developing and using re-usable components to assist with BI processes, and providing detailed documentation for the tools that are developed Demonstrates experience with developing, debugging and enhancing the performance of complex SQL queries 
• Demonstrates experience working with SQL Server (2016 or later) / Azure SQL Database, Oracle (11 x and higher) 
• Demonstrates experience with enhancing the performance of SQL Queries 
• Demonstrates experience developing for WCAG AA compliance in web and reporting applications 
• Demonstrates experience working Azure Active Directory, Auth0 or other single sign on token-based authentication solutions 
• Demonstrates experience designing and developing solutions on Microsoft Azure or other cloud infrastructure and services 

Core Skills - 35% 

• Demonstrates experience working with aggregate reporting 
• Demonstrates experience in analyzing and planning for the modernization of large, complex, multiplatform, multi- tier information technology systems 
• Demonstrates experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources 
• Demonstrates experience developing application code package using TFS (Team Foundation Server) and/or Azure DevOps 
• Demonstrates experience implementing star schema multi-dimensional models and documenting detailed design models 

Project, Technique experience and General Skills - 20% 

• Demonstrates experience working in an Agile and Waterfall environment 
• Demonstrates experience with Software Development Life Cycle (SDLC) 
• Demonstrates experience with performing testing: Unit, SIT, SAT, UAT 
• Demonstrates experience working collaboratively with other team members and/or groups to ensure optimal solution integration 
• Demonstrates experience with documenting, consulting and presenting for a diverse audience of stakeholders (both technical and non-technical) 
• Demonstrates experience with the Software Development Life Cycle (SDLC) 
• Demonstrates experience with performing testing and unit testing, and conducting SIT, SAT and UAT Testing 
• Demonstrates experience leading business users to the successful completion of an assignment of this nature, magnitude, and complexity 
• Demonstrates experience problem solving and decision making 
• Demonstrates experience communicating clearly in both written and verbal formats 
• Demonstrates experience working in an agile and waterfall environment 
• Demonstrates experience working collaboratively with client organizations 
• Demonstrates experience working with multiple teams representing various areas in delivering the project 
• Demonstrates experience coordinating multiple projects with competing priorities 

Public Sector Experience - 10% 

• Demonstrates experience working within the OPS, particularly within the education ministries would be an asset 
• Demonstrates experience developing applications that comply with GO- ITS standards would be an asset 

Thanks,

Afrah Faiza

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

All your information will be kept confidential according to EEO guidelines.