Financial Data Analyst

The position

Do you want to make an immediate impact within the City of Amsterdam? This is your chance! As a financial data analyst in the Leasehold and Allocation Department, you’ll have the opportunity to actively contribute to the financial management and monitoring of Amsterdam’s leasehold system. This dynamic and socially beneficial tool helps ensure a livable and affordable city. Within Leasehold & Issuance, we are committed to an inclusive and diverse work environment where you are challenged, given room for initiative, and encouraged to think strategically. You will work closely with professionals from various fields, whose expertise complements one another. Become part of an enthusiastic, motivated, and engaged team!

As a financial data analyst, you will examine and analyze financial and operational data to assess the department’s financial health. You will combine data from various sources, verify the accuracy of financial flows, and translate raw data into actionable management information. You will create reports to verify whether business processes are yielding the desired results. To do this, you use data analysis tools such as Power BI and Excel to identify financial trends, risks, deviations, and opportunities for improvement.

You will play a key role in developing the annual plan, Planning & Control deliverables, and the E&U department’s periodic reports. In doing so, you will assist in preparing financial forecasts, variances analyses, and multi-year insights. You will prepare management reports and advise the management of the Leasehold and Issuance department.

Together with your colleagues—two financial advisors—you will serve as a sounding board for (legal) policy advisors, the Business Administrators, the management of Leasehold & Issuance, and the Land and Development Executive Board on financial matters within the department. Drawing on your data-driven perspective and financial background, you will contribute ideas for improving processes and systems. You identify opportunities and do not let yourself be limited by conventional views and working methods. You quickly familiarize yourself with leasehold matters and effortlessly link this to the financial structure.

You are able to gain new financial insights. You are curious and ask questions to determine which approach or solution is most appropriate. You take advantage of opportunities to further develop and present financial insights derived from the data. You contribute to financial policy discussions and provide data-driven input to explore potential solutions. In doing so, you make a clear contribution to financially sound decisions, risk analyses, and process improvements.

There is room to grow in this role and expand it to include more strategic areas in collaboration with the two financial advisors.

Here's what you do on an average day

• You start the day by checking the

  canon revenues. You create a report and analyze it. You see a

  notices a number of differences and sets out to investigate. You notice some striking

  discrepancies and investigates them in the financial systems and datasets.

• If there are some differences you can't resolve,

  Consult with a business administrator to get a clear picture of

  these differences.

• Meanwhile, you can see that this check also

  could be done more efficiently. You make a note in your calendar to do this later

  to investigate.

• Since you were already talking to the

  The business administrator brings a problem to your attention: they're stuck

  because something in the system is disrupting their billing process. You immediately

  Contact the product owner and have them look into what’s going on.

  In the meantime, you’ll keep the relevant stakeholders informed and consider a

  temporary workaround.

• You've set aside time in the afternoon for the

  preparing a report on the finances for the past four months. This

  you will use as input for the presentation you will soon be giving together with the

  financial advisors will provide guidance on the implementation of this plan.

• Based on the input, you analyze the data and

  converts this into clear charts, tables, and metrics in Power BI or

  Excel. Send the analysis to your colleague for review.

• You end the day with a coordination meeting to

  with a number of (financial) colleagues, the current issues and progress of various

  to discuss projects and data-driven initiatives.

This is where you get started

Leasehold and Issuance is part of the Land and Development Division. Within

Erfpacht & Uitgifte places a high priority on being a good employer and building

we work every day to foster a workplace culture in which all colleagues feel seen, heard, and

feel valued. We are proud of the diversity within our department and the

a reflection of our organization and the city. Openness, transparency, and

Learning from one another is at the heart of what we do. No matter who you are, you’re always welcome here.

Welcome!

The mission of our Land & Development division is: “More

"create value for the city and metropolitan area of Amsterdam." We are working on a sustainable

and a vibrant city for residents and businesses, we oversee district-level and

real estate development and the leasehold system. We grant land under leasehold and

We manage this; we prepare lots for development, transform, and manage real estate

and manage project finances and the leasehold assets.

The Leasehold and Issuance Department manages over 300,000 leasehold contracts, with

annual revenue of more than €100 million and total assets of

approximately €8 billion. The department has 280 employees spread across 7

teams. As a financial data analyst, you will be part of the Advice, Policy, and

Development, Advice & Development Subteam. This team includes

bring together various areas of expertise, and the department’s data analysts are also part of this

who can serve as your sparring partners. In addition, this team is responsible for

Establishing data management processes within the department currently under development, in which you

will be working with us in the role of financial data analyst.

What you bring

For this position as a financial data analyst, you must have:

• At least 3 years of work experience in a financial

  function.

• A completed associate's degree in the field of

  business administration, finance & control, or a related field of study.

• Experience with Power BI and advanced experience with

  Excel.

• Experience with and/or knowledge of SQL is a plus.
• Experience in a large, complex organization is

  an advantage.

You should have the following skills:

• Analytical skills: you can distinguish between the main points and the details

  distinguish, break down a problem into parts, and apply logical

  draw connections between the various aspects.

• Collaboration: You contribute constructively

  contribution to a shared outcome, particularly to the atmosphere and the

  relationships within the group or team.

• Creativity: you identify opportunities for

  improving processes and systems, and coming up with creative solutions for

  complex issues.

• Persuasiveness: you communicate clearly and

  definitely. This way, you can naturally ensure that

  support and acceptance.

What we offer you

As a financial data analyst, you will work a minimum of 32 and a maximum of 36 hours per week

strengthen our team, and you can count on the following employment terms:

• A gross monthly salary of at least €3,674

  up to a maximum of €5,419 (scale 10) based on a 36-hour workweek. The

  The exact salary will be determined based on job level, cognitive ability, knowledge, and experience

  you bring with you. It is possible that a preliminary scale (scale 9) will be used

  if not all requirements have been met yet.

• A 12-month employment contract with

  prospect of a permanent position.

• Keeping your permanent employment if you already have a

  have a permanent position with the City of Amsterdam.

• Extensive opportunities for professional development and training,

  including through the Amsterdam School.

• An individual choice budget (ICB) of 17.05% of

  your salary, for example, for additional pension contributions or leave.

• Pension accrual through ABP, the pension fund for

  government and education.

• Travel allowance ranging from €0.10 to €0.21 per

  kilometer (up to 45 km one way) and/or a work-from-home allowance of €2 net

  per day of remote work.

• A monthly contribution to the

  health insurance.

• Hybrid work: In this role, you can work partly

  working from home and partly in the office. We provide (home) office equipment to help you

  to create a safe and healthy workplace.

• An office location overlooking the

  Amsterdam's canals.

• A socially meaningful job in a

  the team involved.

Want to learn more about the terms of employment? Check out the City of Amsterdam’s Personnel Regulations

(PGA) on the website.

Apply for this job

• If this job opening interests you, please send us

  Please submit your application by

  Sunday, February 22 via the

  Apply button.

• We look forward to receiving your cover letter, in which you

  In no more than one A4 page, explain why your work experience and skills

  suit this position. Your motivation will be taken into account during the

  selection process.

• If your profile matches, we'd love to invite you

  for a job interview.

• The interviews will take place during the week of the 2nd

  March at our location at Weesperplein 8.

• We ask every colleague who joins our team

  we require a recent Certificate of Good Conduct (VOG).

Do you have any questions about this job opening?

If you have any questions about the position or the application process, please contact

Iris Brandenburg – Love, Head of Consulting & Development,

via i.brandenburg@amsterdam.nl

or 06-22651035.

Unsolicited sales calls from

We do not approve of employment agencies, and this can lead to exclusion at

our other recruitment initiatives. This also includes agencies sending unsolicited resumes to

We view our employees as a source of new business. We do not accept these resumes

treatment.