Business Intelligence Analyst

We are seeking a highly analytical and technically skilled Business Intelligence Analyst to join our Operations Project Delivery team. This role is responsible for developing and maintaining reporting, performance metrics, and automated workflows that support operational decision-making across the organization.

The ideal candidate will have strong expertise in Power BI, Tableau, or similar visualization tool, experience with the Microsoft Power Platform (including Power Automate), and a solid understanding of relational databases and data modeling. This individual will focus on executing data-driven solutions that improve visibility into business performance and streamline internal processes.

This role will support the development of reporting and automation tools used across the company, with a primary focus on operational metrics such as utilization, project financial performance, and budget/schedule variance.

Responsibilities:

Data Analysis & Reporting:

Develop and maintain Power BI dashboards and reports to track key operational performance metrics.

Transform data from systems such as Deltek Vantagepoint and ADP into actionable insights.

Ensure accuracy, consistency, and reliability of reporting outputs.

Identify trends, anomalies, and performance gaps, and provide data-driven recommendations to support operational improvements across the business.

Data Modelling & Database Management:

Design and maintain relational data models to support reporting and analytics.

Define and manage relationships between datasets to ensure efficient and scalable reporting.

Write and optimize queries within SQL Server (as needed) to support data extraction and transformation.

Integrate data from multiple systems into unified reporting structures.

Automation & Workflow Development:

Build and maintain automated workflows to streamline operational processes.

Identify opportunities to reduce manual effort through automation.

Ensure automation solutions are reliable, scalable, and aligned with business needs.

Monitor and troubleshoot workflow performance and resolve issues as they arise.

Technical Development Support:

Support development of internal tools and solutions using .NET framework and Visual Studio where applicable.

Collaborate with IT and other technical teams to support integrations and system enhancements.

Assist in troubleshooting issues related to reporting, data pipelines, and automation workflows.

Collaboration & Execution:

Work closely with Operations leadership to understand reporting and automation needs.

Execute on defined priorities and contribute to the continuous improvement of operational processes.

Operate independently while managing multiple priorities and deadlines.