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.

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.