W0115 Business Intelligence Specialist - Toronto, Canada - WIZECH INC.
Description
We are hiring a IT talents for our decent clients.Contract term: 12 months
Hybrid: 3 days onsite per week is required
Responsibilities
- Key deliverables to be performed by the Business Intelligence Specialist role include, but are not limited to, the following:
- Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutions
- Develops and supports guided analysis and drilldown functionality, routine scheduling and notification of report generation, and effective implementation of "opportunity" and "keytrend" alerts.
- Provides Clients with approach options and tools for managing businessrelated data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Develop presentations for various audiences, as required.
- Work with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignment.
- Transfer skills and knowledge to selected OPS staff.
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.
MUST
- Supports Client's wide-ranging 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
Job Type:
Fixed term contract
Salary:
$30.00-$45.00 per hour
Experience:
- existing data sets, models, and transformations: 1 year (required)
- Business intelligence: 5 years (preferred)
- BI Repts, Dashboards, etc with Cognos 10+, Power BI: 3 years (required)
More jobs from WIZECH INC.
-
W0362 IT Project Manager
Toronto, Canada - 4 weeks ago
-
W0175 IT Project Manager
Toronto, Canada - 3 weeks ago
-
W0348 IT Project Manager
North York, Canada - 4 weeks ago
-
W0184 Junior IT Project Manager
Toronto, Canada - 3 weeks ago
-
W0128 QA Specialist
Toronto, Canada - 4 weeks ago
-
W0323 Systems Administrator/operations Support
Guelph, Canada - 5 days ago