RQ10945 Business Intelligence Specialist Senior

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

Assignment Deliverables:

As a member of the PGTIMS Support and Data Reporting team you will be responsible for helping to define enhancements to MVP audit and reporting functionality. A high-level list of deliverables for audit and reporting follows:

• Collaborate with cross-functional teams: work with teams across departments to understand business requirements and deliver data-driven solutions.
  
• Database management: work with databases and the data warehouse to extract transform and load data for analysis.
  
• Data analysis: analyze and interpret complex data sets to provide valuable insights into business performance and trends.
  
• Data Modeling: create logical and physical data models that align with the organizations reporting and analytical needs.
  
• Data Security and Governance: apply security controls to protect sensitive data.
  
• Reporting and Visualization: develop reports dashboards and visualizations per user requirements.
  
• Data accuracy: Ensure the quality accuracy and integrity of reports.
  
• Performance Optimization: fine-tune data warehouse and reporting processes to optimize query performance and overall system efficiency.
  
• Other duties as assigned.
  

You will also be required to:

• Complete work and achieve milestones within the assigned deadlines.
  
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables as soon as you become aware of them
  
• Submit Deliverables for Cluster/Ministry approval as they are completed.
  
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices.
  
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices.
  
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines.
  
• Provide knowledge and skill transfer to designated Cluster/Ministry staff.
  
• Comply with the Ontario Government I&IT Directive Operational Policy on the I&IT Project Gateway Process and other applicable Guidelines Standards and Procedures.
  

Requirements

Experience and Skill Set Requirements:

Skill Set 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
  
• 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:

• 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 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. Proven experience with ETL tools and technologies such as Azure Synapse
  
• 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
  
• Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
  

Data Warehouse/Lakehouse:

• Demonstrated experience developing reports in a Data Warehouse/ Lakehouse.
  
• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles including data modeling ETL processes data integration and data governance.
  

Power BI Experiences:

• Demonstrated 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 Synapse
  
• Proficiency in designing logical and physical data models understanding relationships defining hierarchies and ensuring efficient data storage and retrieval.
  

Data Integration and Extraction:

• Demonstrated 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 Synapse
  
• Proficiency in designing logical and physical data models understanding relationships defining hierarchies and ensuring efficient data storage and retrieval.
  

D365/Azure Knowledge:

• Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
  
• Experience with SQL Server Management Studio Azure data management tools SQL4CDS
  
• 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.
  

Required Skills:

Experience and Skill Set Requirements: Skill Set 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 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: 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 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. Proven experience with ETL tools and technologies such as Azure Synapse 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 Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O). Data Warehouse/Lakehouse: Demonstrated experience developing reports in a Data Warehouse/ Lakehouse. Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles including data modeling ETL processes data integration and data governance. Power BI Experiences: Demonstrated 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 Synapse Proficiency in designing logical and physical data models understanding relationships defining hierarchies and ensuring efficient data storage and retrieval. Data Integration and Extraction: Demonstrated 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 Synapse Proficiency in designing logical and physical data models understanding relationships defining hierarchies and ensuring efficient data storage and retrieval. D365/Azure Knowledge: Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O). Experience with SQL Server Management Studio Azure data management tools SQL4CDS 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.

Employment Type : Full Time
Experience: years
Vacancy: 1