Senior BI Analyst — Power BI & Profitability Insights

Pegasystems; Northern (KY); Hybrid; USD 84,000 - 126,000; Full time

Benefits offered by this job

Annual bonus or commission

Employee equity

Benefits program

Job summary

Pegasystems is seeking a Senior BI Analyst to partner with our global consulting organization and Operations team. You will design, build, and maintain the Power BI reporting suite covering consultant utilization, headcount, and profitability metrics.

You will own data governance and oversee business processes and systems supporting these metrics, collaborating with cross-functional teams to improve productivity and reporting capabilities for leadership.

Qualifications

• 3-5 years of experience as a BI analyst, data analyst, or finance analyst building reporting in Power BI.
• Built and maintained Power BI reporting on profit and loss data from multiple sources, preferably in professional services or finance functions.
• Worked with senior leadership to advise on the health of a business.

Responsibilities

• Design, build, and maintain Power BI dashboards and semantic models that give Consulting leadership a single source of truth.
• Manage and communicate P&L analytics in Power BI including revenue, expenses, margin, utilization, headcount, for all Pega Consulting to drive profitability.
• Automate monthly and ad hoc financial reporting through Power BI datasets, scheduled refreshes, and paginated reports.
• Be a key member in the budget, planning & forecasting process.
• Design, develop, and deliver reporting using Excel, Power BI, HANA, and other in-house systems to provide proactive analysis and insights to the business leadership.
• Work with Consulting leadership community to research, advocate, and make recommendations on business process improvements to drive user adoption of our systems and processes.
• Directly communicate with senior leadership about major profitability drivers.
• Support, collaborate, and lead with Operations team on projects and initiatives as needed.
• Collaborate with Operations team on reporting best practices

Skills

Power BI

DAX

Data modeling

Analytical

Communication

Resilience

Tools

Excel

HANA

Power BI

Job description

Pegasystems is seeking a Senior BI Analyst to partner with our global consulting organization and Operations team. You will design, build, and maintain the Power BI reporting suite covering consultant utilization, headcount, and profitability metrics.

You will own data governance and oversee business processes and systems supporting these metrics, collaborating with cross-functional teams to improve productivity and reporting capabilities for leadership.