Senior Specialist, Business Intelligence

Vizient•Chicago, IL

5d•$77,400 - $135,400•Hybrid

About The Position

Kaufman, Hall & Associates, LLC, is seeking a Senior Specialist, Business Intelligence to 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.

Requirements

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)

Nice To Haves

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

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