Data Analyst Ii (Avp) - Corporate Intelligence - Credit Risk
Current• Use of SQL to collect data from source tables to create reporting lists and summaries of mortgage and consumer loan information to various business lines across the company. Includes creating stored procedures in SQL, developing report and dashboards following departmental standards and presenting information solution to business users.• Created user applications or forms within Excel using VBA to give the users the ability to update and log key information with databases for reporting within their departments without needing to know SQL• Created and maintained tables within the databases which users or other applications write to.• Compiled data quickly and efficiently for Ad Hoc reports during times of audit.• Partner with developers to provide requirements for data models and automations to continuously improve the self-service business intelligence approach.• Discover and communicate meaningful insights in the data and communicate with the line of business users.• Develop and present business intelligence insights using variety of tools including Power point, Tableau