Business Intelligence Specialist

1 month ago

Toronto, Canada EBF Full time

on behalf of our client on Public Sector. we are looking for contract Business Intelligence Specialist for 1 year remote contract

Description

**SCOPE**:

- Provide planning, assessment, and development effort to complete the migration of approximately 136 IBM Cognos reports to Power BI
- Work with Senior Developer to evaluate and modernize reports, where applicable
- Reverse engineer IBM Cognos reports to core program logic, and re-code or migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
- Work with project team to complete all relevant and required documentation, such as knowledge transfer, and communication, to support the completion of the project

**DELIVERABLES**:

- Review IBM Cognos reports within scope of project to understand functionality, logic and design
- Perform assessment, and define approach in collaboration with project team and stakeholder to migrate IBM Cognos reports to appropriate Power BI tool (i.e., Desktop or Report Builder)
- Perform design and development activities to migrate IBM Cognos reports to Power BI in alignment with OPS Standards and Guidelines (i.e., AODA, WCAG 2.0 Level AA)
- Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer
- Participate in knowledge transfer activities

**Skills**:
Experience and Skill Set Requirements

**MANDATORY REQUIREMENTS**:

- Demonstrated working knowledge of IBM Cognos Report Studio (version 11 or earlier) [At least 5 years of experience]
- Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]
- Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
- Demonstrated working knowledge of DAX programming (At least 2 years of experience)

**SKILLS AND KNOWLEDGE**:

- Experience working in a business intelligence team/ environment, developing and delivering business intelligence and/or analytical reports and dashboards
- Experience working with IBM Cognos Report Studio (version 11, or earlier) to design and develop reports and dashboards, as well as writing Transact-SQL (T-SQL) queries
- Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports
- Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports
- Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.
- Knowledge of Microsoft SQL Server
- Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT, IBM DataStage
- Ability to work with large datasets e.g., 100 million records plus and ability to create Power BI datasets
- Knowledge of Power BI Service, functions, capabilities, security options, etc.

**CRITERIA**:
**Criteria 1 - Technical Knowledge**
- Experience/ demonstrated ability working with IBM Cognos Report Studio (version 11 or earlier) to design and develop reports and dashboards (at least 5 years of experience)
- Experience/ demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)
- Experience/ demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)

**Criteria 2 - Analytical and Problem-Solving Skills**
- Experience/ demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment/team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)
- Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation
- Demonstrated experience working within a team environment to troubleshoot and resolve technical problems

**Criteria 3 - Communication Skills**
- Oral and written communication skills, Interpersonal and consultative skills, Facilitation skills
- Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members
- Experience preparing documentation

**KNOWLEDGE TRANSFER**:
**Knowledge to be Transferred**:

- Codes
- Scripts
- Power BI report and dashboard specifications (PBIX files)

**Knowledge to be Transferred to**:

- Project Manager / Team members

**Details of Transfer**:
Must Haves:
The HM is looking for someone who can take old reports from Cognos and make new reports in Power BI

Experience/ demonstrated ability working with IBM Cognos R

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada Transatlantic Business Consulting Inc. Full time

    **Business Intelligence Specialist (Power BI)** - 3+ years using Power BI software development, including using DAX queries and functions - Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc. - SQL Server - Oracle - Ability to translate wireframes, lo-fidelity and...

  • Business Intelligence Specialist

    4 weeks ago

    Toronto, Canada Transatlantic Business Consulting Inc. Full time

    Our government client requires a Senior Business Intelligence Specialist/ Expert to help build a new data warehouse/lakehouse and deliver the reporting MVP (minimum viable product). **Data Warehouse/Lakehouse Concepts**:Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data...

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada Altus Group Full time

    Job Category: Software Opportunity Awaits at Altus Group! The Opportunity This is your chance to develop, build, and grow business intelligence at a global tech company. In this role, you will work closely with teams across the organization, translating their business needs into BI and Analytics solutions. As our next BI Specialist, you will deliver...

  • Business Intelligence Specialist

    4 weeks ago

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

  • Business Intelligence Specialist

    14 hours ago

    Toronto, Canada Net2Source Inc. Full time

    Job Title: Business Intelligence SpecialistDuration: 8 MonthsLocation: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mappingDemonstrated understanding of...

  • Senior Business Intelligence

    1 month ago

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

  • Senior Business Intelligence Specialist

    2 days ago

    Toronto, Canada Drake International Full time

    Title: Senior Business Intelligence SpecialistLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client’s next Business Intelligence Specialist and sit at the center of projects that drives decisions. You’ll help one of Canada's most trusted government organizations work on the latest project,...

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada SyLogix Consulting Inc. Full time

    **IMPORTANT**:This position is a hybrid work model (i.e. remote + onsite). Therefore, **applicants from Greater Toronto Area only**. We are seeking a Senior Business Intelligence Specialist to ensure successful release of Business Intelligence reporting using **Power BI, SSRS, SSIS, Azure Databricks, Python, Azure Data Lake, Azure Synapse, Azure Data...

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada Global Pharma Tek Full time

    Position: Business Intelligence Specialist Location: Toronto, ON (Hybrid) Duration: days contract + days extension Job Description: Responsibilities: Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions Develops and supports customized query applications that...

  • RQ06224 - Business Intelligence Specialist - Senior

    1 week ago

    Toronto, ON, Canada Teacup Tech Systems Inc Full time

    RQ06224 - Business Intelligence Specialist - Senior Toronto, ON, Canada Job Openings RQ06224 - Business Intelligence Specialist - Senior About the job RQ06224 - Business Intelligence Specialist - Senior Experience in business intelligence software development and a number of years of practical experience (minimum 3+ years) Experience in providing with...

  • Business Intelligence Specialist

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist - Senior **for one of our clients. **Position: Business Intelligence Specialist - Senior** **Location: Toronto, ON (Hybrid)** **Duration: Long Term Contract** **Must haves**: - Data Warehouse/Lakehouse Concepts: Strong understanding of data...

  • Intermediate Business Intelligence Specialist

    1 week ago

    Toronto, Canada NR Consulting Full time

    Title :: Intermediate Business Intelligence Specialist (Hybrid)  Location :: Toronto, ON, Canada Duration : Contract Security Level OPP Level Services/Deliverables: The Business Intelligence and Analytics resource deliverables are outcomes and outputs that they provide to the organization. Deliverables may include: Develop Performance...

  • Business Intelligence Specialist

    3 days ago

    Toronto, Canada Global Pharma Tek Full time

    Position: Business Intelligence Specialist Location: Toronto, ON (Hybrid) Duration: Days Contract + Possible Extension Job Description: Technical Experience: - year’s experience in a business analyst capacity, with demonstrated work outlined clearly in: Data and Statistics: Knowledge of data processing/warehousing and statistical analysis...

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ06097 - Business Intelligence Specialist - Senior** **Start Date: 2023-11-13** **End Date: 2024-03-31** **Office Location: 315 Front St. West** **Organization: Children, Youth & Social Services Cluster** **Ministry: Ministry of Children, Community and Social Services** **# Business Days: 120.00 plus Extension # of Days:...

  • RQ06214 Business Intelligence Specialist

    3 days ago

    Toronto, Canada Randstad Canada 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...

  • Business Intelligence Specialist

    4 hours ago

    Toronto, ON, Canada Net2Source Inc. Full time

    Job Title: Business Intelligence SpecialistDuration: 8 MonthsLocation: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mappingDemonstrated understanding of...

  • Senior- Business Intelligence Specialist

    1 day ago

    Toronto, Canada NR Consulting Full time

    Position Title :: Senior- Business Intelligence Specialist Work Location :: Toronto, ON ( Hybrid) Position Type :: Contract Duration :: + Month Job Description Responsibilities: Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports...

  • Business Intelligence Specialist

    1 month ago

    Toronto, Canada iPartner Staffing Full time

    **Must Have**: - 3+ years using Power BI software development, including using DAX queries and functions - Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, etc. - SQL Server 2017~2019 - Working knowledge of DataBricks - Ability to translate wireframes, low-fidelity and high-fidelity...

  • Business Intelligence Specialist

    4 weeks ago

    Toronto, Canada TD Bank Full time

    **TD Description** Stay current and competitive. Carve out a career for yourself. Grow with us. **Department Overview** TD Information & Cyber Security covers the development and management of security strategies, policies and programs to assess, prioritize and mitigate business risk with technology controls. Priorities include: mitigating and managing...

  • Business Intelligence Developer

    2 weeks ago

    Toronto, Canada Munich Re Full time

    Our team at Munich Re is responsible for rethinking and reshaping the way we look at our core business and we are seeking a Business Intelligence Specialist  to join our team. As a member of our Data and BI team you will be working on data delivery, transformation, and BI analytics for Munich Re Life and Health by working collaboratively across a variety...