Senior Specialist, Database Administrator Data and Analytics

Principles for Responsible Investment

Employment Type Full time
Location Hybrid · London, City of, UK
Salary £56,000 - £67,000 (GBP)
Team Ri Solutions
Seniority Mid-level
  • Closing: 8:00pm, 18th Feb 2024 GMT

Job Description

About the PRI

The PRI is the world’s leading proponent of responsible investment. It works to understand the investment implications of environmental, social and governance (ESG) factors and to support its international network of investor signatories in incorporating these factors into their investment and ownership decisions.

The PRI’s three distinct capabilities relate to the core elements of the PRI’s approach to achieving a sustainable financial system.

  • Translate RI (Responsible Investment) thought leadership into insights and practical support that is tailored to what signatories need to progress their RI practice

  • Convene our vast network to create opportunities for collaborative action

  • Harness our global scale to influence policymakers and regulators to effect system change

Job Description

We are currently seeking a skilled Database and Access Management Specialist to join our team. In this role, you will be responsible for managing and maintaining our database systems, as well as overseeing user access and permissions across a variety of in-house applications, including our CRM system. This role will be key in accelerating our capabilities and capacity to provide support and development for data, reporting and analysis services to both internal users and external customers (mainly our members, PRI signatories).You will be involved in the ongoing development of existing data services, new projects (usually in conjunction with 3rd party partners) and, working alongside other members of the technology team, you will be the senior person supporting one other subject matter expert in maintaining and monitoring our databases and associated data infrastructure.Working closely with our analysts you will work to understand the business and customer needs and how these can be met. You will have the confidence to challenge others, influence the decisions being taken and experience in managing ambiguity and conflicting priorities while setting expectations of the achievable outcomes.As well as your subject matter expertise in this role you will ideally have experience of working with global organisations in ESG, Government, RegTech or the Financial Markets industry.

Core Responsibilities:

Technology Support

  • Provide business as usual support for key databases and data systems, including:

  • Reporting and assessment tool

  • Data portal (including connectivity to other systems such as Salesforce).

  • Organisational dashboards.

  • Protect our data both in terms of quality and from ongoing cyber threats.

  • Manage and maintain database systems to ensure optimal performance, security, and reliability. (mainly co-lo and Azure).

  • Administer user permissions and access controls for various in-house applications and CRM systems, ensuring compliance with security protocols and data privacy regulations.

  • Collaborate with IT and departmental teams to understand user access needs and implement appropriate solutions.

  • Develop and maintain comprehensive documentation on user access policies and procedures.

  • Monitor and audit user access and permissions, addressing any irregularities or security breaches.

  • Assist in the integration of new applications into the existing infrastructure from an access management perspective.

  • Provide support and training to users on access management and database utilization best practices

    Design & requirements gathering:

  • document data, reporting and analysis requirements, engaging with the IT analysts and business teams to ensure solutions are fit for purpose and deliver to requirements.

  • Provide project support and subject matter expertise as needed.

    Data connectivity:

  • Integrate and connect different data sources into data lakes, schemas, etc. so that business data analysts and researchers can produce insights using sophisticated analysis tools such as Dash Enterprise, PowerBI and languages such as Python and R.

    Reports and datasets:

  • Build business reports templates and associated datasets that that enable end users and customers to self-serve their reporting needs using BI tools and dashboards.

    Data Governance, Management and Innovation:

  • collaborate with the IT Leadership team, internal domain experts and third parties to:

  • Establish a data roadmap and logical model for our data that includes an interoperable data ecosystem for our many data sources and allows for easy integration of new sources.

  • Be an advocate for innovative technologies (such as big data, machine learning, graph databases)

    Training:

  • provide occasional training and coaching to users in reporting, data manipulation, aggregation, and visualisation. Promote best practises in use of data and tools.

Person Specification

  • Demonstrable experience of database modelling, working with SQL databases, writing complex queries and designing and building efficient ETL processes is essential.

  • Broad experience of providing support to databases on-premise, co-lo and in the cloud is essential, including updating, monitoring, logging and tuning.

  • Experience working on data platform migrations to the cloud is desirable.

  • Microsoft Azure experience is highly desirable, but other cloud technology experience will be considered.

  • You will have worked in a full-stack environment and have an appreciation of front-end technologies; ideally having direct development experience (Python, Javascript, APIs, etc.).

  • You will have worked on at least a couple of complex data projects ideally for medium or larger sized companies.

  • Experience of working in an Agile/Scrum environment and ideally exposure to Dev-ops best practise is desirable.

  • A demonstrable interest of broader technology trends such as big data, AI and innovative cloud technologies is an advantage.

  • Good communication skills, both verbal and written; experienced in translating technical topics for a business audience in a clear and concise way.

  • A collaborative and consultative approach to working with others, committed to fostering an inclusive working environment

  • Have a commitment to developing others and a growth mindset, actively pursuing continuous professional and personal development

We particularly welcome candidates from under-represented groups, including Black, Asian, and other People of Colour, those with visible or non-visible disabilities, LGBTQ+ candidates and those who are neurodivergent.

 The PRI is committed to offering flexibility to our employees, both formal (e.g. part-time work) and informal (e.g. a shift in hours to accommodate caring responsibilities). Please talk to us about how we could make this role flexible for you.

N.B. We reserve the right to close a vacancy before the closing date in the event of an overwhelming response or a change in business priorities.

Removing bias from the hiring process

Applications closed Sun 18th Feb 2024

x

Removing bias from the hiring process

  • Your application will be anonymously reviewed by our hiring team to ensure fairness
  • You’ll need a CV/résumé, but it’ll only be considered if you score well on the anonymous review

Applications closed Sun 18th Feb 2024