Business Intelligence Specialist

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

  • RQ06214 Business Intelligence Specialist

    3 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Business Intelligence Specialist - Senior for our public sector client.Work location: 777 Bay Street, TorontoDuration: 8 Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • RQ06214 Business Intelligence Specialist

    2 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Business Intelligence Specialist - Senior for our public sector client.Work location: 777 Bay Street, TorontoDuration: 8 Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • Marketing Intelligence Specialist

    4 days ago

    North York, Canada Apotex Inc. Full time

    **About Apotex Inc.** **Job Summary**: The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex’s broad line of generic pharmaceutical products. The Specialist, Marketing Intelligence will be responsible for developing, managing and...

  • Marketing Intelligence Specialist

    3 days ago

    North York, Canada Apotex Full time

    About Apotex Inc. Job Summary The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex’s broad line of generic pharmaceutical products. The Specialist, Marketing Intelligence will be responsible for developing, managing and...

  • Business Intelligence Systems Business Analyst

    2 weeks ago

    North York, Canada Alliance for Healthier Communities Full time

    Full-Time, Fixed-Term Employee Contract Until March 31, 2025 The Alliance for Healthier Communities is the voice of a vibrant network of community-governed primary health care organizations. Alliance members serve diverse communities across the province of Ontario, and they are rooted in the communities they serve. They share a commitment to advancing...

  • Business Intelligence Systems Business Analyst

    2 weeks ago

    North York, Canada Alliance for Healthier Communities Full time

    **Full-Time, Fixed-Term 2 Year Employee Contract** The Alliance for Healthier Communities is the voice of a vibrant network of community-governed primary health care organizations. Alliance members serve diverse communities across the province of Ontario, and they are rooted in the communities they serve. They share a commitment to advancing health equity...

  • Business Intelligence Analyst

    2 months ago

    North York, Canada Canadian Mental Health Association Toronto Branch Full time

    **Business Intelligence Analyst** - **Client Management**: **The Role and Opportunity**: - CMHA Toronto is looking for a skilled Business Intelligence Analyst who will support the organization to develop its business intelligence capability. CMHA Toronto recently migrated to a new client management system and this role will be focussed on identifying and...

  • Instructor: Artificial Intelligence

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

    1 month 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

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

  • Business Intelligence Team Lead

    4 days ago

    North York, Canada Direct Travel Full time

    Business Intelligence Development Team Lead - RemotePosition OverviewAs a key member of the Data Management & Analytics (DMA) team, the Business Intelligence Development lead will be responsible for managing business intelligence requests, and as team grows leading business intelligence development team members. This will be a very hands-on role, involving a...

  • Manager, Business Intelligence

    5 days ago

    North York, Canada Elections Ontario Full time

    **Manager, Business Intelligence** For accessibility assistance with this document please telephone Elections Ontario at 1-888-668-8683 or Fax at 1-866-714-2809. You can TTY at 1-888-292-2312. **Position Status**: Permanent **Posting Status**: Open **Location**: 26 Prince Andrew Place, North York, ON M3C 2H4 (Don Mills & Eglinton) **Starting Salary**:...

  • Business Intelligence Team Lead- Remote

    4 days ago

    North York, Canada Direct Travel Full time

    **Business Intelligence Team Lead**: - Remote** **Position Overview** As a key member of the Data Management & Analytics (DMA) team, the Business Intelligence Lead will be responsible for managing business intelligence requests, and as team grows leading business intelligence development team members. This will be a very hands-on role, involving a fair...

  • Business Intelligence Developer

    2 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    2 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly. Key...

  • Business Intelligence Developer

    3 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly. Key...

  • Business Intelligence Developer

    3 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    3 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    2 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    2 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportun