Business Intelligence Analyst

LaBella Associates•Rochester, NY

About The Position

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.

Requirements

2–5 years of experience in data analytics, business intelligence, or a related role.
Strong proficiency in Power BI or similar visualization platform, including dashboard development, data modeling and DAX.
Experience with Microsoft Power Platform, particularly Power Automate.
Solid understanding of relational databases (joins, keys, normalization, table relationships).
Experience working with SQL Server or similar database systems.
Strong analytical and problem-solving skills with attention to detail.
Ability to translate data into meaningful insights to support business decisions.
Strong organizational skills and ability to work independently.

Nice To Haves

Experience with Deltek Vantagepoint or similar ERP/project-based systems.
Familiarity with ADP data structures or HRIS systems.
Experience with .NET framework and Visual Studio.
Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or a related field.

Responsibilities

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.
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.
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.
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.
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.