Jobs

Senior Data Architect (Data Management)

Closed for now

Senior Data Architect (Data Management)

Mizuho Amsterdam

What is required?

  • University degree in Computer Science or similar, or equivalent experience
  • Expertise with MS SQL, SSIS, SSRS and related data management technologies
  • Experience in backups, archival, recovery models and automating reporting processes (e.g., SSRS/Power BI)
  • Experience in working for large multinational corporates, particularly within Financial Services
  • Familiarity with code versioning tools (e.g., Github, Azure DevOps) and scripting/coding languages (e.g., Python, VBA, VBS)
  • Ability to migrate/integrate SQL codes into data warehouses and maintain excellent documentation
  • Strong cross-functional skills across IT, Business Analysis, Reporting, Process Management
  • Outstanding planning, organizing, communication, analytical and detail-driven abilities
  • Excellent command of English, both verbally and in writing
  • Representative, approachable, independent and active attitude

What will you get?

  • €75K - €85K gross p/y (depending on knowledge and experience) including 13 th month and holiday allowance
  • Annual bonus
  • 37,5 hour working week (flexible working hours)
  • Possibility to work flexibly and remotely
  • 30 vacation days (based on fulltime employment)
  • Option to buy or sell leave annually
  • Technical and professional training possibilities
  • 100% company paid defined pension plan
  • Unique opportunity of working in a dynamic international and multicultural environment and being part of one of the largest financial institutions of the world

What will you do?

  • 35% Creating ETL processes and managing SQL server databases, including backups and recovery
  • 25% Enhancing data warehouse design and automating report with tools such as SSRS/Power BI
  • 20% Working across IT functions and integrating SQL codes using versioning tools
  • 10% Creating documentation and supporting maintenance and release deployments
  • 5% Internal consultation
  • 5% Performing analytical work

This vacancy has been created based on interviews with employees to help you get a realistic preview of the job.

Vacancy

The Senior Data Architect (Data Management) at Mizuho is responsible for maintaining and improving the local data warehouse. You will define how the data should be stored, processed, accessed and managed. The role also covers the day-to-day maintenance and issue resolution of the ETL jobs already present within the IT domains, as well as maintaining all databases within that same domain. A practical mentality is required, as you will have the chance to implement some of these features yourself.

In this role, you will not only maintain the current data warehouse but also propose optimisation of the design. The local data warehouse has been established for a few years and there is plenty of room for improvement. Additionally, you will be responsible for the design and development of the new ETLs and maintaining existing ETL's.

Managing SQL server databases, including configuration, maintenance, monitoring system health and performance tuning, is also part of your responsibilities. Furthermore, you support scheduled maintenance and release deployment during or after working hours and design and implement data modelling solutions using relational and dimensional databases.

The IT department formally consists of three interconnected teams: Data Management, Infrastructure and Development. This role falls within the Data Management team consisting of five people with a diverse set of skills and responsibilities. On a day-to-day basis, you will report to the Data Management Team Lead, with a formal line to the IT Department Head.

If you enjoy defining optimal methods for data storage, processing, and access, relish the challenge of designing complex ETL processes, and are adept at maintaining SQL server databases, then this is the job for you.

Working week

Senior Data Architect (Data Management)

On an enjoyable day, you have made improvements to the data warehouse to service internal customers. This helps you to further optimize the data processes in the company.

On a less enjoyable day, you dive into broken data pipelines and resolve the issue as soon as possible.

  • 09:00
  • 10:00
  • 11:00
  • 12:00
  • 13:00
  • 14:00
  • 15:00
  • 16:00
  • 17:00
  • 18:00
    • Reading and replying to mails
    • Monitoring ETL jobs
    • Lunch
    • Monitoring SQL databases
    • Discussing projects
    • Administration
    • Maintaining data warehouse
    • Designing new ETL's
    • Configuring SQL server
    • Meeting with IT teams
    • Resolving issues
    • Proposing warehouse improvements
    • Lunch
    • Maintaining SQL server
    • Designing data models
    • Reading and replying to mails
    • Discussing projects
    • Developing ETL processes
    • Lunch
    • Team meeting
    • Maintaining data warehouse
    • Reading and replying to mails
    • Resolving ETL issues
    • Monitoring databases
    • Lunch
    • Optimizing data warehouse
    • Administration

Firsthand experience

The ETL process to the local data warehouse occasionally fails and the current data load process needs to be revised. New tools are being explored to improve the process. How do you proceed?

You start by thoroughly analyzing the existing ETL process to pinpoint weaknesses and areas that can be improved. Your expertise with MS SQL, SSIS, SSRS and other related technologies guides you in understanding the underlying issues. You evaluate current methods and identify potential solutions that can make the process more robust and efficient.

Based on the insights from your analysis, you take on the challenge of designing and implementing new data modeling solutions. You select the most suitable tools and methods, possibly exploring innovative ones and work on implementing them to optimize the ETL process. Your creativity and practical mindset help ensure that the revised process aligns with the required standards and performance needs.

Growth

The goal of Mizuho Bank Europe is that employees have the right skills, knowledge and attitude to drive results they need to achieve. Their key principle is that trainings should be accessible to anyone and contribute to their strategic business goals. Because of that, employees are allowed to follow a study or training in a relevant field. Additionally, Mizuho promotes internal and international vacancy's so employees can move from one department to another.

Senior Data Architect (Data Management)

Working at Mizuho

Mizuho Bank Europe N.V. (MBE) is a fully-licensed bank incorporated in the Netherlands and supervised by De Nederlandsche Bank (DNB) and the Autoriteit Financiële Markten (AFM). With over 45 years of experience providing financial services to Japanese and non-Japanese customers in the region, Mizuho has developed a solid client base and expertise throughout the European single market - with a focus on the markets in the Benelux, Iberia, and Central & Eastern Europe - using their EU Banking Passport.

  • Based in Amsterdam (Zuidas)
  • 124 employees in the Netherlands
  • Over 65.000 employees worldwide
  • 45% / 55%
  • Average age 33 years
  • Possibility to work flexible and remote
  • Business casual

Interesting job?