Business Intelligence Specialist - Senior
About the role
We do have a job opening for Business Intelligence Specialist - Senior for our direct client State of Ontario. The position details are given below:
Job Details: Job ID: RQ10945 - Business Intelligence Specialist - Senior Client : Justice Technology Services Location : 595 Bay Street, Toronto , Ontario Duration: 09 months + Extension Type: Onsite
Job Description:
Scope: The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Intelligence Specialist to help enhance the audit and reporting functionality in a Microsoft Dynamics MVP (minimum viable product). Experience and Skillset Requirements:
Mandatory Requirements:
- 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 such as DAX and Power Query.
- 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. Proven experience with ETL tools and technologies, such as Azure Synapse
- Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
Desired Skills and Experience:
- 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 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.
- 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, SQL4CDS
Not the right fit? Search for Business Intelligence Specialist jobs in Toronto, Ontario, Canada
About ITProFound Inc
The company that built over successful deliverance of gigantic applications across the US, Canada, Dubai and India. We are committed to building state of the art applications to meet today's challenges in Information Technology and help the businesses to thrive. We are a women owned company and most leaders are incredible Women, join us and excel in your passionate role.
Similar Jobs
Business Intelligence Specialist - Senior
About the role
We do have a job opening for Business Intelligence Specialist - Senior for our direct client State of Ontario. The position details are given below:
Job Details: Job ID: RQ10945 - Business Intelligence Specialist - Senior Client : Justice Technology Services Location : 595 Bay Street, Toronto , Ontario Duration: 09 months + Extension Type: Onsite
Job Description:
Scope: The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Intelligence Specialist to help enhance the audit and reporting functionality in a Microsoft Dynamics MVP (minimum viable product). Experience and Skillset Requirements:
Mandatory Requirements:
- 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 such as DAX and Power Query.
- 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. Proven experience with ETL tools and technologies, such as Azure Synapse
- Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
Desired Skills and Experience:
- 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 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.
- 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, SQL4CDS
Not the right fit? Search for Business Intelligence Specialist jobs in Toronto, Ontario, Canada
About ITProFound Inc
The company that built over successful deliverance of gigantic applications across the US, Canada, Dubai and India. We are committed to building state of the art applications to meet today's challenges in Information Technology and help the businesses to thrive. We are a women owned company and most leaders are incredible Women, join us and excel in your passionate role.