PMO Analytics & BI Specialist

Netwoven; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Netwoven is seeking a Power BI-focused analyst to build, maintain and advance PMO dashboards and data models for governance, resource utilisation, demand and forecasting. You will connect data from Excel, SharePoint Online and SQL sources, develop DAX measures, and ensure secure, refreshed reporting models.

You will collaborate with PMO, Project Managers, HR and Operations to translate requirements into practical solutions, document processes, and deliver controlled enhancements.

Qualifications

• 4 to 6 years of IT experience, including hands-on development of reporting, analytics or business solutions.
• Strong Power BI capability across data modelling, DAX, Power Query, interactive reporting, Row-Level Security, publishing and scheduled refresh.
• Working knowledge of SQL and relational data, with the ability to query, validate and reconcile reporting data.
• Advanced Excel skills, including PivotTables, analytical functions and Power Query.
• Ability to translate business requirements into practical solutions and explain them clearly to non-technical stakeholders.
• Strong analytical thinking, ownership, data accuracy and documentation discipline.

Responsibilities

• Build and maintain Power BI data models, reports and executive dashboards for governance, resource utilisation, demand, capacity and forecasting.
• Connect and transform data from Excel, SharePoint Online, SQL databases and other approved sources using Power Query and SQL.
• Create DAX measures, drill-through views, security roles, refresh schedules and performance-optimised reporting models.
• Automate recurring data updates, approvals, alerts and notifications using Power Automate.
• Build or enhance simple Power Apps and SharePoint-based solutions for PMO data capture and workflow needs.
• Use Python scripts, APIs or React-based components when standard Power Platform capability is not sufficient.
• Work with PMO, Project Managers, HR and Operations to clarify requirements, prototype solutions and incorporate feedback.
• Validate and reconcile data, manage access controls, document solutions, support users and deliver controlled enhancements.

Skills

Analytical thinking

Stakeholder communication

Ownership

Documentation

Tools

Power BI

DAX

Power Query

SQL

Excel

PivotTables

Python scripting

Job description

Netwoven is seeking a Power BI-focused analyst to build, maintain and advance PMO dashboards and data models for governance, resource utilisation, demand and forecasting. You will connect data from Excel, SharePoint Online and SQL sources, develop DAX measures, and ensure secure, refreshed reporting models.

You will collaborate with PMO, Project Managers, HR and Operations to translate requirements into practical solutions, document processes, and deliver controlled enhancements.