Data Analyst

OXARO Inc.; Ottawa; Remote; CAD 70.000 - 100.000; Vollzeit

Zusammenfassung

OXARO Inc. is seeking a data and analytics specialist to analyze the application database, metadata, and app-generated information across SharePoint Online, Power Apps, Power Automate, and related Microsoft 365 services.

You will organize, review, and interpret data, identify gaps, support monitoring, and contribute to dashboards and reporting using Power BI and Excel, across Development, UAT, and Production environments, while ensuring security and compliance.

Qualifikationen

• 2+ years of experience using Microsoft 365, SharePoint Online, Power Platform, Power BI, Excel.
• 2+ years of experience supporting reporting, dashboards, BI, data analysis for enterprise apps.
• 1+ years analysing metadata, data quality, taxonomy, records-management metadata.
• 1+ years analysing search, filtering, information retrieval, or usage trends for enterprise apps.

Aufgaben

• Analyse the application database, list, library, metadata, and app-generated information structures within SharePoint Online, Power Apps, Power Automate, and related Microsoft 365 services.
• Organise, review, and interpret application data, including records declaration data, validation status, application usage data, search-related data, and user feedback.
• Review metadata fields used for declaration, search, filtering, reporting, validation, records management, lifecycle management, and user experience.
• Identify metadata gaps, inconsistencies, duplicated values, missing values, field-use issues, data quality issues, or reporting limitations.
• Support application monitoring activities, including usage trends, active-user indicators, declaration volumes, validation trends, search behaviour, and user feedback trends.
• Support reporting and dashboard activities using Power BI, SharePoint list reporting, Excel-based analysis, and other authorised Microsoft 365 reporting sources.
• Perform database analysis, metadata review, and data quality review for SharePoint Online lists, libraries, metadata fields, app-generated records, and reporting sources.
• Test, validate, troubleshoot, and refine reporting, filtering, search, metadata, dashboard input, and application monitoring functions across Development, UAT, and Production environments.
• Support search analytics, feedback tracking, and adoption analysis to inform understanding of application usage, performance, and user experience.
• Provide technical observations concerning database structure, metadata usage, reporting gaps, application metrics, search analytics, data quality risks, and sustainment considerations.
• Work within approved environments and authorised tools, handling all information in accordance with applicable security, privacy, information-management, and records-management requirements.

Kenntnisse

Microsoft 365 suite

SharePoint Online

Power Platform

Power BI

Data analysis

Tools

Excel

Jobbeschreibung

• Analyse the application database, list, library, metadata, and app-generated information structures within SharePoint Online, Power Apps, Power Automate, and related Microsoft 365 services.
• Organise, review, and interpret application data, including records declaration data, validation status, application usage data, search-related data, and user feedback.
• Review metadata fields used for declaration, search, filtering, reporting, validation, records management, lifecycle management, and user experience.
• Identify metadata gaps, inconsistencies, duplicated values, missing values, field-use issues, data quality issues, or reporting limitations.
• Support application monitoring activities, including usage trends, active-user indicators, declaration volumes, validation trends, search behaviour, and user feedback trends.
• Support reporting and dashboard activities using Power BI, SharePoint list reporting, Excel-based analysis, and other authorised Microsoft 365 reporting sources.
• Perform database analysis, metadata review, and data quality review for SharePoint Online lists, libraries, metadata fields, app-generated records, and reporting sources.
• Test, validate, troubleshoot, and refine reporting, filtering, search, metadata, dashboard input, and application monitoring functions across Development, UAT, and Production environments.
• Support search analytics, feedback tracking, and adoption analysis to inform understanding of application usage, performance, and user experience.
• Provide technical observations concerning database structure, metadata usage, reporting gaps, application metrics, search analytics, data quality risks, and sustainment considerations.
• Work within approved environments and authorised tools, handling all information in accordance with applicable security, privacy, information-management, and records-management requirements.

Location

Remote

Duration

48 weeks

Security Clearance

Reliability Status

Responsibilities

• Analyse the application database, list, library, metadata, and app-generated information structures within SharePoint Online, Power Apps, Power Automate, and related Microsoft 365 services.
• Organise, review, and interpret application data, including records declaration data, validation status, application usage data, search-related data, and user feedback.
• Review metadata fields used for declaration, search, filtering, reporting, validation, records management, lifecycle management, and user experience.
• Identify metadata gaps, inconsistencies, duplicated values, missing values, field-use issues, data quality issues, or reporting limitations.
• Support application monitoring activities, including usage trends, active-user indicators, declaration volumes, validation trends, search behaviour, and user feedback trends.
• Support reporting and dashboard activities using Power BI, SharePoint list reporting, Excel-based analysis, and other authorised Microsoft 365 reporting sources.
• Perform database analysis, metadata review, and data quality review for SharePoint Online lists, libraries, metadata fields, app-generated records, and reporting sources.
• Test, validate, troubleshoot, and refine reporting, filtering, search, metadata, dashboard input, and application monitoring functions across Development, UAT, and Production environments.
• Support search analytics, feedback tracking, and adoption analysis to inform understanding of application usage, performance, and user experience.
• Provide technical observations concerning database structure, metadata usage, reporting gaps, application metrics, search analytics, data quality risks, and sustainment considerations.
• Work within approved environments and authorised tools, handling all information in accordance with applicable security, privacy, information-management, and records-management requirements.

Qualifications

• 2+ years of experience using Microsoft 365, SharePoint Online, Power Platform, Power BI, Excel, or comparable tools to support reporting, dashboards, application monitoring, data extraction, or analysis for enterprise applications.
• 2+ years of experience supporting reporting, dashboarding, business intelligence, database analysis, application usage analysis, or data quality review for enterprise applications, including interpreting application data and identifying findings, trends, gaps, inconsistencies, or reporting requirements.
• 1+ years of experience analysing or supporting metadata, data quality, taxonomy, records-management metadata, or information-management data structures, including identifying missing, inconsistent, duplicated, incorrectly structured, or insufficiently used metadata or data values.
• 1+ years of experience analysing or supporting search, filtering, information retrieval, application monitoring, user feedback, or usage trends for an enterprise application, including identifying application behaviour, user needs, search or retrieval issues, adoption patterns, or opportunities for improvement.

Reliability Status Security Clearance Required.

AI Disclosure

We do not use artificial intelligence (AI) tools to screen, assess, or select applicants at any stage of our recruitment process. All applications are reviewed by our recruitment team.

OXARO is committed to fostering an inclusive, equitable and respectful workplace where every individual feels valued and empowered to contribute their best. We believe that diversity drives innovation and strengthens our ability to serve our clients and communities. We are dedicated to ensuring a fair and unbiased recruitment process and welcome applications from members of the four designated groups under the Employment Equity Act: women, Indigenous peoples, persons with disabilities and members of visible minorities. Accommodations are available upon request for candidates taking part in all aspects of the recruitment process. We sincerely thank all applicants for their interest in this opportunity. While we appreciate every application, only those selected for an interview will be contacted.