Data Business Analyst
@ Pantheon

London, England, United Kingdom
£100,000
On Site
Full Time
Posted 4 days ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXXX XXXXXXXXXXXXX XXXXXX****** @pantheon.com
Recommended after applying

Job Details

About Pantheon

Pantheon has been at the forefront of private markets investing for over 40 years, delivering innovative solutions covering the full lifecycle of investments. With over 650 clients and approximately $65bn in discretionary assets, the firm operates globally across Europe, the Americas, and Asia.

Purpose of Position

The Data Business Analyst will join the Transformation Delivery team to support organizational change. This role is permanent and provides the opportunity to engage with multiple levels of the business, supporting projects ranging from strategy and architecture to systems development and implementation. The candidate will work on key data-focused projects, including Data Warehouse changes and broader transformation initiatives.

Key Responsibilities

  • Run workshops to gather reporting and analytical requirements.
  • Create detailed requirements documents and data maps.
  • Establish data rules, process flows, and entity relationships.
  • Collaborate with technology and business partners to validate solutions.
  • Provide ongoing training, support, and progress reporting.

Knowledge & Experience Required

Candidates must have a strong background in large data projects using tools like Power BI, SQL, Excel, Azure Data Bricks, Informatica, and ETL platforms. Experience with backlog management (Azure DevOps or Jira), business transformation, waterfall and agile life cycles, and stakeholder management is essential. Familiarity with financial services, particularly in Private Equity or Fund Management, is highly desirable.

Key Skills/Competency

  • Data Analysis
  • Business Process
  • Power BI
  • SQL
  • Excel
  • ETL Platforms
  • Stakeholder Management
  • Transformation
  • Agile
  • Workshop Facilitation

How to Get Hired at Pantheon

🎯 Tips for Getting Hired

  • Customize your resume: Tailor your experience to data transformation projects.
  • Highlight technical skills: Emphasize SQL, Power BI, and ETL experience.
  • Showcase workshop experience: Detail stakeholder engagement and requirement gathering.
  • Prepare for interviews: Practice explaining complex data projects clearly.

📝 Interview Preparation Advice

Technical Preparation

Review SQL query optimization and complex joins.
Practice using Power BI dashboards and ETL tools.
Study data modeling and warehousing fundamentals.
Familiarize with Azure Data Bricks or similar platforms.

Behavioral Questions

Describe workshop facilitation experiences.
Explain stakeholder communication strategies.
Discuss conflict resolution in projects.
Share examples of independent problem solving.

Frequently Asked Questions