Lead Data Analyst

Guidehouse; Indiana (PA); On-site; USD 85,000 - 125,000; Full time

Job summary

Guidehouse is seeking a data analytics and reporting professional to design and implement dashboards, translate business requirements into reports, and ensure data is stored and processed effectively.

You will collaborate with leads to build solutions, model data schemas, present statistics, and provide cross-training, leveraging SQL, Excel and Power BI, while managing multiple priorities in a fast-paced environment.

Qualifications

• 5+ years of hands-on experience in data analytics and reporting.
• Bachelor's degree in computer science, IT or related field.
• Proficient with SQL and MS Office applications including Excel, Access, and Power BI.
• Strong interpersonal and written communication skills for cross-functional collaboration.
• Experience in data modeling and solid analytical, problem-solving abilities.
• Ability to manage multiple priorities and adapt quickly to changing needs.

Responsibilities

• Design and implement dashboards that meet user needs.
• Ensure data is intelligently stored and processed.
• Translate business requirements into specifications for reports and dashboards.
• Collaborate with specialists/leads/managers to build solutions.
• Structure company data, perform data modeling, 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

Excel

MS Access

Data modeling

Analytical skills

Communication skills

Priorities management

Bachelor's in CS/IT or related

Education

Bachelor's degree in computer science, IT or related stream

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 needs and expectations 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 specialists/leads/managers to understand reporting requirements and work on building solutions or reporting systems as per business needs
• Structure company data, do data modeling 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 in data analytics and reporting
• Must have a bachelor’s in computer science, IT or any other related stream
• Proficient with SQL, MS Office applications like Excel, Access, Power BI
• Excellent interpersonal (verbal and written) communication skills to support working in project environments that include internal, external and customer teams
• Experience in data modeling
• 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 for developing 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

Benefits

We offer competitive compensation and a comprehensive benefits package designed to help you thrive both inside and outside the workplace. Our benefits include in‑house physician consultations, nutritious food options at the workplace, confidential counseling through the Employee Assistance Program, and 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.