Business Intelligence Specialist – Senior

Arthur Grand Technologies is currently seeking a highly motivated and skilled Business Intelligence Specialist – Senior for one of our clients.

Job Title: Business Intelligence Specialist – Senior

Location: Toronto, ON

Duration: Long Term/Short Term

Employment: Contract/Full Time

:

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 have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.

At Arthur Grand Technologies, we value our employees & contractors and strive to provide them with challenging, interesting work, market-relevant benefits, and opportunities for professional growth. If you have the necessary qualifications, and are excited to join a dynamic team, please send your resume to [email protected] for immediate consideration.

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Best regards,

Ansar Syed

[email protected]

Arthur Grand Technologies Inc

www.arthurgrand.com

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)