Senior Business Intelligence Specialist

Overview

On Site
$CAD $90 / hr
Contract - W2
Contract - 7 month(s)

Skills

Business Intelligence Specialist

Job Details

Job Description:
Responsibilities:
  • Analyze business requirements and design a data warehouse/lakehouse on Microsoft Azure.
  • Develop and automate ETL processes to load data from Dynamics 365 CE and F&O into bronze/silver/golden layers.
  • IntegXX diverse data sources into the data warehouse.
  • Create logical and physical data models aligned with reporting needs.
  • Develop Power BI reports, dashboards, and visualizations per MVP requirements.
  • Optimize query performance and ensure system efficiency.
  • Implement security controls to protect sensitive data.
  • Ensure report accuracy, integrity, and alignment with business goals.
  • Comply with government standards, security procedures, and best practices.
  • Provide knowledge transfer and documentation.
Requirement/Must Have:
  • Proficiency in Power BI (data modeling, interactive dashboards, DAX, Power Query).
  • Experience with data analytics and reporting from Dynamics 365 CE and/or F&O.
  • Strong understanding of data warehouse/lakehouse principles, including ETL and data governance.
  • Experience developing data warehouses using Azure Synapse and Azure Data Factory.
  • SQL expertise including T-SQL, query tuning, and data definition.
  • Experience with SQL Server, Azure SQL, Oracle, SSIS, SSRS.
Should Have:
  • Experience with Dynamics 365 data models, entities, and relationships.
  • Experience integrating Dynamics 365 data sources into Power BI or Azure.
  • Familiarity with DataVerse, Power Platform, APIs, and Dataverse.
  • Experience with version control (Azure Repos) and CI/CD tools (Azure DevOps).
  • Understanding of data security, governance, and lifecycle management.
Skills:
  • Data modeling (star/snowflake schemas).
  • Data visualization and storytelling with Power BI.
  • Problem-solving and analytical thinking.
  • Strong written and verbal communication.
  • Ability to collaboXX with data engineers, analysts, and business stakeholders.
Qualification and Education:
  • Azure certifications preferred (e.g., Azure Fundamentals, Power BI Data Analyst Associate).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.