Senior Data Analyst (Investment Banking)

Overview: We are seeking a highly skilled Data Analyst with advanced expertise in Microsoft Access, Excel, and strong analytical capabilities. The ideal candidate will play a critical role in strengthening control plans, identifying gaps across data sources, and producing meaningful reports to support decision-making within a financial services environment. Key Responsibilities: • Perform in-depth analysis of data points from multiple sources to identify gaps, strengthen control frameworks, and improve data quality. • Design, develop, and maintain advanced Microsoft Access databases, ensuring accuracy, efficiency, and sustainability. • Utilize Advanced Excel functions (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, VBA) to build models, automate processes, and reconcile complex datasets. • Write and execute complex SQL queries to extract, manipulate, and analyze large data sets. • Support the development of Power BI dashboards and reports (preferred) to deliver actionable insights to stakeholders. • Reconcile processes, applications, vendors, and contracts to ensure accurate and consistent reporting. • Collaborate with stakeholders to understand critical financial processes and data requirements. • Produce accurate, timely, and detailed reports for management and regulatory purposes. Qualifications: • Proven experience as a Data Analyst, preferably within a financial institution or related industry. • Advanced proficiency in MS Access (database design, queries, automation). • Advanced knowledge of Microsoft Excel, including VBA scripting and Power Query. • Strong ability to write, optimize, and troubleshoot complex queries. • Experience with Power BI or other data visualization tools (preferred). • Strong understanding of data reconciliation processes, vendor/contract analysis, and financial applications. • Excellent problem-solving skills with a keen eye for identifying data inconsistencies and control gaps. • Strong communication and collaboration skills.