Lead - Data Analyst

Guidehouse; Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

Competitive compensation

Learning & development programs

Well-being programs

Job summary

Guidehouse India is seeking a data analytics professional to design and implement dashboards that meet user needs, ensure data is stored and processed correctly, and translate business requirements into cross-source reports.

You will collaborate with leads and stakeholders to build solutions, perform data modelling, present statistical information, and provide technical training to team members; strong SQL, Power BI and Excel skills are essential and office presence is required.

Qualifications

• Minimum 5 years of hands-on experience in data analytics and reporting.
• Bachelor's in Computer Science/IT or related field.
• Proficient with SQL, MS Excel, Access, and Power BI.
• Excellent interpersonal and written communication skills.
• Experience in Data Modelling.
• Strong analytical, conceptual, and problem-solving skills.

Responsibilities

• Design and implement dashboards that meet the need and expectation of all its users
• Ensure all data is intelligently stored and processed
• Translate business requirements into specifications for reports and dashboards from multiple data sources
• Collaborate with specialists/leads/managers to understand reporting requirements and build solutions
• Structure company data, perform 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 other team members

Skills

Data analytics

Data modelling

Analytical thinking

Communication skills

Prioritization

Education

Bachelor's in Computer Science/IT or related field

Tools

SQL

Power BI

MS Excel

MS Access

Job description

Job Description

Job Family

EBO Management Information System (India)

Travel Required

None

Clearance Required

None

What You Will Do

• Design and implement dashboards that meet the need and expectation of all its users
• Ensure all data is intelligently stored and processed
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
• Participate with other specialist/leads/managers to understand reporting requirements and work on building solutions or reporting system as per business needs
• Structure company data, do 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 other team members

What You Will Need

• Minimum 5 years of hands-on experience into Data analytics and reporting
• Must have a bachelor’s in computer science/ IT or any other related streams
• Proficient with SQL, MS Office Applications like Excel, Access, Power BI
• Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
• Experience on Data Modelling
• Requires strong analytical, conceptual, and problem-solving skills
• Ability to manage multiple priorities and assess and adjust quickly to changing priorities

What Would Be Nice To Have

• Reporting and Analysis experience in Power BI
• VBA 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 India

At 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 Offer

At 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.

Requirements