Senior Data and Operations Analyst - Private Companies

Baillie Gifford Group; City of Edinburgh; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

Baillie Gifford Group is seeking a Senior Data and Operations Analyst for its Private Companies team in Edinburgh. The role focuses on high‑quality data, analytics and management information across the investment lifecycle, with Power BI at the core of reporting and insights.

You will own data quality, develop analytical capabilities, and support deal flow and fund administration data across multiple vehicles, enabling informed decision making and efficient operations.

Qualifications

• Experience as a data analyst or BI analyst in finance/private markets.
• Ability to turn data into clear insights and recommendations.
• Strong problem-solving and data-quality debugging skills.

Responsibilities

• Take ownership of data quality, completeness and usability for Private Companies datasets.
• Build, maintain and improve Power BI dashboards covering portfolio performance, valuations, investment activity and deal flow.
• Improve reporting processes with automated, repeatable solutions and reduce manual effort.
• Develop and maintain the Private Companies deal management data layer from opportunity to completion.
• Ensure data across systems (including iLevel and Snowflake) is reconciled and auditable.

Skills

Power BI

Data analysis

SQL

Data modeling

Stakeholder communication

Tools

Snowflake

iLevel

Excel

Deal management systems

Job description

Senior Data and Operations Analyst - Private Companies## DepartmentPrivate Companies Operations-Investment Specialist-UK## Overview of Department.## Purpose of RoleThe purpose of this role is to strengthen the Private Companies business through high-quality data, analytics and management information across the lifecycle of the investment whilst also supporting operational elements of deal flow. This is a hands-on role responsible for the quality and usability of data within the Private Companies team, maintaining and developing our analytical and reporting capability, and providing insights to support departmental decision-making. The role will work across portfolio company financial information, valuations, investment activity and fund administration data across multiple vehicles, along with client and prospect reporting. Power BI will be central, with responsibility for maintaining and enhancing reporting, developing new analytical solutions and helping colleagues turn data into clear, actionable insight. The role will also own the development of the Private Companies deal management process, establishing a consistent approach to capturing, tracking and analysing deal activity from initial opportunity through to execution.## Responsibilities**Data Management and Reporting*** Take day-to-day responsibility for the quality, completeness and usability of key Private Companies datasets.* Monitor data completeness and consistency across systems, ensuring material gaps or discrepancies are identified and resolved.* Reconcile information from different systems and third-party sources where required.* Build, maintain and improve Power BI dashboards covering areas such as portfolio performance, valuations, investment activity and deal flow.* Improve the efficiency and consistency of client and prospect data requests to better support both internal and external stakeholders.* Improve reporting processes by replacing manual and fragmented activity with repeatable, automated and controlled solutions.* Support recurring and ad hoc information requirements across the Private Companies team.* Oversee and maintain company and instrument records.**Analysis and Insight*** Use Private Companies data to identify trends, risks and opportunities relevant to departmental decision-makers.* Provide insight and interpretation rather than simply producing management information.* Work with investment, operational and leadership colleagues to translate business questions into useful analysis.* Present findings clearly to technical and non-technical audiences.* Proactively identify opportunities where better use of data could improve decision-making or business efficiency.**Operations and Continuous Improvement*** Build and maintain the data and reporting layer of the Private Companies deal management process, giving clear visibility of activity from initial opportunity through to completion.* Ensure transactions, corporate actions, IPOs and transfer-agent activity are accurately captured in relevant systems and records.* Act as the Private Companies business-side subject matter expert for the data model across key platforms including iLevel, Snowflake and the deal-management environment.* Improve reconciliation of investment, transaction and fund-level data against fund administrators and other third-party records across multiple vehicles.* Ensure the data environment is scalable for new funds, structures, distribution channels, administrators and reporting requirements.* Develop practical solutions to inefficient or fragmented processes.* Explore appropriate uses of automation and AI in data collection, analysis and reporting.* Work with technology and enterprise data teams where changes to underlying systems or data platforms are required.**What success looks like:*** A trusted and well-structured Private Companies data universe, with clear ownership and definitions.* High-quality Power BI and management reporting that supports decision-making, delivered with materially less manual effort.* Clear visibility across the Private Companies deals pipeline and investment activity.* More efficient and consistent delivery of data to internal stakeholders, clients and prospects.**Your knowledge and experience:*** Strong experience as a data analyst, business intelligence analyst or in a comparable analytical role.* Experience working with private companies, private equity, private markets or closely related investment data.* Strong Power BI capability, including dashboard development and management reporting.* Strong analytical skills and experience working with complex financial datasets.* Experience reconciling multiple data sources and investigating data-quality issues.* Ability to turn data into clear conclusions, insights and recommendations.* Strong problem-solving skills and enthusiasm for developing practical solutions.* Strong attention to detail and the ability to work effectively across teams and manage competing priorities.* Ability to understand stakeholder needs and translate business questions into useful analysis.* Strong communication and collaboration skills.* Understanding of private equity and company financial metrics. (Preferred)* Familiarity with platforms such as Snowflake or iLevel. (Preferred)* Experience using SQL or similar data tools. (Preferred)* Experience translating business needs into clear data requirements and priorities. (Preferred)* Interest in the practical application of AI to investment data and analysis.(Preferred)**The Type of Candidate We’re Looking For:**Baillie Gifford's Private Companies programme is one of the most distinctive and actively growing parts of the firm.The ideal candidate will combine strong Power BI and analytical capability with an understanding of private companies, commercial curiosity and a practical approach to problem-solving. They will take ownership of the department's data and reporting, identify opportunities for better analysis, and develop solutions that help colleagues make better-informed decisions.**Critical Skills**:* Adaptability* Data literacy* Digital Effectiveness (Including AI)* Systems thinking* Team working## Closing DateOctober 3, 2026 **Should you choose to use AI tools to support your application, we ask that you do this thoughtfully. We encourage you to ensure your application reflects your own voice, experience, and motivations. We value authenticity and want to understand your individual strengths and perspectives.**