Data Analyst – Dashboards, Automation & PMO

Guidehouse; Indiana (PA); On-site; USD 50,000 - 70,000; Full time

Benefits offered by this job

Competitive compensation

Flexible benefits package

Job summary

Guidehouse is seeking a data analyst to manage backend PMO activities and develop advanced reports using Excel and Power BI. The role requires a Bachelor's degree and a minimum of 1 year experience in data analysis.

The successful candidate will support process automation and ensure compliance metrics are accurately tracked. This position is an excellent opportunity to enhance your analytical capabilities in a dynamic environment.

Qualifications

• Minimum 1 year of experience in data analysis, reporting, or backend PMO activities.
• Strong quantitative and analytical skills with the ability to interpret data from multiple sources.
• Excellent communication skills to interact with stakeholders at different levels.

Responsibilities

• Contribute & manage backend PMO activities including project documentation and compliance tracking.
• Develop and maintain reports and dashboards using MS Excel and Power BI.
• Support process automation initiatives using VBA & Macros.

Skills

Data analysis

MS Excel advanced proficiency

VBA and Macros

Power BI

Communication skills

Education

Bachelor’s degree in science, business, IT, Analytics, or related field

Tools

Power BI

SQL development

Python

Job description

Guidehouse is seeking a data analyst to manage backend PMO activities and develop advanced reports using Excel and Power BI. The role requires a Bachelor's degree and a minimum of 1 year experience in data analysis.

The successful candidate will support process automation and ensure compliance metrics are accurately tracked. This position is an excellent opportunity to enhance your analytical capabilities in a dynamic environment.