Senior Business Intelligence Analyst

Given the hybrid nature of the role, only candidates local to Massachusetts will be considered; relocation and sponsorship are not available at this time.

About the role

As a Senior BI Analyst you will be a trusted business partner for Pega’s global consulting organization and key member of the Operations team. You will collaborate with the management team to design, build, and maintain the Power BI reporting suite covering consultant utilization, headcount, and profitability-related metrics. You will also lead and collaborate on projects pursuing company-wide strategic objectives. You will own the data governance and provide oversight of all business processes and systems that support these metrics. You will also collaborate with cross-functional teams to drive productivity and efficiency of our business systems and reporting capabilities. The insights you deliver to the leadership team will provide key performance metrics and actionable findings required for the consulting business to meet its business objectives.

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

Requirements

• Fluent in Power BI — you think in data models, DAX measures, and clean, executive-ready visual design
• Superb problem solving and analytical skills paired with an attention to detail
• Ability to balance long term strategic projects with day-to-day operational responsibilities
• Experience blending quantitative analysis with qualitative analysis to deliver a complete look at a problem, subsequent analysis, and recommendations
• Skilled communicator; able convey ideas to technical stakeholders as well as senior leadership in person or in writing
• Must be resilient in the face of obstacles; possess the ability to adapt to changing circumstances

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
• Proven ability to own projects from inception to delivery

Benefits

• Gartner Analyst acclaimed technology leadership across our categories of products
• Continuous learning and development opportunities
• An innovative, inclusive, agile, flexible, and fun work environment
• Competitive global benefits program inclusive of pay + bonus incentive, employee equity in the company

Pay

Base salary range for this role is 84,200 - 125,800 USD annually. This role may also be eligible for annual bonus OR commission, as well as benefits and other incentives. The final compensation will be determined during the offer process based on the candidate's education, experience, skills, and qualifications, as well as market conditions and may vary from the posted range. We will share an information on benefits, bonus/commission, and other pay components for this role at the relevant recruitment stage.