Currentlyour entire team is working remotely, but when we return to the office, we willbe looking at how we can work flexibly including homeworking, but the location of the role would be London Docklands and this will be inyour contract.
As a team, we want to providedata that’s detailed and suitable for strategic reporting that helps us plan andmanage people and teams into the future. As the Senior Data WarehouseDeveloper, you’ll play a key role developing ETL scripts, providing, analysingand interpreting complex data and information. We’ll be relying on yourexpertise, coaching and data warehouse design skills to help the teamcontinuously improve their capability and make sure the reliability and dataintegrity of our data warehouse is always at a high level. As an experienceddeveloper, you’ll play a key role in developing and supporting our ETLcapability across the organisation.
In this role you’llwork very closely with the business information (BI) team to produce dashboardsand reports for the ombudsman using Power BI. You’ll be focused on using the SAPData Services tool, supporting and continuously improving the data warehouse,as well as delivering new code to allow the team to report on new data sources.
To be successfulin this role you will need to have demonstrable experience of:
· Extensiveknowledge of SAP Data Services
· Theability to develop SQL, view and stored procedures in Microsoft SQL Server
· Workingin cross functional IT teams and making your own code in a changing environment
· usingthe following in a data warehousing environment:o defining,designing and developing data marts or
warehouses using Kimball dimensionalmodelling techniqueso defining,designing and developing Extract Transform
Load (ETL) processes using industrybest practices, and monitoring ETL deployments and operations
· prioritisingunpredictable workloads, you’ll have excellent problem solving and troubleshooting skills and be
confident in determining solutions to challenges
· strongknowledge of data warehousing best practice
· Excellentcommunication skills, both written and verbal when presenting
information
If you think thisrole is of interest to you, take a look at our more detailed requirements inthe .
To apply, please send us your CV and a covering letter telling us, in no more than500 words, why you think you’re the right person for the role.
The deadline for applications is 11.59pm Sunday 20th September 2020. If successful at this stage, you will be invited to an interview.
What can you expect?
Successful candidates will enjoy the opportunityto develop their careers in a diverse organisation which offers a generouspension, private healthcare, free onsite gym and wellness initiatives. It alsoincludes access to an extensive range of flexible benefits including dental andtravel insurance.
Who we are…
With fairness at the heart of everything we do,we embrace difference and treat everyone as equals. We’re a diverseorganisation, but something we all share is our values. They’re central to theway we work – and work together.
We’re an independent, not-for-profitorganisation that sorts out disputes between financial businesses and theircustomers. We do this by making decisions that are fair – and feel fair to bothsides.
The Financial Ombudsman Service is an equalopportunities employer. All applicants will be treated in a fair and equalmanner and in accordance with the law, regardless of gender, marital status,race, religion, colour, age, disability or sexual orientation.
We’re committed to being a great place to work –attracting and developing people from the widest possible range of backgrounds.We want everyone to perform at their best and feel able to be themselves. Weunderstand that if we’re diverse and inclusive, we’ll better understanddifferent perspectives, which is fundamental to our job resolving financialcomplaints. You can read more about this
Weare proud to be a Disability Confident employer. Disabled applicants who fulfilthe minimum criteria for the role will be progressed to the next stage of theprocess. Do let us know of any reasonable adjustments you need. You will needto demonstrate that you meet the minimum criteria in your CV in order toqualify for the Disability Confident scheme. The first stage will be a face toface interview