Description
Please note that the salary advertised does not include London Weighting, however, this will apply if the post holder is based in our Hammersmith office.
As Developer and BI Analyst, you will be responsible for proactively developing and supporting the use of Maggie’s systems and associated databases and data warehouse, in order to maximise functionality and to optimise the supporter and visitor experience, thus working towards the aspiration that “everyone deserves a Maggie’s Centre”.
You will need to establish and sustain strong collaborative working relationships both internally and externally, in order to challenge and then optimise database- and Business Intelligence-related processes.
You will also proactively seek out automation opportunities for HR, Finance, Programme and Fundraising, facilitating the specification of business requirements with internal clients then converting these into functional specifications prior to developing, testing and implementing the associated routines, SQL code, stored procedures and/or other automation approaches.
Please see the attached job description for further details on the role.
Key responsibilities
* Proactively design, develop and automate new/enhanced APIs, interfaces, processes and procedures requiring frequent imports of data into the main production database, and to test these comprehensively.
* Collaborate with cross-functional teams to gather requirements and define specifications for integrating systems with 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, as well as assisting with and facilitating report compilation to colleagues.
* Stay current with technology trends and evaluate opportunities for leveraging emerging tools and frameworks.
* Champion a user- and data-driven approach to product development
* Be responsible for the daily running of a help desk function for all system users, dealing with queries directly and/or escalating issues to the Head of Databases and BI Development or the IT Department when appropriate.
* Write effective, scalable code and contribute to the adoption of Agile processes and promote a collaborative team culture.
* Ensure that Service Level Agreements are met and adhered to with internal clients.
* Develop, modify/update and publish user processes, guides and procedures.
* Assist with other relevant duties as appropriate.
* Building of data reporting structures in Salesforce, Power BI and future systems.
* Communicate data in a clear and simple manner to non-technical personnel.
Skills, knowledge and expertise
* Degree educated in relevant field with Azure/MS Fabric or SQL Server qualification/certification.
* Experience of database administration in a multi-user environment.
* Experience in integration and data warehousing on an Azure platform/MS Fabric is a must
* Working experience with DevOps, API development and Python
* Experience working with Salesforce CRM/Marketing would be an advantage
* Confident working across technical and non-technical teams
* In-depth understanding of GDPR and Data Protection legislation.
* Strong business requirements and functional/technical specification documentation skills;
* Excellent numerical skills and the ability to manipulate raw data
* Strong organisational skills and attention to detail
* Interest in data, systems thinking and process improvement
* Knowledge of data reporting and visualisation (Power BI, Salesforce, Tableau) is desirable
* Familiarity with Agile principles or scrum methodology
Job benefits
* You’ll spend time at one of our incredible centres to experience our programme of support and see first-hand the difference we can make.
* A structured Orientation week will cover everything you need to get settled in your new role.
* Holiday entitlement that helps you create a manageable work life balance.
* Generous sick leave cover.
* A supportive and friendly working environment.
* Tailored learning and development opportunities.
* Kitchen facilities with free tea, coffee and fruit bowl.
* Workplace pension and free financial advice from an independent financial advisor to help you plan for your future.
* Option to keep a pre-existing NHS pension if eligible.
* Travel and cycle loans.
* Eye test expenses and money towards glasses.
* Enhanced maternity pay.
* Our buddy system links you with a colleague to give you extra support in your first few months.
* Facilitated stress management courses and access to our clinical psychologists for support.
We provide free practical and emotional support for people living with cancer, and their family and friends. We have centres across the UK and a growing international network, with more planned for the future.