Data Analyst

Guidehouse · Marion County, IN · 2 mo ago

On-siteInformation TechnologyFull-time

Contribute & Manage backend PMO activities (Timesheet Management, Invoice Oversight, SubK & Roster Management, Laptop/Resource Management, Expenses, EDSP & other Compliance Requirements), including project documentation, governance, and compliance tracking
Develop and maintain advanced reports and dashboards using MS Excel and Power BI to deliver actionable insights
Perform internal data analysis and quality checks; interpret results and communicate findings to business stakeholders
Support process automation initiatives using VBA & Macros, and Data Modelling & Transformation using Power Pivot and Power Query
Transcribe and report collected information into client-ready formats with accuracy and timeliness
Design and implement technology best practices, guidelines, and repeatable processes for reporting and automation
Work independently with low to moderate supervision while ensuring deadlines and accuracy of deliverables are consistently met

Bachelor’s degree in science, business, IT, Analytics, or related field
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 and deliver actionable insights
Advanced proficiency in MS Excel (Power Pivot, Power Query, formulas, macros) and solid knowledge of Microsoft Office Suite (Word, PowerPoint, Outlook)
Working knowledge of PowerBI for dashboard creation and VBA for Process Automation
Excellent communication skills to interact with stakeholders at different levels and present clear, data-driven recommendations
Able to anticipate potential issues, troubleshoot problems, and develop effective solutions proactively
Experience in analyzing and reporting data to identify trends, exceptions, and opportunities for process improvement

Similar jobs