Project Portfolio Data Analyst

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

Job Description

Designs, creates, and delivers systemic solutions to support governance of the enterprise project portfolio policies, processes, procedure and methodology.

Job Grade

4

Job Tier

3

Career Area

Retail Specialist

Supervisor

No

Job Qualifications

Five years of experience extracting and reporting on large volume of data using data analysis and reporting tools (such as SQL, SAS, Power BI, etc.) is required. Experience in project management preferred.

OR

Bachelor's degree and three years of experience extracting and reporting on large volume of data using data analysis and reporting tools (such as SQL, SAS, Power BI, etc.) is required. Experience in project management preferred.

Degree (one Of)

• BACHELOR OF BUSINESS ADMINISTRATION - Preferred

Major/Minor (one Of)

• BUSINESS - Preferred


• ENGINEERING - Preferred


• MATHEMATICS - Preferred


• STATISTICS - Preferred

Certificate/License (one Of)

• CERTIFIED BUSINESS ANALYST PROFESSIONAL (CBAP) - Preferred


• PMI PROFESSIONAL IN BUSINESS ANALYSIS (PMI-PBA) - Preferred


• PROJECT MGMT PROFESSIONAL CERT - Preferred

Work – Onsite (HQ – Dallas, Texas)

• Remote/Telework not authorized per Presidential Memorandum “Return to In Person Work”


• PCS Not Authorized/LSP Not Authorized

Required

• Executing queries to pull project-related data from financial and programmatic databases such as Microsoft Project Server Subscription Edition


• Report generation and analysis to identify trends, risks, and issues to the portfolio and to individual projects in the portfolio


• Development of user interfaces to underlying databases


• SharePoint file and metadata entry and management


• Pivot table (Excel, Hyperion, etc.) experience


• Experience with project management tools (Microsoft Project, Planner, Project Server, Jira, etc.)


• Ability to identify trends, find root causes of problematic trends, and recommend solutions to problematic trends

Preferred

• Experience leveraging generative artificial intelligence to accelerate solution (systems, interfaces, reports) implementation and trend analysis


• Desire to earn Project Management Professional (PMP) or PMI Professional in Business Analysis (PMI-PBA) Certification


• Collaborative, team-based approach to decision making


• Process improvement (mapping, analysis, redesign, and documentation)

Major Duties

Derives project and portfolio data insights and assesses methods to measure project performance.

Supports data driven business decisions by developing both standard and adhoc dashboards, reports, graphs, and charts using statistical analytics and methodologies.

Compiles and transforms information into consumable formats by retrieving large data sets from multiple sources such as electronic documents, databases and systems.

Creates, updates, and maintains user interfaces that allow for entry of project and portfolio data into a common repository.

Manages and maintains project and portfolio data as well as solutions to ensure data integrity as well as availability through continual monitoring, tracking, and analysis.

Provides guidance on proper use of the systemic solutions implemented.

Performs other duties as assigned.

Job Type

Management

Number of Positions Remaining

1

05-Nov-2026