Pantheon is a leading global private markets specialist currently investing on behalf of more than 1,000 investors, including public and private pension plans, insurance companies, endowments, foundations and private wealth clients. Founded in 1982, Pantheon has an established reputation across private market asset classes, covering all stages and geographies, and provides investment solutions that include flagship fund offerings, as well as integrated programs and customized solutions. Pantheon also manages and advises Pantheon International Plc (“PIP”) and Pantheon Infrastructure Plc (“PINT”), both investment companies listed on the London Stock Exchange.
As of December 31, 2022, Pantheon had $92.8 billion in assets under management and advice and the firm currently has more than 460 employees located across its offices in London, San Francisco, New York, Chicago, Hong Kong, Seoul, Bogotá, Tokyo, Dublin and Berlin. Its global workforce includes more than 140 investment professionals.
Pantheon is majority-owned by Affiliated Managers Group Inc. (NYSE: AMG), a leading partner to independent active investment management firms globally, alongside senior members of the Pantheon team.
For further details, please visit our website: www.pantheon.com
Purpose of Position
Pantheon require a passionate hands-on Data Support Engineer to support the delivery of change to existing systems as well as conduct analysis for root cause & software issues.
Pantheon is at the start of a multi-year programme to establish itself as a data centric organisation with this role being integral to the on-going support to the Business which will be critical as the transformation continues.
You will be working with an established tech stack and proven experience of supporting traditional data warehouses is core to the role.
You will be part of a small and highly skilled team and you will need to be passionate about providing best in class solutions to our global user base.
Key Responsibilities
To be successful in the role you will be expected to:
- Support the Data Team Lead in continuously delivering changes to existing system
- Develop, modify, implement, and support software components.
- Determine root cause for data / software issues and develop practical, efficient, and permanent technical solutions.
- Communicate with the stakeholders and peers on a frequent basis, identifying risks, issues and dependencies and working with other tech leads and IT groups to resolve
- Assist in task planning, estimation, and scheduling deployments
- Carry out design, code, and test peer reviews throughout project providing technical guidance and to identify issues. Feedback technical status and issues.
- Determine process improvements, best practices, and develop new processes.
- Understands and complies with all relevant IT and Security policies and procedures ensuring compliance across all project technical deliverables.
Essential Technical Skills
- Minimum 2-3 years’ experience in developing & supporting Azure data focused systems
- Experience in traditional Data Warehouse technologies (ETL, SQL Database, Reporting)
- Knowledge of Dimension Modelling
- Strong SQL skills, experience in writing complex SQL queries
- Knowledge of Azure Data Lake, Data Factory, Databricks and Functions
Essential Experience
- Experience in supporting traditional Data Warehouses
- Exposure in building Azure based data ingestion and transformation pipelines, data lake, data warehouse / data marts etc.
- Experience working with Agile development methodologies such as Kanban/Scrum
- A natural problem-solving attitude.
- Conversant with current industry and technology trends.
- Experience with dealing directly with stakeholders and business users
Desired Experience
- Business Objects Reporting
- Power BI
This job description is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. You may be required to perform other job-related duties as reasonably requested by your manager.
Pantheon is an Equal Opportunities employer, we are committed to building a diverse and inclusive workforce so if you're excited about this role but your past experience doesn't perfectly align we'd still encourage you to apply.