Senior Consultant - Business Intelligence & Analytics

PYA is seeking a Senior 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 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
• Possess an in-depth understanding of underlying data, data structures, and business uses to ensure dashboards/reports meet client needs

Qualifications

• 2+ years of Business Intelligence experience in a corporate or healthcare setting required
  • Ability to create and modify T-SQL queries
  • Proficient with ETL processes using SSIS / Power Query or other relevant tools
  • Implement DAX calculations for complex business logic
  • Advanced MS Excel & Power BI 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
• Team player with a demonstrated track record in project management
• Willingness and ability to travel for client projects and development opportunities

About PYA

Serving clients in all 50 states from offices in seven cities, PYA is ranked by INSIDE Public Accounting as one of the nation’s Top 100 largest CPA firms, with the third-highest percentage of female ownership within that group. Forbes has recognized PYA one of America’s Best Tax and Accounting Firms for the last two years. Accounting Today has highlighted PYA as “One of the most successful firms in the country.” Modern Healthcare ranks PYA among the nation’s Top 20 healthcare consulting firms, and PYA is one of the Top 15 auditors of the nation’s largest health systems.

This success is the result of four decades of steadfast adherence to a culture of responsiveness, integrity and relationships—both with clients and colleagues—"The PYA Way.”

Learn more at pyapc.com.