Business Intelligence Specialist

2 weeks ago


Toronto, Canada Cleo Consulting Full time

**Assignment: RQ06224 - Business Intelligence Specialist - Senior**

**Start Date: 2023-11-27**

**End Date: 2024-03-31**

**Office Location: 125 Sir William Hearst Ave., Toronto**

**Organization: Children, Youth & Social Services Cluster**

**Ministry: Ministry of Children, Community and Social Services**

**# Business Days: 90.00**

**Title: Business Intelligence Specialist**

**2 days onsite per week is required**

**Resumes must have a max of 5 pages only**

**Must haves**:
**Research and Analysis Skills**:
**Experience in leading or conducting time and motion studies**

**Experience interpreting your findings and providing recommendations to the team and executives**

**Able to analyze ways an organization might adopt new regulations around data gathering, metrics, KPI tracking and data analysis procedures**
**Communication and Interpersonal Skills**:
**Must have strong verbal and written communication skills to summarize information and ideas**
**Problem Solving Skills**:
**Experience collaborating with managers and other corporate clients to determine which data, KPIs and metrics are required to address their concerns**
**Design and Software Skills**:
**Knowledge of programming languages required to develop systems or procedures that aid in data analysis and business monitoring**
**Description**
**Responsibilities**:
Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutions

Conduct research and prototyping of new business intelligence and analytics capabilities to support OPS business requirements

Work with the Client, Designer(s) & Developer(s) assigned to refine/confirm Business Requirements

Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of "opportunity" and "key-trend" alerts.

Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
**Report and Dashboard Development**:
Developing interactive and visually appealing reports and dashboards

Customizing and optimizing reports for user-friendliness, and accessibility/AODA/WCAG 2.0 AA compliance
**Data Extraction and Transformation**:
Extracting data from various sources (e.g., databases, APIs) and transforming it for use in the solution

Implementing ETL (Extract, Transform, Load) processes to prepare and clean data.
**Data Visualization**:
Selecting appropriate visualization techniques to effectively communicate data insights.

Creating meaningful charts, graphs, and other data visualizations.
**DAX and Power Query**:
Writing and optimizing DAX (Data Analysis Expressions) formulas to perform complex calculations.

Utilizing Power Query for data transformation and manipulation.
**Performance Optimization**:
Tuning queries and data models for improved speed and responsiveness.
**Security and Access Control**:
Implementing data security measures to ensure appropriate access to sensitive information.

Working with our team to manage user roles and permissions using corporate best practices.Data Integration:
Creating seamless data flows and connections between systems.
**Collaboration and Documentation**:
Collaborating with agile project team of product owner, project manager, business analysts, data developers, user experience (UX) designers and business stakeholders to understand their requirements and provide insights.

Documenting data sources, data models, and report development following corporate best practices and processes
**Troubleshooting and Support**:
Monitoring and maintaining solutions, resolving technical issues and providing user support.
**Knowledge Transfer**:
Must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system.

The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.

Development of documentation and materials as part of a review and knowledge transfer to other members
**General Skills**:
Experience in business intelligence software development and a number of years of practical experience (minimum 3+ years)

Experience in providing with recommend best option for business

Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing

Experience with designing and mapping multi-dimensional data models, report models into business insights

Experience building, testing and implementing complex reports, dashboards, and other objects

Experience prototyping designs to develop business requirements for future implementation

Ability to assist in the requirements gathering, analysis and subsequent developments

Abi



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


  • Toronto, Canada WIZECH INC. Full time

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


  • Toronto, Canada iPartner Staffing Full time

    7+ years in ETL tools such as Microsoft SSIS, stored procedures **(Must Have)**: - 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines **(Must Have)**: - 2+ years Python **(Must Have)** Description **General Responsibilities** Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial...


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


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


  • Toronto, Canada AlphaForce Technology Solutions Full time

    **Position: Business Intelligence Specialist - Senior** **Location: 315 Front Street, Toronto, ON** **Security Level: CRJMC** **Must haves**: - 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have) - 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have) - 2+ years Python (Must...


  • Toronto, Canada YDC PRO Consulting Full time

    **Must haves**: - 10+ years of experience - Demonstrates advanced knowledge and expertise in various BI tools and technologies, such as data modeling, ETL processes, data visualization, and reporting. - Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI - Exhibits strong data...


  • Toronto, Canada Ministry of Health Full time

    We are in search of a seasoned professional to provide technical expertise in the design and implementation of complex projects as well as re-engineering of legacy (on-premise) technical solutions as to facilitate cloud migration. If this sounds like your next career move, then consider this exciting opportunity with us. **OPS Commitment to Diversity,...


  • Toronto, Canada EssenceMediacom Full time

    **Job Title: Manager, Business Intelligence & Insights** At MediaCom, we believe in People First, Better Results We help people, brands and businesses unlock their growth potential Our success is underpinned by our belief that if we invest in our people, we’ll deliver better results not only for our teams but for our clients. We’re a global company,...


  • Toronto, ON, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Toronto, Canada Altis Technology Full time

    Senior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...


  • Toronto, Canada CLIO Full time

    What your team does: Our Business Intelligence team is part of the larger Data & AI group. Together, were focused on stewarding a scientific culture to drive better decisions. Along with the Manager of Business Intelligence, you will be working across departments to empower all stakeholders to make better decisions through data-oriented solutions, with...


  • Toronto, ON, Canada GSYSINFO INC Full time

    At GSYSINFO Inc Preferred values are to establish a relationship of trust and mutual respect between our advisors and our clients, we’re currently seeking an experienced business intelligence developer to join an exciting and challenging BI shop. This individual will help guide the evolution of a business intelligence data warehouse and enable reporting...


  • Old Toronto, Canada GSYSINFO INC Full time

    At GSYSINFO Inc Preferred values are to establish a relationship of trust and mutual respect between our advisors and our clients, we’re currently seeking an experienced business intelligence developer to join an exciting and challenging BI shop. This individual will help guide the evolution of a business intelligence data warehouse and enable...