IT PMO Analyst

Madison-Davis, LLC; New York (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

A consulting firm in New York seeks a candidate with advanced Excel skills to analyze extensive datasets and present insights for leadership. The role involves developing reports and visual presentations, supporting workforce planning, and translating technology updates into summaries. Ideal candidates will have experience with data reporting and visualization tools such as Power BI or Tableau. Strong communication skills and the ability to manage multiple priorities in a fast-paced environment are essential.

Qualifications

• Background in business analysis, business management, PMO support, or data reporting roles.
• Experience preparing dashboards or structured reporting for leadership.
• Understanding of IT concepts, data governance, or technology portfolio management.

Responsibilities

• Analyze large datasets to identify trends, risks, and operational insights.
• Develop clear reporting, dashboards, and visual presentations for leadership.
• Collaborate across teams to support program updates and communication.

Skills

Advanced Excel skills including pivots, lookups, modeling, and macros

Strong communication skills

Experience analyzing complex datasets

Ability to work independently

Familiarity with technology environments

Experience with Power BI or Tableau

Tools

Power BI

Tableau

Job description

• Analyze large datasets to identify trends, risks, and operational insights
• Develop clear reporting, dashboards, and visual presentations for leadership
• Support portfolio oversight, workforce planning, and initiative tracking
• Translate technology updates into business-focused summaries and recommendations
• Maintain data accuracy and consistency across multiple sources
• Prepare materials for executive reviews and governance meetings
• Collaborate across teams to support program updates and communication
• Monitor KPIs and performance indicators tied to technology initiatives

What You Bring

• Advanced Excel skills including pivots, lookups, modeling, and macros
• Experience analyzing complex datasets and presenting clear business insights
• Strong communication skills with the ability to distill information for non-technical audiences
• Background in business analysis, business management, PMO support, or data reporting roles
• Ability to work independently, manage multiple priorities, and meet tight deadlines
• Experience preparing dashboards or structured reporting for leadership
• Familiarity with technology environments and project status reporting
• Experience with Power BI, Tableau, or similar visualization tools
• Understanding of IT concepts, data governance, or technology portfolio management
• Prior experience supporting CIO, COO, or central business management functions