Developer Oracle-based DWH, ETL and BI for risk and issue reporting (internal)

ING

Vacature informatie

Organisatie: ING

Locatie: Amsterdam

Opleidingsniveau: HBO/WO

Arbeidsvoorwaarden: Marktconform

Solliciteren

  • Interne medewerker
  • IT
  • Medior/Ervaren (9/10/11)
  • Nederland
  • Amsterdam
  • Full-time

We are looking for a Dev engineer to improve an Oracle based datawarehouse, who is experienced in ETL and BI. In this role you will work as a Developer in the IT organization of Group Services Risk Management in a BusDevOps team.

Your work environment

All risks and issues of ING are registered in an application which is the basis for multiple types of reports used by risk managers, and by higher country and corporate management. The reports give overview and details of risk and issue areas and relate to expected loss tolerance. The reports are used for ECB- and other regulatory reporting, audits, internal risk processes, provisioning processes, and to measure exposure, and are used to control ING’s risk appetite.

Further development and improving the current datawarehouse, and reporting functionality has been prioritised as a strategic objective. The current Oracle datawarehouse is being transformed, and Business Intelligence (BI) functionality is being developed, to feed dynamic reports by Cognos.

Your team is called a BusDevOps squad combining the expertise of the business, IT Developers and Operations specialists. Its focus is called ‘Governance, Risk and Compliance’. By working this way, all expertise around the support and development of all ING non-financial risk tooling is centralized in one team. The squad works according to Agile scrum, which means that work is sliced and planned in sprints. As Developer in the team you take responsibility to deliver value according to sprint planning. Together with the team you are responsible to (re-)design and improve the application and its BI solution. And together with all stakeholders, you jointly work towards the combined goal: develop a solution with is maintainable and clearly reports on all data information needs.

Your profile

Your key competences:

  • A hands-on, and pro-active professional who can keep oversight of complex processes
  • At least 5 years experience with Oracle databases, datawarehouses, ETL and BI. In specific:
    • You are capable to learn and oversee an entire datawarehouse. You are capable to re-design the data model of the current DWH, to efficiently support current reporting.
    • You have experience with PL/SQL, e.g. you are able to develop new ETL procedures in PL/SQL and fine-tune existing PL/SQL code for efficiency and maintenance reasons
    • You are capable to develop Data Marts (this will enable the building of interactive/BI reporting instead of our current static reports) and efficient and maintainable SQL queries
  • You are capable to educate/instruct report builders how to configure their reports so that they get up and running and can carry out themselves
  • From the perspective of your database knowledge and experience, you are capable to advice and support Operations engineers and other team members, e.g. during an upcoming transfer operation of the current Data Warehouse into the ING Private Cloud environment
  • You are eager to learn, like to deep-dive technology, to search for root causes of issues and incidents, and to resolve them
  • Team player.

Preferred:

  • Master of Science in Computer Science or an equivalent field
  • Experience with Continuous Delivery
  • Excellent English and Dutch communication skills, verbal and written.

What we offer

  • Professional working environment with possibilities to develop yourself in areas such as BI, IT management, IT Security, other IT areas, or risk management
  • A competitive salary and an attractive package of employer benefits.

Interested?

Apply directly online by clicking on Apply for this job. Please send your CV and motivation. For questions, please contact Pawel Debosz recruiter, pawel.debosz@ing.com .

We are looking forward to your application.

Vacature informatie

Organisatie: ING

Locatie: Amsterdam

Opleidingsniveau: HBO/WO

Arbeidsvoorwaarden: Marktconform

Solliciteren

Meer vacatures

Vacatures