Business Intelligence Specialist

7 months ago

North York, 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 **Business Intelligence Specialist - Senior t**o join our dynamic team for our client

C**ontract Duration**:15 months**

**Work type: Required to work onsite at the work location 3 days a week and 2 days from home**

**Position Summary-**
- Prepare a detailed BI user requirement document
- Document the new requirements and complete analysis and design document
- Convert the user requirements into business model for Cognos BI
- Convert the business model into Framework Manager Models
- Build the security model for the BI implementation
- Create metadata, user groups and folder structure for BI objects
- Migrate standard reports from Cognos v11.1 on-premises to Cognos v11.2 on Cloud Pak for Data on Amazon Web Services (AWS)
- Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
- Test, debug, re-engineer standard reports and dashboards in Cognos on AWS
- Convert Dynamic Cubes functionality to DMR or Transformer Cubes without any loss in performance
- Document test cases to ensure expected functionality of the reports
- Deploy reports using Cognos Framework Manager
- Develop SQL and PLSQL process and procedures to implement complex logic.
- Assist with SQL tuning and optimization activities related to the Cognos reports.
- Help to optimize the SQL and PL/SQL process for optimal report performance.
- Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring.
- Support user acceptance testing and system implementation.
- Train SMEs or conduct demos on self-serve BI reporting.
- Any other deliverables as assigned by the Project/Resource Manager.
- Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements.

**Experience and Skill Set Requirements**
- Experience working in the **OPS and familiarity with I&IT project management processes**:

- Experience in design and development of **Data Marts or Data Warehouses** on a wide range of data repositories (relational and multi-dimensional data stores)
- Experience in **Cognos Analytics **reporting; modeling with **Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager** (5+ years)
- Excellent requirements analysis skills
- In-depth knowledge and experience with **Cognos report development in Cognos Analytics and Administration v11.2.x **(reporting, dashboarding, embedded JavaScript, embedded SQL)
- Knowledge of BI architecture patterns, best practices, processes, and artefacts
- Experience developing Cognos reports in the **IBM Cloud Pak for Data environment**:

- Experience in **Oracle 19 or higher **including writing complex SQL/PL SQL queries and materialized views.
- Experience in **AWS Cloud technologies**, specifically A**WS Redshift**:

- Experience in database performance and tuning skills
- Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)
- Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence

**Soft Skills**
- Demonstrated leadership and people management skills.
- Proven troubleshooting and critical thinking skills
- Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications.
- Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management.
- A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

**Salary**: $90.00-$110.00 per hour

Work Location: Hybrid remote in North York, ON M7A 2T1

  • Advisor Business Intelligence

    2 weeks ago

    North York, Canada Enbridge Full time

    **Posting End Date**: January 20, 2025 **Employee Type**: Regular-Full time **Union/Non**: This is a non-union position Do you enjoy taking large sets of data and analyzing it to help organizations answer questions and make better business decisions? Join our team as an **Advisor Business Intelligence**and help make a difference! At Enbridge, we are...

  • Instructor: Artificial Intelligence

    7 months ago

    North York, Canada TORONTO BUSINESS COLLEGE Full time

    Toronto Business College is a private career college that has partnered with an Ontario College of Arts and Technology to offer programs to international students in the GTA. Our goal is to provide our students with the theoretical knowledge and practical skills required to thrive in the increasingly dynamic workforce. We strive to offer the most relevant...

  • Instructor: Artificial Intelligence

    3 days ago

    North York, Canada TORONTO BUSINESS COLLEGE Full time

    Toronto Business College is a private career college that has partnered with an Ontario community college to offer programs to international students in the GTA. Our goal is to provide our students with the theoretical knowledge and practical skills required to thrive in the increasingly dynamic workforce. We strive to offer the most relevant programs and...

  • Bilingual Business Information Specialist

    4 months ago

    North York, Canada CCR Business Information Limited Full time

    **French/English Bilingual Business Information Specialist** Excellent entry level opportunity for a bright, energetic individual with a superior telephone manner and strong written English skills. We are a well-established business information services firm, providing consumer and commercial credit reports and employment screening reports. The position...

  • Bilingual Business Information Specialist

    7 months ago

    North York, Canada CCR Business Information Limited Full time

    **French/English Bilingual Business Information Specialist** Excellent entry level opportunity for a bright, energetic individual with a superior telephone manner and strong written English skills. We are a well-established business information services firm, providing consumer and commercial credit reports and employment screening reports. This is a full...

  • Bilingual Business Information Specialist

    3 days ago

    North York, Canada CCR Business Information Limited Full time

    **French/English Business Information Specialist Position** Excellent entry level opportunity for a bright, energetic individual with a superior telephone manner and strong written English skills. We are a well-established business information services firm, providing consumer and commercial credit reports and employment screening reports. This is a full...

  • Business Intelligence Specialist

    5 months ago

    North York, Canada KAYVER CARE SERVICES Full time

    Work Term: Permanent - Work Language: English - Hours: 30 hours per week - Education: Bachelor's degree - Experience: 1 year to less than 2 years **Work setting**: - Private company, corporation or industry **Tasks**: - Confer with clients to identify requirements - Document technical requirements to ensure that products, processes and solutions meet...

  • Sr. Manager of Analytics and Business Intelligence

    2 weeks ago

    North York, Canada Manpower Canada Full time

    Are you a strategic thinker with a passion for analytics and business intelligence? Our client in the internet gaming industry in Ontario is seeking a dynamic Sr. Manager of Analytics and Business Intelligence to lead their analytics and BI function. In this role, you will play a crucial part in developing and executing a roadmap that enhances the data...

  • Sr. Manager of Analytics and Business Intelligence

    4 weeks ago

    North York, Canada Manpower Canada Full time

    Are you a strategic thinker with a passion for analytics and business intelligence? Our client in the internet gaming industry in Ontario is seeking a dynamic Sr. Manager of Analytics and Business Intelligence to lead their analytics and BI function. In this role, you will play a crucial part in developing and executing a roadmap that enhances the data...

  • Sr. Manager of Analytics and Business Intelligence

    4 weeks ago

    North York, Canada Manpower Canada Full time

    Are you a strategic thinker with a passion for analytics and business intelligence? Our client in the internet gaming industry in Ontario is seeking a dynamic Sr. Manager of Analytics and Business Intelligence to lead their analytics and BI function. In this role, you will play a crucial part in developing and executing a roadmap that enhances the data...

  • Manager, Business Intelligence

    7 months ago

    North Bay, Canada Ontario Northland Full time

    **POSITION**: Manager, Business Intelligence **REPORTS TO**:Executive Lead, Agency Modernization **DEPARTMENT**:Agency Modernization **LOCATION**: North Bay **REFERENCE**: 800-23-25 **SALARY**: $85,826 - $100,950 **WHO WE ARE**: Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital...

  • Intelligent Technology Consultant

    2 weeks ago

    North York, Canada Techify Inc. Full time

    Techify is hiring an Intelligent Technology Consultant to work with our Director of Intelligent Technology Consulting and be a key part of our next stage in growth. The IT Consultant is a critical part of delivering the Techify Way and spearheads many of the proactive technology improvements to save our clients time and reduce risk. **Who We Are**: Techify...

  • Intelligent Technology Consultant

    2 days ago

    North York, Canada Techify Inc Full time

    Techify is hiring an Intelligent Technology Consultant to work with our Director of Intelligent Technology Consulting and be a key part of our next stage in growth. The IT Consultant is a critical part of delivering the Techify Way and spearheads many of the proactive technology improvements to save our clients time and reduce risk. **Who We Are**: Techify...

  • Manager, Marketing Intelligence

    7 months ago

    North York, Canada Nestle Operational Services Worldwide SA Full time

    **A little bit about us** While Nestlé is known for KitKat, Gerber, Nescafe, and Häagen-Dazs, our recipe for success comes down to one thing: our people. We strive to lead a people-focused culture that empowers employees to bring their authentic selves to work each day. There are 3,000+ members of Nestlé Canada celebrated for taking action using agility,...

  • Intelligent Technology Consultant

    7 months ago

    North York, Canada Techify Inc Full time

    Techify is hiring an Intelligent Technology Consultant who will be a key part of our next stage in growth. The IT Consultant is a critical part of delivering the Techify Way and spearheads many of the proactive technology improvements to save our clients time and reduce risk. **Who We Are**: Techify saves time and reduces risk for clients by providing...

  • Manager, Business Planning and Intelligence

    2 months ago

    North Bay, Canada Ontario Northland Full time

    **POSITION**: Manager, Business Planning and Intelligence **REPORTS TO**: Director of Finance **DEPARTMENT**: Finance **LOCATION**: North Bay **REFERENCE**: 800-133B-25 **SALARY**: $104,546 - $123,006 **WHO WE ARE**: Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation...

  • Instructor: Global Business Management

    14 hours ago

    North York, Canada TORONTO BUSINESS COLLEGE Full time

    Toronto Business College is a private career college that has partnered with an Ontario community college to offer programs to international students in the GTA. Our goal is to provide our students with the theoretical knowledge and practical skills required to thrive in the increasingly dynamic workforce. We strive to offer the most relevant programs and...

  • Investigations Intelligence Officer

    5 months ago

    North York, Canada Ministry of the Environment, Conservation and Parks Full time

    The Ministry of the Environment, Conservation and Parks, Environmental Investigations and Enforcement Branch are seeking qualified individuals to join our Intelligence team. In this exciting, rewarding and challenging opportunity, you will deliver and conduct operational, tactical and strategic intelligence and collaborate with internal and external...

  • Sr. Manager Of Analytics And Business Intelligence

    2 weeks ago

    North York, ON, Canada Manpower Canada Full time

    Are you a strategic thinker with a passion for analytics and business intelligence? Our client in the internet gaming industry in Ontario is seeking a dynamic Sr. Manager of Analytics and Business Intelligence to lead their analytics and BI function. In this role, you will play a crucial part in developing and executing a roadmap that enhances the...

  • Sr. Manager Of Analytics And Business Intelligence

    2 weeks ago

    North York, ON, Canada Manpower Canada Full time

    Are you a strategic thinker with a passion for analytics and business intelligence? Our client in the internet gaming industry in Ontario is seeking a dynamic Sr. Manager of Analytics and Business Intelligence to lead their analytics and BI function. In this role, you will play a crucial part in developing and executing a roadmap that enhances the...