Business Intelligence Analyst

Role Overview

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

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.
• Experience with Deltek Vantagepoint or similar ERP/project-based systems (Preferred).
• Familiarity with ADP data structures or HRIS systems (Preferred).
• Experience with .NET framework and Visual Studio (Preferred).
• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or a related field (Preferred).

Tech Stack

• ERP
• SQL
• .NET

Benefits

• Flexible Work Schedule
• Health/Dental Insurance
• 401k Plan with Employer Match
• Paid Parental Leave
• Short & Long Term Disability
• Profit Sharing
• Paid Time Off
• Leadership Development Program
• Fitness Reimbursement
• Tuition Reimbursement
• Referral Bonus Program
• Wellness Program
• Team Building Events
• Community Service Events