Lead - Data Analyst

Guidehouse India Pvt Ltd; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Guidehouse India is seeking a data analytics professional to design and implement dashboards, model data, and translate business requirements into reports from multiple sources. You will collaborate with specialists to build scalable solutions and ensure data is stored and processed efficiently.

You should have 5+ years of hands-on experience, a CS/IT degree, and strong SQL, Power BI, and Excel skills. Willingness to work in shifts and from office in Chennai area is required.

Qualifications

• Minimum 5 years of hands-on data analytics and reporting experience.
• Bachelor’s in CS/IT or related field.
• Proficient in SQL, Excel, Access, and Power BI.
• Strong data modelling experience and analytical problem solving.
• Excellent communication and collaboration skills.

Responsibilities

• Design and implement dashboards from multiple data sources to meet user needs.
• Structure data via data modelling and assist with schema design.
• Collate, prepare, and present statistical information for internal and external use.
• Provide technical assistance and cross-training to team members.

Skills

SQL

Power BI

Data Modelling

Data Analytics

Excel

Communication

Python

Education

Bachelor’s in Computer Science/ IT or related stream

Tools

MS Access

SQL Server

Power BI

Job description

Job Family:EBO Management Information System (India)Travel Required:NoneClearance Required:NoneWhat You Will Do:Design and implement dashboards that meet the need and expectation of all its usersEnsure all data is intelligently stored and processedTranslate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sourcesParticipate with other specialist/leads/managers to understand reporting requirements and work on building solutions or reporting system as per business needsStructure company data, do Data Modelling and assist with schema design.Collate, prepare, and present statistical information for internal and external useProvide technical assistance and cross training to other team membersWhat You Will Need:Minimum 5 years of hands-on experience into Data analytics and reportingMust have a bachelor’s in computer science/ IT or any other related streamsProficient with SQL, MS Office Applications like Excel, Access, Power BIExcellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teamsExperience on Data ModellingRequires strong analytical, conceptual, and problem-solving skillsAbility to manage multiple priorities and assess and adjust quickly to changing prioritiesWhat Would Be Nice To Have:Reporting and Analysis experience in Power BIVBA Develop automation scripts using Excel Macros.MS Excel Expertise in Excel reporting and dashboards.MS Access database and application development.Communicate seamlessly with Client Business lines, Leadership team and other internal stakeholders.Willing to work in rotational shifts and mandatory work from office.Good to have but not mandatory – Python, Power Automate, Power Apps.About 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.