Business Intelligence Analyst

Troy Consulting LLC is an IT and management consultancy that focuses on helping organizations achieve measurable success through data-driven strategies. They are seeking an experienced Business Intelligence Analyst to design and maintain performance reporting frameworks that enable effective decision-making across the organization.

Responsibilities:

• Partner with business stakeholders to define, document, and standardize KPIs aligned with organizational objectives
• Design, develop, and maintain dashboards, scorecards, and recurring performance reports for operational, management, and executive audiences
• Analyze KPI trends, variances, and key performance drivers; provide actionable insights and recommendations
• Ensure data accuracy, integrity, and consistency across reporting solutions and source systems
• Automate reporting processes to improve scalability, efficiency, and reliability
• Develop compelling data visualizations and business narratives tailored to technical and non-technical stakeholders
• Establish reporting governance, metric definitions, and KPI documentation standards
• Support ad hoc reporting, business analysis, and deep-dive investigations
• Continuously evaluate and enhance KPI frameworks to align with evolving business priorities
• Collaborate with cross-functional teams to improve data quality and reporting effectiveness

Requirements:

• Bachelor's degree in Business, Finance, Analytics, Information Systems, or a related field
• 8–10 years of experience in Business Intelligence, Analytics, Reporting, or Performance Management
• Advanced experience with Power BI, including dashboard development and report optimization
• Advanced Microsoft Excel skills
• Working knowledge of SQL and data modeling concepts
• Demonstrated experience translating business questions into measurable KPIs and performance metrics
• Strong analytical, problem-solving, and critical-thinking abilities
• Excellent communication and presentation skills with the ability to influence stakeholders at multiple levels
• High attention to detail and commitment to data accuracy
• Experience supporting Operations, Finance, Procurement, Supply Chain, or Shared Services organizations
• Familiarity with KPI governance, metric standardization, and reporting best practices
• Experience working with large, complex datasets from multiple enterprise systems
• Understanding of reporting automation and self-service analytics
• Ability to thrive in a fast-paced, evolving business environment