Data Analyst

Guidehouse India Pvt Ltd; Thiruvananthapuram; On-site; INR 400,000 - 640,000; Full time

Job summary

Guidehouse India Pvt Ltd in India seeks a data analysis professional to develop MIS reports and dashboards and support backend PMO activities. You will design reports using MS Excel, Power Pivot, and Power Query, automate processes with VBA, and transform data for client-ready outputs.

You will interact with stakeholders, maintain data quality, and drive process improvements in a fast-paced environment across India.

Qualifications

• Bachelor’s degree in science, business, IT, Analytics, or related field.
• Minimum 1 year of experience in data analysis, MIS reporting & analysis, or backend PMO activities.
• Strong quantitative and analytical skills with data interpretation and insights.

Responsibilities

• Understand client requirements, break them into tasks, and define solutions with the team.
• Contribute to backend PMO activities including timesheet, invoice, and roster management.
• Develop advanced reports and dashboards using MS Excel, Power Pivot, and Power Query.
• Perform data analysis, quality checks, and share findings with stakeholders.
• Support process automation using VBA and model data in Power BI.
• Transcribe information into client-ready formats with accuracy and timeliness.
• Design technology best practices and repeatable reporting/automation processes.
• Work independently with moderate supervision to meet deadlines.

Skills

MS Excel

Power Pivot

Power Query

Power BI

VBA

Data analysis

Education

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

Tools

Power BI

Power Apps

Power Automate

Job description

Job Family:EBO Management Information System (India)Travel Required:NoneClearance Required:NoneWhat You Will Do:Understand high-level client requirements, break them down into detailed tasks, and collaborate with the team to define solutions; provide recommendations based on qualitative and quantitative analysisContribute & 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 trackingDevelop and maintain advanced reports and dashboards using MS Excel and excellent exposure to MIS Reporting and AnalysisPerform internal data analysis and quality checks; interpret results and communicate findings to business stakeholderSupport process automation initiatives using VBA & Macros, and Data Modelling & Transformation using Power Pivot and Power QueryTranscribe and report collected information into client-ready formats with accuracy and timelinessDesign and implement technology best practices, guidelines, and repeatable processes for reporting and automationWork independently with low to moderate supervision while ensuring deadlines and accuracy of deliverables are consistently metWhat You Will Need:Must have a bachelor’s degree in science, business, IT, Analytics, or related fieldMust have minimum 1 year of experience in data analysis, MIS Reporting & Analysis, or backend PMO activitiesStrong quantitative and analytical skills with the ability to interpret data from multiple sources and deliver actionable insightsAdvanced 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 AutomationExcellent communication skills to interact with stakeholders at different levels and present clear, data-driven recommendationsAbility to anticipate potential issues, troubleshoot problems, and develop effective solutions proactivelyWhat Would Be Nice To HavePower Platform tools (PowerApps, Power Automate) for process automationAbout Guidehouse IndiaAt Guidehouse India, we’re redefining what’s possible by creating opportunities that change lives. Guidehouse is a global professional services firm that delivers advisory, technology, and managed services to clients across both the commercial and public sectors. Our teams turn bold ideas into solutions that transform industries, strengthen communities, and drive meaningful impact worldwide.Across our Chennai, Trivandrum, and Gurugram locations, you’ll find opportunities where your passion and curiosity help shape what comes next. With cutting edge benefits, innovative learning and development programs, and a people first culture, we empower our people to lead with purpose.We continue to expand our teams and capabilities across India, investing in state-of-the-art offices and high impact work. Here, you’ll collaborate with experts from around the world, build deep expertise, explore new domains, and accelerate your professional growth while making a real impact.What We OfferAt Guidehouse India, we are committed to supporting the well-being of our people and their families at every stage of life. We offer competitive compensation and a comprehensive benefits package designed to help you thrive both inside and outside the workplace.Our benefits include resources such as in house physician consultations, nutritious food options at the workplace, and confidential counseling through our Employee Assistance Program, along with other wellness focused offerings that support your overall well being.Our comprehensive learning and development programs ensure you’re continuously upskilled and ready to tackle what’s next, so you can shape your own career path while contributing to meaningful, purpose driven work.Important Fraud NoticeAll official recruitment communications from Guidehouse will come from email addresses ending in @guidehouse.com or @myworkday.com. Guidehouse never charges fees, requests money transfers, or collects payments from educational institutions for recruitment events. Please do not share banking or personal financial information with anyone claiming to represent Guidehouse for hiring purposes.Contact UsIf you have visited our website to explore career opportunities or to apply for a position and have questions, please contact the Guidehouse Recruiting team at [e-mail]. All information you provide will be kept confidential and used only as required to support the recruitment process.To learn more about Guidehouse in India, visit www.guidehouse.com/india.Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.