Business Intelligence Specialist - Toronto, Canada - Arthur Grand Technologies Inc

Arthur Grand Technologies Inc

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Position:
Business Intelligence Specialist (Cognos 10,Microsoft Power BI)

Location:
Toronto, Ontario (Hybrid)

Duration:
Long Term Contract

MUST HAVES:

Supports Client's wideranging business information requirements, implementing and supporting business intelligence software solutions.

Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.

Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting.

Experience and Skill Set Requirements

Technical Skills - 40%

Demonstrates business analysis experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
Experience working with data warehouse systems and understanding the design and concepts of it.
Demonstrates experience creating complex SQL scripting for data analysis and profiling
Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
Working knowledge of the entire Data Dictionary and data mapping
Experience with analyzing data in source systems to identify data cleanliness issues (E.g., missing values, duplicate meanings, and invalid data)
Experience with developing automation extraction, cleansing and load scripts
Experience generating research models and reports (scheduled and adhoc)
Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting
Experience working with Oracle Databases (version 10.x or higher), DB2 Database.
Demonstrates strong MS Excel skills, including working knowledge of Power Query, Pivot Tables

Core Skills - 30%

Experience with systems design and development, and related methods, techniques, practices, and standards.
Experience performing the design of data warehouse and related components.
Working Knowledge of aggregate reporting.
Troubleshooting of production issues and creating fixes for any unplanned deployments.
Defect investigation, resolution and assignment to team members using defect/issue management tools, e. g. Microfocus ALM.
Proven troubleshooting and analytical experience
Experience in process decomposition/mapping and business process reengineering and complex data models using UML.
Experience in the use of development tools and business reengineering software
Experience Designing and developing enterprisewide data analysis and reporting solutions
Experience reviewing and analyzing data from multiple internal and external sources
Ability to communicate analysis results and making recommendations to senior management
Ability to use BI tools and data models effectively to help visualize or monitor data
Proven experience using a variety of methodologies to carryout the software development lifecycle (e.g., Agile, waterfall, etc.).

Communication Skills - 20%

Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
Analytical and problemsolving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.
Exceptional organization and presentation skills
Good written, verbal, and interpersonal skills

Project Management Skills - 10%

Experience in the development of various deliverables of various roles including, but not limited to, project coordinator, release management, requirements analyst, system designer, system tester, trainer, etc.

throughout SDLC

Job Type:
Contract

Salary:
From $50.00 per hour

Schedule: