Job Description
Lloyds Bank GmbH and its brands Bank of Scotland and Lloyds Bank have won over 1 million satisfied customers in recent years. And this thanks to convincing products and, above all, our committed colleagues who want to achieve the best for our customers every day with new ideas, challenges and joy. In order to continue writing our success story, we are looking for the right reinforcement for our teams, because all our ambitious goals would be unattainable without teamwork. We also welcome career changers.
For our office in Berlin Mitte we are looking for a
BI Developer / Engineer (m/f/d)
- Interpreting Business Requirements: you will show a strong initiative and analytical capability to understand business requirements and information needs, assess feasibility and estimate development efforts
- Designing Data Warehouse Solutions: you design efficient and stable data warehouse solutions in strong cooperation with business users, stakeholders and the BI team
- SQL Development: you will create and amend database objects and update and optimise complex stored procedures with a focus on performance
- Developing Reports: you develop solutions using SQL Server Integration Services, Reporting Services, Analysis Services and Power BI to establish regulatory reporting, standardized reports and company-wide Key Performance Indicators and dashboards
- Data Warehouse Management: you will monitor and maintain daily ETL processes and data loading on an ad hoc basis and follow our testing and release process as part of an agile team
- Knowledge Sharing: you will support other colleagues in their tasks, write documentation and contribute proactively in agile sessions.
- Educated to degree level in Computer Science or equivalent experience
- Several years of experience working with Microsoft SQL Server (SSMS, SSIS, SSRS, SSAS)
- Excellent SQL coding skills
- Proven experience with ETL processes, strong experience of query optimisation
- Extensive experience in writing stored procedures
- Knowledge of data modelling and data warehouse architecture principles
- Knowledge of Power BI
- Experience with Azure Databricks and Data Factory is desirable
- Proven presentation and facilitation skills
- Strong oral and written communications skills in English
- An international team with colleagues from more than 50 different countries
- Social benefits such as a company pension scheme and capital formation contributions
- 30 days holiday as well as 24 and 31 December as non-working days
- Employee Assistance Programme – personal 24/7 helpline for all employees
- Various possibilities for flexible working, i.a. various part-time models, flexitime
- Extensive, very flexible home office arrangements
- Possibility to work from other EU countries for up to 30 days per year
- Additional benefits such as sports activities, free fruit, nuts and drinks
- Employer contributions to BVG job ticket and a Lease a bike programme
- An informal corporate culture - without dress code and ‘Sie'.
- An excellent learning culture and opportunity to improve your professional competencies
- Easily accessible city centre offices, in the vicinity of many shops and restaurants to which you receive a discount