Database Developer & BI Analyst

We have an exciting opportunity for a Database Developer & BI Analyst to join the team either in our London (Hammersmith) or Glasgow office.

In this role, you will develop and support the use of Maggie’s systems and associated databases and data warehouse to maximise functionality and to optimise the supporter and visitor experience, working towards the aspiration that “everyone deserves a Maggie’s centre”.

Your responsibilities

• Proactively design, develop, automate and test new/enhanced APIs, interfaces, processes and procedures requiring frequent imports of data into the main production database.

• Collaborate with cross-functional teams to analyse business requirements and prepare detailed specifications for the integration of these systems with existing databases and the data warehouse.

• Undertake associated business analysis with which to prepare detailed business requirements specifications, functional specifications and technical specifications relating to changes or improvements in databases and/or data warehouses, and to provide considerable input into/compile user acceptance testing (UAT) test plans.

• Deliver business-critical tasks for business-as-usual (BAU) operations such as cleansing, transforming, importing and outputting datasets, and assisting with and facilitating report compilation to colleagues.

Key requirements for consideration

• Advanced knowledge of SQL and T-SQL including building complex queries as well as administrative scripts.

• Data validation and manipulation techniques using SQL, Python, VBA, macros, pivot tables, or Access.

• Advanced knowledge of ETL methodologies.

• Strong business requirements and functional/technical specification documentation skills.

Your attention to these criteria is greatly appreciated, as they are crucial for assessing your application. Applicants lacking these criteria may result in their application not being considered. 

Benefits we offer

In addition to a highly rewarding career, we offer a range of staff benefits, including:

• a unique, experiential induction based in one of our centres
• a structured, year-round performance review process focused on developing you in your current role and exploring opportunities for the future
• a competitive holiday entitlement
• workplace pension with the option to apply to continue NHS pension
• the option to apply for a Bike Loan, Travel Card Loan, Ride to Work scheme and much more.

Read more about our staff benefits

How to apply

Take a look at the full job description DB Developer & BI Analyst January 2024.pdf

Please send your CV and cover letter to recruitment@maggies.org by 18 April 2024 at 06 pm.