355 Best excel outlook Jobs in Madrid (July 2026)

Treasury Associate - (Re-Advertisement) - [Open to internal and external applicants who are nat[...]

2 days ago

Madrid

ppbThis vacancy is open to nationals of EU Member States, Iceland, Liechtenstein, Norway, or Switzerland. /b /p h3Background /h3 pThe Bureau for Management Services’ Office of Financial Resources Management (BMS/OFRM) supports the United Nations Development Programme (UNDP) in the implementation of the 2030 agenda and UNDP’s Strategic Plan. It achieves this by developing and making fully operational a dynamic and harmonized integrated resource management framework based on comprehensive analysis that enhances UNDP’s financial and administrative performance, as well as facilitating UN reform and coherence. The primary role of BMS/OFRM is to maintain the financial integrity of UNDP through providing functional leadership, supporting the efficient and effective management of its financial resources, promoting financial sustainability and responsible resource allocation. This is accomplished by the development and implementation of sound financial policies and practices, oversight of corporate financial management performance, and flexible scalable support to resource allocation. BMS/OFRM serves as a business partner to Bureaux and Country Offices, providing sound financial management, advisory and analytical services, with a view to continuously improve the financial management performance of business units and support Bureaux in the exercising of their oversight functions. /p pWithin OFRM, the Treasury Division oversees cash, currency and banking risks globally in over 130 countries and over 100 currencies, managing the organization’s liquidity with centralized investment of excess cash balances to meet its liabilities. Treasury Division maintains policy and oversight of global payments and receivables, cash management, manages banking relationships, compliance, and KYC. The Treasury Division safeguards UNDP’s financial assets and ensures efficient, transparent global payments supporting programme delivery. As digital technologies transform global finance, Treasury is accelerating modernization to enhance speed, cost efficiency, transparency, and automation. /p h3Scope of Work /h3 pUnder the direct supervision of the Treasury Specialist, the Treasury Associate provides analytical support and services in the day-to‑day cash management areas, monitoring of imprest cash levels, conducts compliance oversight, and problem solves for local cash management, cash replenishment from HQ, petty cash operations, and bank account and signatory management. The incumbent works closely with the Treasury Officer and Treasury Associates within the team, Investment Specialist in the Investment unit to process CO replenishment through FX Optimization program, repatriation of excess fund, and to support with the data analysis for CO imprest management, cashflow forecasting, to ensure a resilient, flexible, and scalable global support model. /p h3Duties and Responsibilities /h3 h3Support Country Offices in having adequate local and hard currency balances to optimally meet operational needs /h3 ul liProvide analytical and modelling support to the Treasury Officer and Investment Specialist in developing and refining cash‑flow forecasting models that enable Country Offices to accurately determine optimal imprest levels. Utilize trend analysis, sensitivity testing, and scenario modelling to strengthen Country Office liquidity planning. /li liAssess and advise on optimal currency positioning, ensuring that Country Offices maintain adequate balances in both local and hard currencies to meet operational expenditures efficiently while minimizing FX exposure, liquidity constraints, and idle cash. /li liReview and validate replenishment requests submitted through UNall or other channels, conducting detailed checks for accuracy, completeness, and compliance with imprest management policies, liquidity thresholds, and Treasury’s internal control framework. Ensure that requests align with available HQ liquidity and Country Office expenditure patterns before processing. /li liAnalyze Country Office short‑term and medium‑term cash‑flow requirements, using historical disbursement patterns, pipeline data, and operational projections. Based on validated needs, process EFTs in FIS/Integrity with full adherence to settlement timelines, funding windows, and FRR requirements. /li liDevelop and maintain monitoring dashboards and tracking reports, utilizing analytical tools to identify anomalies, unusual fund movements, recurrent errors, or potential control gaps. Escalate material risk indicators and provide evidence‑based recommendations for corrective action. /li /ul h3Bank Signatory updates of Country Office Bank accounts including review of internal control compliance /h3 ul liConduct periodic and systematic reviews of the aging status of all bank account signatory changes to ensure their accuracy, validity, and timely implementation. Perform analytical checks to identify lags, control gaps, or inconsistencies in signatory updates maintained by Country Offices and Headquarters. /li liRun compliance and control reports to verify adherence to UNDP Financial Regulations Rules (FRRs) and segregation‑of‑duties requirements governing bank signatories. Perform variance and exception analysis to identify discrepancies, potential conflicts, or breaches in authority structures, and initiate immediate corrective actions in coordination with relevant business units. /li liProcess and validate bank signatory updates for Zero Balance Accounts (ZBAs), ensuring completeness and accuracy of documentation, proper authorization, and full alignment with Treasury’s internal control framework. Review and verify signatory updates submitted by Country Offices, flag anomalies, and ensure timely resolution to maintain institutional banking integrity. /li liPrepare high‑quality documentation for management approval, maintaining comprehensive, audit‑ready records of all signatory changes. Serve as a liaison with banking partners to coordinate updates, clarify requirements, and support due‑diligence processes, ensuring uninterrupted account operability and alignment with banking compliance standards. /li /ul h3Monitor and manage open cases and inquiries from Country Offices to ensure timely resolution /h3 ul liManage and analyze zero‑balance account (ZBA) payment inquiries, evaluating and ensure proper end‑of‑day resolution. /li liTriaging and resolving ServiceNow (UNall) inquiries from country offices by assessing operational bottlenecks, data‑quality problems, or payment routing errors; provide authoritative guidance on Treasury processes and elevate system defects or recurring patterns to functional teams with documented root‑cause insights. /li liProcess, track, and resolve payment recall requests and investigate returned or rejected payments by analyzing SWIFT return codes, sanction screening outcomes, and account validation errors; coordinate remediation with banks, country offices, and internal stakeholders to ensure timely recovery or re‑execution. /li /ul h3Coordinate periodic publication of UN Operational Exchange Rate (UNORE) /h3 ul liCollect, validate, and analyze local exchange rates submitted by Country Offices, applying reasonableness checks, and outlier detection. Update the UNORE working files with validated data and ensure timely submission for UNORE setup in accordance with the established monthly and ad‑hoc rate‑setting schedule. /li liExecute specialized rate‑upload activities by performing manual UNORE uploads in the ERP for specific currencies that require non‑standard treatment or exceptional handling. Verify accuracy of rate mapping, system posting logic, and downstream impacts on Treasury, Finance, and Country Office transactions. /li liConduct ongoing governance of the UNORE calendar, ensuring that rate‑setting timelines, blackout periods, and processing cycles are accurately reflected and proactively updated. Identify scheduling conflicts or operational risks that could affect timely publication of operational rates. /li liProvide technical oversight of the UNORE SharePoint site, which serves as the central platform for rate collection and communication with Country Offices. Troubleshoot functionality issues, support CO users with error resolution, and elevate technical problems to IT support teams as needed to maintain system reliability. /li liDeliver analytical insights by identifying anomalies in rate submissions, significant FX fluctuations, recurring data quality issues, or country‑specific risks. Escalate material deviations and provide recommendations for corrective action or further review by Treasury management. /li /ul h3Monitor country office compliance with the Internal Control Framework, cash management procedures and policies on an ongoing basis /h3 ul liContinuously monitor Country Office bank balances to assess the receipt of local contributions, identify excess cash positions relative to established imprest benchmarks, and detect liquidity inefficiencies. /li liPerform variance and trend analysis to flag abnormal accumulation of funds or deviations from expected cash‑flow patterns. /li liOversee and analyze Country Office local investment activities, where authorized, by reviewing compliance with imprest ceilings, liquidity thresholds, and investment eligibility criteria. Conduct exception analysis to ensure that local investments are aligned with Treasury’s risk parameters and do not expose UNDP to undue financial or operational risk. /li liIdentify and follow up on aged petty cash and cash‑arrangement exceptions, applying root‑cause analysis to detect control weaknesses, delayed clearances, or repeated non‑compliance. Work with Country Offices to implement corrective actions, strengthen internal controls, and ensure timely liquidation of outstanding cash balances. /li liSupport the annual Treasury Certification process by providing analytical inputs, validating Country Office cash management data, and verifying compliance against Treasury control requirements. Prepare documentation, reconcile evidence, and ensure that certification activities are audit‑ready and consistent with UNDP Financial Regulations Rules (FRRs) and the Internal Control Framework (ICF). /li /ul h3Prepare periodic country office/ Bureau Cash Management Review /h3 ul liLead quarterly analytical reviews of Country Offices and bureaux performance, synthesizing financial and operational indicators into concise One‑Pager executive briefs. Apply trend, variance, and cohort analysis to surface key drivers, structural shifts, and outliers that require management attention. /li liDesign and maintain a standardized One‑Pager framework with consistent KPIs (e.g., cash utilization vs. imprest benchmarks, settlement efficiency/STP, FX exposure to UNORE, aging exceptions, compliance status against FRRs/ICF controls). /li liConduct comparative and cohort analysis across regions, bureaux, and peer Country Office clusters to benchmark performance, identify recurring pain points, and highlight leading practices. Use time‑series and seasonality checks to distinguish structural issues from cyclical patterns. /li liTrack implementation of recommendations through a formal follow‑up and verification cycle, including evidence reviews (e.g., updated SOPs, corrected SSIs, reconciliations cleared, system fixes deployed). /li liDevelop management dashboards and drill‑down reports (Power BI or equivalent) that visualize KPI movements, red‑amber‑green statuses, and heat maps of risk concentrations. Enable Country Offices and bureaux to self‑monitor and pre‑empt exceptions before quarter close. /li /ul h3Facilitate knowledge sharing /h3 ul liSynthesize lessons learned and best practices in financial management. /li liProvide sound contributions to knowledge networks and communities of practice. /li liThe functions are assigned and distributed by the supervisor in the team as necessary. The incumbent performs other duties within their functional profile as deemed necessary for the efficient functioning of the Office and the Organisation. /li /ul h3Institutional Arrangement /h3 ul liThe position is part of a team of four members, including the supervisor, and has no direct reports.br/ /li /ul h3Competencies /h3 h3Core /h3 h3Achieve Results: LEVEL 1 /h3 ul liPlans and monitors own work, pays attention to details, delivers quality work by deadline /li /ul h3Think Innovatively: LEVEL 1 /h3 ul liOpen to creative ideas/known risks, is pragmatic problem solver, makes improvements /li /ul h3Learn Continuously: LEVEL 1 /h3 ul liOpen minded and curious, shares knowledge, learns from mistakes, asks for feedback /li /ul h3Adapt with Agility: LEVEL 1 /h3 ul liAdapts to change, constructively handles ambiguity/uncertainty, is flexible /li /ul h3Act with Determination: LEVEL 1 /h3 ul liShows drive and motivation, able to deliver calmly in face of adversity, confident /li /ul h3Engage and Partner: LEVEL 1 /h3 ul liDemonstrates compassion/understanding towards others, forms positive relationships /li /ul h3Enable Diversity and Inclusion: LEVEL 1 /h3 ul liAppreciate/respect differences, aware of unconscious bias, confront discrimination /li /ul h3Cross-Functional Technical /h3 h3Business Management - Customer Satisfaction/Client Management /h3 ul liAbility to respond timely and appropriately with a sense of urgency, provide consistent solutions, and deliver timely and quality results and/or solutions to fulfil and understand the real customers' needs. Provide inputs to the development of customer service strategy. Look for ways to add value beyond clients' immediate requests. /li liAbility to anticipate client's upcoming needs and concerns. /li /ul h3Business Management - Communication /h3 ul liCommunicate in a clear, concise and unambiguous manner both through written and verbal communication; to tailor messages and choose communication methods depending on the audience. Ability to manage communications internally and externally, through media, social media and other appropriate channels /li /ul h3Finance - Treasury Cash Management /h3 ul liAbility to manage organization's cash and investment holdings with the ultimate goal of maximizing liquidity and mitigating risks. Understands the economic environment, interest rates and the importance of economic forecasting. Understands and can implement a treasury management strategy, including cash flow management, debt management and investment strategies. /li /ul h3Finance - Anti-fraud and anti-bribery and corruption /h3 ul liAnti-bribery and corruption: Understands the policy and best practice relating to anti-bribery and corruption controls and ensures these are implemented and widely understood within the organization. /li liAnti-fraud: Understands the fraud risks faced by public bodies and is able to effectively analyse data to support fraud identification and fraud risk management; understands the fraud risks faced by public bodies and is able to conduct fraud risk assessment and response plan. /li /ul h3Finance - Banking and cash management /h3 ul liAbility to collect, handle, and manage cash, which involves assessing market liquidity, cash flow, and investments. /li /ul h3Finance - Finance Business Partnering /h3 ul liAble to support business units and add value by innovating and providing solutions to financial issues/queries, including through FAQs, financial tools, advisory, etc. Influences and appropriately challenges non-finance colleagues for whom the service is being provided. Understands the operations, opportunities and challenges of the organization. Holds a commercial outlook, demonstrating accountability towards organizational goals. /li /ul h3Required Skills and Experience /h3 h3Education /h3 ul liCompletion of Secondary Education is required with specialized certification in Accounting, Finance or Treasury. /li liFirst level University degree (Bachelor’s Degree) in Finance or Accounting .or equivalent field will be given due consideration, but not a requirement. /li liPart-qualified accountants from a recognized institute of accountancy, or relevant Treasury qualification, will have a distinct advantage. /li liCandidates with no professional accountancy qualifications, but with degrees that major in accountancy and/or finance must complete UNDP Finance Training and Certification Programme (FTCP), if recruited. However, no UNDP Accountancy and Finance Test (AFT) is required. /li liCandidates with no professional accountancy qualifications but with relevant experience must successfully undertake UNDP Accountancy and Finance Test (AFT) before shortlisting, and must complete the UNDP Finance Training and Certification Programme (FTCP), if recruited. /li /ul h3Experience /h3 ul liMinimum of seven (7) years (with Secondary Education) or four (4) years (with Bachelor’s degree )in corporate treasury, FX operations, banking, or financial analytics. /li liExperience, Knowledge, and skills /li liExperience with ERP financial systems (e.g., Oracle). /li liExperience and sound understanding of banking, cash management, global payments system. /li liAdvanced proficiency in Excel, BI and database packages. /li liStrong quantitative and analytical skills /li liProven knowledge of IPSAS, IFRS and/or GAAP. /li liDemonstrated experience in AI, digital transformation, and process automation. Eager to explore and apply new technologies. /li liExperience as a collaborative team player with flexibility to work across global time zones. /li /ul h3Desirable Criteria /h3 ul liHands‑on experience with Treasury Management Systems (TMS), including transaction processing, reporting, or system administration. /li liDemonstrated experience in cash management, including liquidity management, forecasting, and reconciliation activities. /li liProven ability to serve and communicate effectively with clients from diverse and multicultural backgrounds, demonstrating cultural sensitivity and adaptability. /li /ul h3Required Language(s) /h3 ul liFluency in English is required. Working knowledge of an official UN Languages an advantage. /li /ul h3Professional Certificates /h3 ul liDistinct Advantage: ACT, CFA, ACCA, CPA, CIMA, CIPFA, or other internationally recognized accounting certifications. /li /ul h3Equal opportunity /h3 pAs an equal opportunity employer, UNDP values diversity as an expression of the multiplicity of nations and cultures where we operate and, as such, we encourage qualified applicants from all backgrounds to apply for roles in the organization. Our employment decisions are based on merit and suitability for the role, without discrimination. /p pUNDP is also committed to creating an inclusive workplace where all personnel are empowered to contribute to our mission, are valued, can thrive, and benefit from career opportunities that are open to all. /p h3Sexual harassment, exploitation, and abuse of authority /h3 pUNDP does not tolerate harassment, sexual harassment, exploitation, discrimination and abuse of authority. All selected candidates, therefore, undergo relevant checks and are expected to adhere to the respective standards and principles. /p /p #J-18808-Ljbffr

Excel outlook jobs in MadridCreate job alerts

Popular jobs searches in Madrid

Jobs by neighbourhood

Popular excel outlook jobs locations