Our client is seeking a Senior Quantitative Analyst to join their team in Auckland CBD for a 6-month inital contract. This role is an exciting opportunity for a highly skilled professional to support current processes with spreadsheet managment during a busy period. The successful candidate will be instrumental in improving spreadsheet management, automating processes, and implementing best practice data analysis solutions. This role offers the chance to work on high-impact projects within the financial services industry.

What you'll do:

• Address risks in spreadsheet management, including automated back-ups of key spreadsheets, consistent formatting, best practice code, clear file management system, checks of any changes, process/procedure support documentation
• Create tables for the Cashflows spreadsheet in a data warehouse
• Automate filing
• Deliver training/capability uplift for team to ensure spreadsheet infrastructure can be supported and maintained

What you bring:

• Expertise in advanced Microsoft Excel functions, including VBA, Power Query, and Pivot Tables.
• Proficient in SQL and Python, with significant experience in data analysis and automation.
• Familiarity with data visualization tools such as Power BI.
• Deep understanding of spreadsheet best practices, emphasizing risk management and maintaining data integrity.
• Skilled in using version control systems and collaborative platforms like SharePoint.
• Proven track record of identifying inefficiencies and designing effective automation solutions.
• Experienced in documenting processes and creating streamlined workflows.
• Strong ability to engage stakeholders, gather requirements, and provide clear, regular updates.
• Adept at developing training materials and upskilling team members through clear documentation and instruction.
• Capable of analyzing complex processes and recommending logical, scalable improvements.
• Detail-oriented with a commitment to continuous improvement, error reduction, and operational efficiency.
• Hands-on experience with user acceptance testing.
• Knowledgeable about financial markets, including end-of-day reporting, currency-related challenges, and financial instruments.

Robert Walters endeavours to review all applications in a maximum of five working days. If you have not received correspondence within this timeframe please do not hesitate to contact Liberty Jack on +64 9 374 7300.