Financial Business Intelligence Analyst

About this role

Benefits:

• Bonus based on performance
• Health insurance
• Paid time off

As a Financial Business Intelligence Analyst, will leverage data analytics, financial modeling, and business intelligence tools to transform complex financial data into actionable insights. You will work cross-functionally with finance and IT teams to design dashboards, build ETL pipelines, and deliver intelligence reports that drive strategic decision-making for clients and internal stakeholders.

Job Responsibilities

• Analyze large financial datasets to identify trends, patterns, and anomalies in revenue, cost, and investment performance using Python (Pandas, NumPy) and SQL

• Design and develop interactive financial dashboards and reports using Power BI and Tableau for client decision-making and KPI tracking

• Build and maintain ETL pipelines using SQL Server Integration Services (SSIS) to consolidate financial data from multiple source systems into centralized data warehouses

• Perform variance analysis comparing actual vs. budgeted financial performance and present findings to client stakeholders

• Develop quantitative models for portfolio performance analysis, asset allocation, and risk assessment applying Modern Portfolio Theory and statistical methods

• Conduct scenario analysis and stress testing on financial models to evaluate investment strategies and risk exposure

• Calculate and monitor risk metrics including Value at Risk (VaR), Sharpe Ratio, and drawdown analysis for client portfolios

• Utilize Bloomberg Terminal data to support financial market analysis, equity research, and investment reporting

• Write and optimize complex SQL queries, stored procedures, and views to support financial reporting environments

• Translate business requirements from finance teams into technical BI specifications and deliver actionable financial intelligence reports

• Document data definitions, business rules, and financial reporting standards for internal and client use

-...