Business Intelligence Analyst

Main purpose of role

The Business Intelligence Analyst is responsible for transforming complex data into actionable insights that support client-facing strategic decision-making and operational efficiency. This role ensures accurate client-facing analytics, maintains analytical tools, and drives data-driven improvements across client and internal initiatives.

Key responsibilities

• Collaborate with program management office to ensure the accurate and timely production of monthly, quarterly, and annual client reports.

• Complete complex ad-hoc reports to support client requests.

• Learn and apply effective use of Vendor Management Systems (VMS) such as Fieldglass, Beeline, VNDLY, and Coupa, including report preparation and data utilization.

• Analyze data from multiple sources to deliver meaningful insights, recommendations, and conclusions that drive client’s business decisions.

• Maintain and update team tools and documentation to ensure consistency and accuracy of information.

• Stay informed on industry trends and customer benchmarks to provide relevant analysis on a quarterly basis within assigned verticals.

• Design and enhance client-facing Power BI dashboards using API integrations to improve data visualization and accessibility.

• Manage and update client-facing Microsoft Power Pages to ensure current and accurate content.

• Design and implement automation for client production reports and related workflows to reduce manual effort.

• Create rate cards for new clients

• Run market rate analysis requests

Skills required for the role

• Power BI expertise

• SQL and/or Python proficiency

• Data visualization capabilities

• Analytical and critical thinking

• Attention to detail and accuracy

• Advanced Excel skills

• Organizational and problem-solving skills

• Time management

• Data gathering from various sources

• Team collaboration

• Verbal, written, and presentation skills

Educational Requirements

• Bachelor’s Degree in Business Analytics, Data Science, Computer Science, Information Systems, Statistics or Mathematics

Experience

• Minimum of 3 years of experience in business intelligence, data analysis, or market research roles.

• Proven hands-on experience with Power BI and SQL for data visualization and querying.

• Familiarity with data warehouse technologies, data modeling concepts, and working with diverse data sources and APIs.

• Preferred - At least 2 years of experience working with relational and multidimensional database schemas, including writing complex queries.