Project description We've been engaged by a large Australian company to work on their Treasury projects.We are building a team from offshore that will work with the existing team.We require an experienced Data Analyst with strong experience with Microsoft SQL Server (preferablly with experience in Treasury but not mandatory) and broad exposure to financial markets.This will be a high profile engagement with a view to quickly grow our offshore footprint with this client.Responsibilities The role requires strong previous experience as an analyst in Data related functions and platforms, performing impact assessments, data discovery, data lineage, current state & gap analysis for complex data requirements Experience within Financial services preferred, ideally with exposure to the Risk, Treasury and Finance data domain.A natural ability to effectively influence and collaborate with multiple technical and non-technical groups of stakeholders, and work well with a range of internal cross functional teams is highly desirable.Define problems and opportunities.Perform business & technical data analysis that can be used to support or challenge business outcomes Effectively communicating requirements to stakeholders, managing conflicts, issues and changes in order to ensure that stakeholders and project team members remain in agreement on solution scope Skills Must have 2 to 5 years of experience as a SQL developer in Microsoft environment.Ability to write complex queries and optimize, handle large volumes and remain efficient in a production setting Good knowledge in Database data structures, Data-warehouse Need a bright and eager to learn candidate for this role Some exposure/understanding of banking/capital market Balance sheet management exposure: great plus Technical knowledge of writing complex queries/stored procedures.Understanding of data architecture and advanced data analysis skills Good communication skills.Must be able to understand requirements and explain technical solutions to business stakeholders and the team.Excellent troubleshooting and analytical skills.Able to investigate, analyse and troubleshoot tasks.Experience in query optimization.Familiarity with SSI packages for integration and execution of the stored procedure.Track record of data analysis and writing SQL queries/stored procedure in large-scale applications and transformations.Nice to have Basic knowledge of click view and control M is beneficial but not mandatory.A track record working as a developer in the Financial Service Industry and/or Treasury function or exposure to loans, interest rates, balance sheet related applications/datasets is desirable but not mandatory.Other Languages English: B2 Upper Intermediate Seniority Regular
