Business Consultant - Data Warehousing and Business Intelligence

Location: Warsaw, PL

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

  • Programming skills

  • 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).

  • Life insurance

  • Possibility of developing your career in an international environment

  • Professional training and courses

  • Language classes

  • 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.