Summary
Location
Overland Park, Atlanta, Tampa, Knoxville, Brentwood, Charlotte
Type
full-time
Are you the employer? Manage your company page directly.
About this role
PYA is seeking a Staff Consultant to join its high-performing and privately-owned firm with a dynamic culture and a strong national reputation. This individual will contribute to the success of the firm and PYA Consulting clients. We are looking for someone who is passionate about data and committed to providing solutions for our clients.
RESPONSIBILITIES
- Develop data analytics solutions using Power BI dashboards by accessing various data sources to create actionable and interactive data visualizations and models to empower our clients to be Decision Ready
- Analyze healthcare claims and datasets to identify issues/trends and develop alternatives to support business objectives
- Design methods to enhance and streamline existing data flow tasks
- Work with teammates to identify, evaluate, and implement creative yet practical solutions based on client needs
QUALIFICATIONS
- Minimum of 1 year analytical or business intelligence experience in a corporate or healthcare setting required, including:
- Ability to create and modify T-SQL queries and implement DAX calculations for complex business logic
- Experience with Power Query or other relevant data transformation tools
- Advanced MS Excel & Power BI dashboard knowledge
- Programming experience preferred
- Fluency in a scripting language preferred
- Creative solver of complex problems, with a high level of strategic, analytical, and conceptual skills and the ability to work independently to develop solutions
- Excellent written and oral communication skills
- Passion for helping clients achieve success
ABOUT PYA
PYA, a leading professional services firm, serves clients across the United States with expertise in healthcare consulting, accounting, compliance, and business strategy. With offices in Knoxville, Atlanta, Tampa, Charlotte, Nashville, and Kansas City, PYA is committed to helping clients achieve their goals through innovative solutions and unparalleled service. Learn more about The PYA Way.
WHY JOIN PYA
- Be part of a dynamic and collaborative team that values innovation and excellence
- Work with industry leaders who are committed to professional growth and client success
- Competitive compensation, comprehensive benefits, and opportunities for career advancement
Other facts
About PYA P C
PYA is a nationally recognized professional services firm delivering deep expertise in healthcare consulting, business advisory accounting, tax, and audit & assurance. For over 40 years, we’ve helped organizations across all 50 states navigate complex challenges and seize strategic opportunities.
Ranked among the Top 20 healthcare consulting firms by Modern Healthcare and a Top 100 accounting firm by INSIDE Public Accounting, PYA is a trusted advisor to some of the nation’s largest health systems, financial institutions, and private enterprises. Law firms across the country regularly turn to PYA as a trusted resource for their clients, recognizing our deep technical expertise and commitment to integrity.
Our independence empowers us to prioritize client success above all else—offering objective insights, responsive service, and long-term partnership.
From regulatory compliance and fair market value assessments to mergers & acquisitions and operations optimization, our multidisciplinary teams deliver tailored solutions that drive measurable results. We serve clients in healthcare, finance, hospitality, technology, private equity, manufacturing, and construction.
At PYA, HELP is our culture and relationships are our passion. We don’t just solve problems—we serve to solve.
📍 Offices in Atlanta, Charlotte, Kansas City, Knoxville, Nashville, and Tampa
What you'll do
- The Staff Consultant will develop data analytics solutions using Power BI dashboards and analyze healthcare claims to identify trends. They will also design methods to enhance data flow tasks and collaborate with teammates to implement solutions.
Join Clera's Talent Pool
Get matched with similar opportunities at top startups
This role is hosted on PYA P C's careers site.
Join our talent pool first to get notified about similar roles that match your profile.