Business Analyst (m/f/d)
Business Intelligence Datawarehouse
Köln, DE
Your Tasks:
- Collaboration on international IT projects and creation of technical concepts with internal departments and subsidiaries
- Analysis and optimization of data processes in the industry database, taking into account technical and regulatory requirements
- Development and maintenance of SQL statements for data analysis, testing, and ETL processes (Kettle)
- Creation of interactive dashboards with MS Power BI for various areas of the company
- Ensuring data delivery for reporting and control tools
- Developing and optimizing IT processes for data quality assurance and documentation
- Advising departments on new requirements and their technical implementation in databases and applications
- Coordinating consultations with internal departments, subsidiaries, and external software providers
- Providing support for testing, data corrections, and the continuous development of the data infrastructure
Your Profile:
- Completed degree in business informatics, computer science, or business administration with a focus on IT
- At least 5 years of professional experience in a credit institution or captive
- Very good SQL skills and experience with ETL tools (ideally Kettle)
- Knowledge of BI tools such as MS Power BI, Cognos, or MS Dynamics is an advantage
- Confident use of MS Office, especially Excel
- Very good written and spoken English skills
- Analytical and conceptual thinking skills
- Independent, structured, and reliable way of working
- Strong communication skills and ability to work in a team
- Very good written and spoken German and English skills