Business Intelligence Specialist

2 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 warehousing principles, including data modeling, ETL processes, data integration, and data governance.
- Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards and utilizing advanced features
- Experience with SSIS, SSRS

**SKILLS AND KNOWLEDGE**:

- Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
- Microsoft Azure Synapse: In-depth knowledge and experience with Azure Synapse Analytics, including its architecture, data storage options (e.g., SQL Data Warehouse, Data Lake Storage), data ingestion mechanisms (e.g., Azure Data Factory, Azure Databricks), and security features.
- Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
- SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.
- Data Integration: Knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse. Familiarity with ETL tools and technologies, such as Azure Data Factory or SSIS (SQL Server Integration Services).
- Data Modeling and Design: Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.
- Data Visualization: Ability to create visually appealing and informative reports and dashboards using Power BI, understanding best practices for data visualization, and storytelling with data.
- Data Security and Governance: Knowledge of data security principles, data governance practices, data quality management, and data lifecycle management.
- Analytical and Problem-Solving Skills: Strong analytical thinking and problem-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.
- Communication and Collaboration: Effective communication skills to interact with stakeholders, gather requirements, and present findings. Collaboration skills to work with cross-functional teams, such as data engineers, data analysts, and business stakeholders.
- Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.
- Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN).
- Experience with SSIS, SSRS

**CRITERIA**:
**Criteria 1 - Date Warehouse**
- Demonstrated experience developing reports in a Data Warehouse/ Lakehouse. Experience with supporting a data warehouse in a production environment
- Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
- Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools (preferably, ERWIN)

**Criteria 2 - PowerBI**
- Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.
- Experience with SSIS, SSRS

**Criteria 3 - SQL / DB**
- Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
- Demonstrated experience with SQL Server, Oracle, Azure SQL Databases

**Criteria 4 - Azure Platform**
- Experience with Azure Data Factory (ADF) and Synapse Workspaces
- Demonstrated experience Azure data management tools, DevOps, Synapse Studio
- Experience in Azure resource configuration and administration such as Azure Data Lake, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
- Azure cloud certifications

**Criteria 5 - Dynamics 365**
- Demonstrated experience working with integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
- Demonstrated experience with PowerApps platform, Power Automate, Dynamics CE &F&O

**About Arthur Grand Technologies**:
Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who hav

  • Junior Business Intelligence Specialist

    4 days ago

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

  • Business Intelligence Specialist

    1 week ago

    Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ06373 - Business Intelligence Specialist - Senior** **Start Date: 2024-01-02** **End Date: 2025-03-31** **Office Location: Hybrid - 3 days in office, 2 days remote. Office location: 222 Jarvis St 5th floor** **Organization: Central Agencies Cluster** **Ministry: Ministry of Treasury Board Secretariat** **# Business Days: 312.00 plus...

  • Senior Business Intelligence

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

  • Business Intelligence Specialist

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

  • W0115 Business Intelligence Specialist

    4 days ago

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

  • Business Intelligence Specialist

    4 days ago

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

  • Business Intelligence Specialist

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

  • Business Intelligence Specialist

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

  • Manager, Business Intelligence

    1 week ago

    Toronto, Canada Home and Community Care Support Services Full time

    **Job Description**: **_CARE AND BE CARED FOR - THIS IS YOUR HOME_**: Do you have passion for analytics, ability to "tell stories" with data and facts ? Do you have strong project management skills with solid understanding of data governance, data management and data strategy? Are you looking to make a difference in your community? You’re looking in the...

  • Business Intelligence

    3 weeks ago

    Toronto, Canada Auxly Cannabis Group Inc. Full time

    **Business Intelligence & Data Visualization Specialist**: **Toronto, ON (Hybrid)** **About Auxly Cannabis Group Inc.** **About the role** The technology team is looking for a passionate person with a business-savvy mindset to help us turn our data into actionable insights. This role is part of the team responsible for driving the strategic vision and...

  • Business Intelligence Specialist

    4 weeks ago

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

  • Business Intelligence Manager

    4 weeks ago

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

  • Analyst, Human Intelligence

    6 days ago

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

  • Analyst, Human Intelligence

    6 days ago

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

  • Analyst, Human Intelligence

    6 days ago

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

  • Analyst, Human Intelligence

    5 days ago

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

  • Analyst, Human Intelligence

    2 hours ago

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

  • Business Intelligence Developer

    3 days ago

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

  • Business Intelligence Analyst

    3 weeks ago

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

  • Developer, Business Intelligence

    4 weeks ago

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