Business Intelligence Specialist

6 months ago


Toronto, Canada Arthur Grand Technologies Inc Full time

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

**Location:Toronto, Ontario (Hybrid)**

**Duration: Long Term Contract**

**MUST HAVES**:

- 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.

**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 ad-hoc)
- 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 re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software
- Experience Designing and developing enterprise-wide 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 carry-out 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 problem-solving 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:

- 8 hour shift

**Experience**:

- Cognos 10: 10 years (preferred)
- Microsoft Power BI: 10 years (preferred)
- Azure: 6 years (preferred)



  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of Junior BI...


  • Toronto, Ontario, Canada Randstad Canada Full time

    Are you a seasoned professional in business intelligence with expertise in Power BI?We have an exciting opportunity for a Technical Business Intelligence Specialist to join our team at Randstad Canada.About the Role:In this role, you will be responsible for designing and implementing scalable business intelligence solutions that meet the needs of our...


  • Toronto, Ontario, Canada Siga Home Comfort Inc. Full time

    Siga Home Comfort Inc. is seeking a skilled Business Intelligence Specialist to join our team.About the RoleWe are looking for an experienced professional to design, develop and implement information systems business solutions that drive growth and profitability.The ideal candidate will have a strong background in data analysis, business strategy, and...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Business Intelligence Specialist - Senior** **Location: 21 College suite 300, Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 3-5 years of experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards - Demonstrated experience with M, DAX and Power Query - Demonstrated...


  • Toronto, Canada CB Canada Full time

    Senior Business Intelligence (BI) Specialist On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior Business Intelligence (BI) Specialist. Senior Business Intelligence (BI) Specialist – Job Description Work with project teams to ensure successful release of Business Intelligence reporting using Power BI Use Power Query to...


  • Toronto, Ontario, Canada Nimbus Distro Full time

    About the RoleWe are seeking a skilled Business Intelligence Database Specialist to join our team at Nimbus Distro. As a key member of our organization, you will play a crucial role in designing and developing databases that support business decision-making.


  • Toronto, Canada Aviso Wealth Full time

    **Aviso Wealth**: **The Opportunity**: We’re looking for a BI Solution Specialist to join our IT team. This role can be mostly remote, however we will on occasion require you to come onsite to our office at 151 Yonge St, Toronto, ON. Reporting to the Director, Business Intelligence, the Business Intelligence Solution Specialist is part of the team that...


  • Toronto, Canada Softline Technology Full time

    Description **Deliverables for Sr. BI Specialist**: A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables: - Validate business requirements and update functional and technical design documents. - Retrofit custom ETL scripts and optimize OBIEE solution based on business requirements. -...


  • Toronto, Ontario, Canada BMO Full time

    Overview:BMO is seeking a highly skilled Business Intelligence and Regulatory Reporting Specialist to join our team. This role will be responsible for driving business growth by leveraging advanced analytics and reporting capabilities.Salary: $78,000 - $135,000 per yearJob Description:The Business Intelligence and Regulatory Reporting Specialist will be...


  • Toronto, Canada V-Tech Solutions Full time

    **Job Title**:Bi Specialist** **Location**:Toronto, Ontario (Hybrid)** **Duration: 6 Months Contract** Ontario Tourism Marketing Partnership Corporation (operating as Destination Ontario) would like to engage the People Placement Service to procure a resource that can help our President & CEO’s Office in establishing and implementing standardized...


  • Toronto, ON, Canada Autodesk Full time

    Job Requisition ID #24WD80449French job description to follow!/La description de poste en français se trouve plus bas!Position OverviewWe are looking for an experienced Business Intelligence Analyst to join our team in Canada. This is a hybrid full-time role, reporting to the Director of Customer Analytics. As a Business Intelligence Analyst Specialist,...


  • Old Toronto, Canada Scotiabank Full time

    At Scotiabank, we are seeking a highly skilled Business Intelligence Specialist to join our Global Fraud Authentications Technology team. As a key member of this team, you will be responsible for developing and managing innovative products designed to support the ever-changing threat landscape.The ideal candidate will have a strong background in business...


  • Old Toronto, Canada Kinross Gold Corporation Full time

    Job Description:In this exciting role as a Business Intelligence and Data Analytics Specialist with Kinross Gold Corporation, you will play a key part in shaping our organization's data-driven decision-making capabilities.About the Company:Kinross Gold Corporation is a Canadian-based global senior gold mining company with operations and projects in various...


  • Toronto, Ontario, Canada CI Financial Full time

    About CI FinancialAt CI Financial, we believe that our company is a great place to work because it's a safe space for everyone to have a voice and take ownership of meaningful work. We're committed to empowering our employees to grow through challenging projects and innovative products.We are seeking a Data Support Analyst to join the Wealth Technology group...


  • Toronto, Ontario, Canada Mitsubishi Heavy Industries Full time

    As a Business Intelligence Development Specialist at Mitsubishi Heavy Industries, you will play a key role in enabling insights and intelligent decision-making across functions.MHI RJ Aviation Group provides comprehensive critical operational, engineering and customer support solutions for the global regional aircraft industry. We are seeking an exceptional...


  • Toronto, Ontario, Canada CPA Ontaro Full time

    Job Description:We are seeking a skilled Business Intelligence Specialist to join our finance team. This role involves preparing and analyzing business and management reports to support the organization's planning and decision-making processes.Key Responsibilities:Perform monthly and quarterly financial reporting, including variance analysis to inform...


  • Toronto, Canada TD Bank Full time

    **Work Location**: Toronto, Ontario, Canada **Hours**: 37.5 **Line of Business**: Analytics, Insights, & Artificial Intelligence **Pay Details**: $91,200 - $136,800 CAD **Department Overview** The Enterprise Protect Reporting Factory (EPRF) resides in Platforms & Technology Risk Services within the Global Risk & Compliance - Enterprise Protect, Office...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. **Responsibilities**: - Assist with gathering business and information...


  • Toronto, Ontario, Canada Pearl Technologies LTD. Full time

    About the RoleWe are seeking an experienced Business Intelligence Data Analyst Specialist to join our team at Pearl Technologies LTD.This is a full-time position with a competitive salary range of $65,000 - $90,000 per annum, depending on experience.The ideal candidate will have strong analytical and problem-solving skills, as well as excellent communication...


  • Toronto, Ontario, Canada Aviso Wealth Full time $90,000 - $105,000

    Aviso Wealth:A Company Committed to InnovationAviso Wealth is a leading wealth management organization dedicated to the financial well-being of Canadians. Our team is passionate about delivering exceptional service, fostering meaningful partnerships, and driving innovation in the financial services industry. As a Business Intelligence Solution Specialist,...