At SimCorp, we assist some of the biggest financial institutions in the world to be successful by simplifying their investments, accounting, and operations. We do this through IT systems, processes, and financial knowledge.
Within the Regulatory Center of Excellence, we are designing solutions to enable our clients to stay compliant based on multiple regulatory requirements. We are now expanding the core team, looking for a (Senior) Business Consultant – Data Warehouse and Business Intelligence.
Within the Regulatory Center of Excellence, you will work with experienced and respectful colleagues who are experts in providing solutions and services to SimCorp market units and clients around the world. This combination of market experience in regulations and expertise in SimCorp Dimension creates an environment of quick learning and knowledge sharing.
What you will be responsible for
Technical and business design
Build and deliver DWH/BI solutions and integration solutions for SimCorp Dimension according to client requirements
Develop Data Warehouse components (facts, dimensions, data marts), reports, BI applications and dashboards
Document and build your solutions, demo solutions and document Proof of Concept
Unit testing, preparing test cases and supporting System Integration Tests and User Acceptance Tests
Gather, understand and document the client’s technical requirements
Participate remotely in implementation projects around the world
What we value
Most importantly, you can see yourself contributing and working well in the position described above. How you gained the skills needed for doing that is less important. We expect you to be good at several of the following and be able to - and interested in - learning the rest.
Experience in implementation projects in relation to reporting in the FinTech sector
Experience with IT Business Analysis including requirements gathering, facilitating clarification sessions with business users
Experience in integrating IT systems and dataflows
Experience in working with SQL and relational databases (Oracle, Snowflake, Microsoft SQL)
Understanding of Data Warehousing concepts and data modeling
Experience in data analytics with dashboard and report generation background
Experience in enterprise reporting tools (SAP Crystal Reports, Qlik NPrinting or similar)
Experience with BI tools like: Qlik Sense, Power BI, Tableau, Cognos or others
Experience with XML or XBRL
Basic knowledge of investment finance (e.g. financial instruments, capital markets)
Experience with working in an international environment with daily use of English
Degree in studies related to Computer Science, Mathematics, Physics, Business Administration or Finance
Additional experience and skills which would be advantageous
Experience with ETL processes, data imports and exports
Experience with system testing, configuration, documentation and sharing knowledge
Understanding of cloud computing technologies (Azure, AWS, Google Cloud) at fundamentals level
Understanding concepts of non-SQL databases (Microsoft Cosmos DB or similar)
Basics of Cloud Data Management Systems (like Snowflake)
Experience with XSLT and XML Schemas
Experience in consulting
Experience with Solvency II (Pillar 1, Pillar 3 and the TPT standard)
Pillar 1 Market Risk calculation
Pillar 3 asset-related Quantitative Reporting Templates (QRTs)
TPT format as defined by FinDatEx
Flexible working hours – the possibility of remote or hybrid working models
Possibility of working based on a regular contract or B2B
Private medical care (Medicover)
Sharing the costs of sports activities (Multisport Card).
Possibility of developing your career in an international environment
Professional training and courses
Integration events and charity projects
Who we are
For over 50 years, we have worked closely with investment and asset managers to become the world’s leading provider of integrated investment management solutions. We are 2,100+ colleagues with a broad range of nationalities, educations, professional experiences, ages, and backgrounds in general.
SimCorp is an equal-opportunity employer. We are committed to building a culture where diverse perspectives and expertise are integrated in our everyday work. We believe in the continual growth and development of our employees so that we can provide best-in-class solutions to our clients.
While striving to deliver client value, we believe it is vital to consider our people and our planet in every business decision we make. Acting responsibly is not optional. It is essential.