Data Analyst: Executive Dashboards & Forecasting

Alderson Loop; Baltimore (MD); On-site; USD 90,000 - 120,000; Full time

Job summary

Alderson Loop is hiring a Data Analyst to support enterprise planning, forecasting, and reporting initiatives. The role focuses on transforming operational data into executive dashboards, reports, and actionable insights for leaders.

You will build reporting solutions from scratch, partner with senior leaders, and drive data-driven decision-making across PMO programs with Power BI, Excel, SQL, Planview, and SharePoint.

Qualifications

• Bachelor's degree in Business Analytics, Information Systems, Finance, Mathematics, Statistics, or a related field.
• 7–10 years of experience in data analysis, business reporting, or business intelligence.
• Advanced proficiency in Microsoft Excel, including PivotTables, Power Query, XLOOKUP/INDEX-MATCH, data modeling, and complex formulas.
• Strong experience designing, developing, and maintaining polished, user-friendly executive dashboards using Power BI.
• Experience with Power BI data modeling, DAX, Power Query (M), and data visualization best practices.
• Proficiency in SQL for querying, validating, and analyzing data.
• Experience gathering, transforming, and analyzing data from multiple business systems.
• Ability to identify trends, interpret results, and communicate key findings to business stakeholders.
• Strong understanding of PMO practices, project and program management terminology, and the program management lifecycle.
• Excellent communication and interpersonal skills, with the confidence to independently gather requirements from and present findings to senior leaders.

Responsibilities

• Develop, maintain, and enhance executive dashboards and reports using Power BI for planning, forecasting, and decision-making.
• Analyze large datasets using Excel and other tools to identify trends and actionable insights.
• Build reporting solutions by combining data from Planview, SharePoint, and other systems.
• Interpret data findings and summarize results for business leaders and stakeholders.
• Partner with senior project and program leaders to gather requirements and translate them into dashboards and visuals.
• Support planning and forecasting by organizing and presenting data accessibly.
• Respond to real-time data requests and resolve ambiguous business needs with recommendations.
• Develop reporting related to resource capacity, project roll-off timing, initiative status, execution trends, and overall program performance.

Skills

Data analysis

Executive reporting

PMO understanding

Stakeholder communication

Education

Bachelor's degree in Business Analytics, Information Systems, Finance, Mathematics or Statistics

Tools

Power BI

Excel (PivotTables, Power Query, XLOOKUP/INDEX-MATCH)

SQL

Planview

SharePoint

Job description

Alderson Loop is hiring a Data Analyst to support enterprise planning, forecasting, and reporting initiatives. The role focuses on transforming operational data into executive dashboards, reports, and actionable insights for leaders.

You will build reporting solutions from scratch, partner with senior leaders, and drive data-driven decision-making across PMO programs with Power BI, Excel, SQL, Planview, and SharePoint.