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.
