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

• Contract

Company Description

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.

Job Description

Position: RQ07958 - Business Intelligence Specialist - Senior

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 reusable 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 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 packages 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 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 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,

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

Additional Information

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