Q1
Walk me through how you would design a data model for a financial reconciliation system that tracks transactions across multiple accounts and identifies discrepancies in real time.
Why they ask this:* They want to assess your understanding of database design, data architecture, and domain knowledge specific to finance operations and reconciliation workflows.
Q2
Describe your experience with SQL and analytics tools (e.g., Tableau, Power BI, Looker). Can you give an example of a complex financial metric or KPI you've built and the queries or logic behind it?
Why they ask this:* Business Analysts in finance must translate business requirements into analytical solutions; this tests both technical proficiency and ability to communicate business value through data.
Q3
Explain the difference between descriptive, predictive, and prescriptive analytics. How have you applied each in a finance context?
Why they ask this:* This assesses whether you understand different analytical approaches and can choose the right methodology to solve business problems in financial decision-making.
Q4
What frameworks or methodologies (Agile, Waterfall, Six Sigma) have you used in finance projects, and how did you adapt requirements gathering and testing for regulatory or compliance constraints?