Mi Analyst / Data Analyst

Business Area: Home Loans (Strategy and Business Analytics)

Role this role reports to Manager MIBI

Overall Job Purpose:

To provide core support to the business through the development and maintenance of accurate management
information and the analysis of available information. To provide valuable insights for strategic decision making and
accurate information for day-to-day operational management.
- - - - - - - - - - - - - -
Developer Duties:

• Development of high quality database solutions
• Develop, implement and optimize stored procedures and functions using T-SQL and
SAS
• Review and interpret ongoing business report requirements
• Research required data
• Build appropriate and useful reporting deliverables
• Analyze existing SQL and SAS queries for performance improvements
• Suggest new queries
• Develop procedures and scripts for data migration
• Provide timely scheduled management reporting
• Investigate exceptions with regard to asset movement

Experience Required:

• Three (3) years working within banking
• Three (3) years experience in the use of data base reporting tools and techniques
• Two (2) years experience in experience as a SQL and / SAS Developer or similar role
• Excellent understanding of T-SQL and SAS programming
• Excellent understanding of Microsoft SQL Server includingallpackages SSIS, SSAS,
SSRS and PBRS
• Two (2) years of experience with SQL Server Reporting Services, SQL Server
Integration Services, SQL Server Analysis Services and Power BI including PB Report
Server