Portfolio Data Analyst: Insights, Dashboards & PM Tools

The Exchange; Dallas (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

The Exchange in Dallas seeks a data-driven professional to design and deliver systemic solutions for governance of the enterprise project portfolio, including policies, processes, and methodology. You will extract and analyze project data, build dashboards using Power BI, and provide interfaces to databases such as Microsoft Project Server and SharePoint to support program decisions.

Qualifications include five years of data extraction and reporting experience (SQL, SAS, Power BI) or a

Qualifications

• Experience extracting and reporting on large volumes of data using data analysis tools (SQL, SAS, Power BI, etc.).
• Experience in project management preferred.
• Bachelor's degree and 3 years of experience extracting and reporting on large volumes of data using data analysis tools (SQL, SAS, Power BI, etc.).
• Experience in project management preferred.

Responsibilities

• Derives project and portfolio data insights.
• Develops dashboards, reports, graphs, and charts using statistical analytics.
• Compiles and transforms information from multiple sources into consumable formats.
• Creates and maintains interfaces for entry of project data into a common repository.
• Manages and maintains portfolio data and data integrity.

Skills

SQL

Power BI

Excel

Jira

Data visualization

Education

Bachelor's degree

Tools

Microsoft Project Server

SharePoint

Hyperion

Planner

Jira

Job description

The Exchange in Dallas seeks a data-driven professional to design and deliver systemic solutions for governance of the enterprise project portfolio, including policies, processes, and methodology. You will extract and analyze project data, build dashboards using Power BI, and provide interfaces to databases such as Microsoft Project Server and SharePoint to support program decisions.

Qualifications include five years of data extraction and reporting experience (SQL, SAS, Power BI) or a