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 organization's 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.
  

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.