Senior Specialist, Business Intelligence

When you're the best, we're the best. We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authentic selves. We provide extensive opportunities for personal and professional development, building both employee competence and organizational capability to fuel exceptional performance through an inclusive environment both now and in the future.

Senior Specialist, Business Intelligence

The Organization

We help society's foundational healthcare institutions to achieve their full potential in service to others.

We are our clients' trusted partners in ever-changing times. For nearly 40 years, Kaufman Hall has provided independent, objective insights grounded in sound data and analysis to help clients fulfill their missions, achieve their goals, and tackle their toughest problems.

Kaufman Hall provides world-class management consulting in Strategy & Business Transformation, Financial Planning & Data Analytics, Treasury & Capital Markets, Mergers & Acquisitions, Revenue & Operations Improvement, and Clinical Solutions.

At Kaufman Hall, we believe that sustained success is never an accident. It is the result of sound decision making, based on data-driven analysis and disciplined thinking, and guided by the fundamental principles of corporate finance.

The Position

Kaufman, Hall & Associates, LLC, is seeking a Senior Specialist, Business Intelligence will support consulting operations by developing, maintaining, and enhancing internal reporting across sales, resource management, and project operations. This role will also automate key business processes that improve efficiency, reduce manual work, and support the consulting operations team.

This individual will partner closely with consulting business unit leaders, operations, finance, sales, and technology teams to translate business requirements into accurate reporting, analytical models, and actionable insights. The role requires experience working with large, complex datasets from multiple business systems, along with strong analytical, problem-solving, and critical thinking skills.

The ideal candidate is technically strong, business-minded, detail-oriented, and committed to data quality, accuracy, and consistency. They can communicate technical concepts clearly to technical and non-technical stakeholders, manage multiple priorities independently, meet deadlines, and collaborate across functions to create reporting solutions that support better business decision-making.

Key Responsibilities

• Develop, maintain, and enhance Power BI dashboards and reports focused on sales performance, resource management, and project financial
• Use SQL, Databricks, Power Query, Excel, and other tools to extract, transform, clean, validate, and analyze data from multiple systems
• Build and maintain scalable data models that support accurate, timely, and consistent business reporting
• Automate recurring reporting, manual processes, and operational workflows to improve efficiency and reduce administrative burden
• Partner with consulting business unit leaders to understand reporting needs, define key performance indicators, and deliver insights to support decision-making
• Support the consulting operations team by identifying opportunities to improve processes, data quality, reporting accuracy, and workflow consistency
• Collaborate with finance, sales operations, resource management, project delivery, and technology teams to ensure alignment in reporting requirements and data usage
• Perform ad hoc analysis to answer business questions, identify trends, highlight risks, and uncover opportunities for operational improvement
• Monitor report performance, troubleshoot data issues, and implement enhancements to improve usability, reliability, and scalability
• Create and maintain documentation for reports, data definitions, business logic, workflows, and standard operating procedures
• Promote best practices in data visualization, dashboard design, data governance, and self-service analytics to drive continuous improvement in business intelligence

Required Qualifications

• Bachelor's degree in data science, mathematics, statistics, finance, computer science, information systems, business analytics, or a related field
• 3-5 years of professional experience in business intelligence, data analytics, finance or a related role
• Strong experience developing dashboards, reports, and data models in Power BI
• Excellent SQL skills, including experience with Apache Spark SQL and T-SQL
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, data modeling, and analysis
• Proficiency in at least one programming language, such as Python or R
• Strong experience with Power Query for data transformation, automation, and reporting support
• Experience working with large, complex datasets from multiple business systems
• Ability to translate business requirements into reporting solutions, analytical models, and actionable insights
• High attention to detail and a strong commitment to data accuracy, quality, and consistency
• Ability to communicate technical concepts clearly to both technical and non-technical stakeholders
• Experience managing multiple priorities, meeting deadlines, and working independently in a fast-paced environment
• Strong analytical, problem-solving, and critical thinking skills
• A reporting portfolio demonstrating experience designing dashboards, reports, data models, and analytical solutions, preferably including examples of Power BI reporting and data visualization
• Applicants for employment must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States and with Kaufman Hall (i.e., H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status)

Preferred Qualifications

• Experience with Databricks or similar cloud-based data platforms
• Experience with Microsoft Dynamics, particularly in a sales, finance, project, or operations reporting context
• Experience with Microsoft Power Apps or Power Automate
• Experience supporting consulting, professional services, project-based, or resource-based business models
• Familiarity with project financial metrics, utilization, revenue forecasting, resource planning, pipeline reporting, and operational performance management
• Experience designing automated workflows, data validation processes, or reporting control
• Knowledge of data governance, semantic modeling, DAX, and Power BI service administration
• Experience partnering with senior business leaders to develop executive-level reporting and insights

Education

• Bachelor's degree required

Physical Requirements

• Must be able to perform essential duties satisfactorily with reasonable accommodations
• Work is generally done sitting, talking, hearing and typing. Visual acuity to use a keyboard, prepare and analyze data and figures; transcribing, viewing a computer terminal; extensive reading

Work Environment

• Travel Required: Occasional 0-10%
• The role is based in Chicago, Denver, or Irving and requires 3 days per week in office.
• Work is regularly performed in a combination of office and home office settings, and routinely uses standard office equipment
• It may require the maintenance of a home office and proximity to an airport for work related travel

At Vizient, we consider skills, experience, and organizational needs in our compensation approach. Geographic factors may adjust the range estimate and hires typically fall below the top range. Compensation decisions are tailored to individual circumstances. The current salary range for this role is $77,400 to $135,400.

Kaufman Hall is committed to providing equal opportunity for all employees and applicants. We recruit, hire, train, promote, pay, and administer all employment actions without regard to actual and also perceived or assumed protected group status as defined by law of an individual or that individual's associates or relatives. Our policies and the law prohibit employment discrimination against any employee or applicant on the basis of any legally protected status.

Estimated Hiring Range:

This position is also incentive eligible.

Vizient has a comprehensive benefits plan! Please view our benefits here:

http://www.vizientinc.com/about-us/careers

Equal Opportunity Employer: Females/Minorities/Veterans/Individuals with Disabilities

The Company is committed to equal employment opportunity to all employees and applicants without regard to race, religion, color, gender identity, ethnicity, age, national origin, sexual orientation, disability status, veteran status or any other category protected by applicable law.