Business Intelligence Analyst
91% skill overlap
Your role
BI Analyst (Banking)
Full profileYour role
- L3 salary
- Not published yet
- Upcoming dated changes
- 6 changes ahead
What the role does
A business intelligence (BI) analyst in banking turns operational, financial and risk data into dashboards and reports that managers use to run the business. Typical subjects are trade and settlement volumes, breaks and fails, client activity, revenue and cost, and service level indicators. The role writes SQL (Structured Query Language) queries, builds data models and visualisations in tools such as Power BI or Tableau, checks data quality and works with business users to define the right measures.
Read a day in the life
A day in the life
The day often begins with a check that overnight data refreshes have run and that key dashboards show complete figures. If a feed failed or numbers look odd, the analyst traces the problem back through the data pipeline and tells users. Then come requests: an operations manager wants settlement fails by counterparty and market, a finance lead asks for revenue by client segment. The analyst clarifies what each measure means, for example whether a fail counts on the intended settlement date or after, writes the queries, and checks results against an existing report. Late morning may be a meeting with data engineers about a new source table. In the afternoon the analyst builds or improves a dashboard, paying attention to clear layout, definitions and access rights for sensitive data. The day can end with a short demo to users, documenting the measures in a data catalogue and planning the next sprint.
Levels
- L1 Starting out
- L2 Independent
- L3 Senior or specialist
- L4 Leads a team or an area
- L5 Leads the function
Full level descriptions and job titles
The EFO level names are the common scale; job titles differ between employers.
| Level | What the work looks like | Typical years | Typical job titles |
|---|---|---|---|
| L1 Starting out | Maintains existing reports and dashboards, writes simple queries, checks data refreshes and learns banking processes, data sources and BI tools under supervision. | 0-2 | Banks: Analyst, Junior Analyst, Associate (asset servicing), Trainee, GraduateAsset servicers: Junior, Specialist (entry), Officer |
| L2 Independent | Owns dashboards for a business area end to end, gathers requirements, defines measures with users, designs data models and trains new analysts and users. | 2-5 | Banks: Analyst / Senior Analyst, AssociateAsset servicers: Specialist, Senior Specialist, Senior Officer |
| L3 Senior or specialist | Designs reporting solutions across several data sources, sets standards for measures and visual design, handles data quality issues at the root and represents BI in data projects. | 5-9 | Banks: Senior Associate, AVP, Assistant ManagerAsset servicers: Senior Specialist, Expert, Team Lead (small team) |
| L4 Leads a team or an area | Leads a BI team, owns the reporting portfolio, prioritisation and service levels, manages access and data controls and is the escalation point for reporting incidents. | 8-14 | Banks: VP, Manager, Senior ManagerAsset servicers: Team Lead, Manager, Head of Section |
| L5 Leads the function | Accountable for management information and BI in a business line or region, sets the reporting strategy, tooling and standards, and reports to senior management on data and insight. | 12+ | Banks: Director, Executive Director, Managing Director, Head of functionAsset servicers: Head of Department, Director |
Skills
Where the skill weights come from
Each role lists its skills with a tier and a weight. The weights of one role add up to 100 percent.
Source: the EFO role catalogue, built from the ESCO classification and reviewed by the editors.
The percentage is the skill's share of the role; the bars are drawn relative to the anchor skill, which is shown full.
Critical
- Visualisation tools (Power BI, Tableau)Weight 13.3%Relevant to you
- Querying data with SQLWeight 8.9%Relevant to you
- Data modelling and schema designWeight 8.9%Relevant to you
- Data cleaning and validationWeight 8.9%Relevant to you
- Trade lifecycleWeight 8.9%Relevant to you
Important and supporting skills 17
Important
- ETL/ELT pipeline designWeight 4.4%Relevant to you
- Advanced Microsoft ExcelWeight 4.4%Relevant to you
- Data governance, quality and lineageWeight 4.4%Relevant to you
- Communicating data to non-technical audiencesWeight 4.4%Relevant to you
- Choosing the right metric for the questionWeight 4.4%Relevant to you
- Attention to detailWeight 4.4%Relevant to you
- Stakeholder managementWeight 4.4%Relevant to you
- Process mapping and redesignWeight 4.4%Relevant to you
Supporting
- Data platforms (Snowflake, BigQuery)Weight 2.2%Relevant to you
- Orchestration tools (Airflow, dbt)Weight 2.2%Relevant to you
- Descriptive statistics and distributionsWeight 2.2%Relevant to you
- Design judgment and trade-offsWeight 2.2%Relevant to you
- Collaboration and teamworkWeight 2.2%Relevant to you
- Defining and using KPIsWeight 2.2%Relevant to you
Useful
- Python for data analysisWeight 0.7%Relevant to you
- Git version controlWeight 0.7%Relevant to you
- Professional written communicationWeight 0.7%Relevant to you
Processes
The work the role takes part in.
What each process covers
- Securities settlementMain
- Trade capture and bookingMain
- Trade confirmation and affirmationMain
- Change and project deliverySupporting
- Data management and governanceSupporting
Where the role concentrates
How AI is changing the role
BI tools now include natural language query and automatic insight features, and generative AI writes much routine SQL and chart code.
Read the full assessment
BI tools now include natural language query and automatic insight features, and generative AI writes much routine SQL and chart code. The World Economic Forum Future of Jobs Report 2025 names AI and big data as the fastest-growing skill area, and data analysts among roles in growing demand. Routine report building shrinks. Value moves to defining measures that mean the same thing for everyone, modelling data correctly, ensuring quality and lineage, and explaining what the numbers say for a decision. Analysts who understand banking processes and data governance, and who can check AI-generated queries, stay in demand.
Dated changes for this role
- ESMA guidelines on allocations and confirmations for T+1Relevant to you
- CSDR settlement discipline rules updated for T+1 in three stepsRelevant to you
- ECB Pontes: DLT settlement in central bank moneyRelevant to you
- Switzerland and Liechtenstein move to T+1 with the EU and UKRelevant to you
- EU securities settlement moves to T+1Relevant to you
Worth knowing
- TARGET Services November 2026 releases moved to 28 November 2026
- DORA register of information: 2027 annual submission
- Swift defers SR2026 and the end of unstructured addresses
- CSRD scope narrowed by Omnibus I; second wave reports from financial year 2027
- Pay Transparency Directive: first gender pay gap reports
Salary snapshot
Salary figures are not published yet
The L3 salary range for this role, with its sources, will appear here when the salaries section opens.
Certifications
- Microsoft Power BI Data Analyst PL-300
- Tableau Desktop Specialist
- SnowPro Core
- dbt Analytics Engineering
Concepts to know
Neighbouring roles
Roles that need many of the same skills, by weighted skill overlap, with the skills you would need to add.
Data Analyst (Banking)
63% skill overlap
To add: Hypothesis testing and significance, Structuring ambiguous problems
Your role
Data Governance Analyst
60% skill overlap
To add: Hypothesis testing and significance, Structuring ambiguous problems
Your role
Data Analyst
58% skill overlap
To add: Hypothesis testing and significance, Structuring ambiguous problems
Your role
Master Data Specialist
43% skill overlap
To add: Master data management, SAP enterprise systems, Data entry and record keeping accuracy
Your role
Trade & Transaction Reporting Analyst
37% skill overlap
To add: Trade and transaction reporting, Period-end close and reconciliations, Investment book of record and portfolio data
Your role
Do this job? Suggest a correction
Sources
Business intelligence (BI)Business intelligence is the set of tools and practices that turn data into dashboards and reports for decisions, such as sales, cost, risk or service metrics. Typical tools are Power BI and Tableau, fed by a data warehouse.
SQL (Structured Query Language)SQL is the standard language for defining, querying and changing data in relational databases, standardised as ISO/IEC 9075. Analysts use it to select, filter, join and aggregate tables; it is the most requested technical skill in finance data roles.
Intended settlement dateThe intended settlement date (ISD), also called the contractual settlement date, is the date agreed in a trade on which securities and cash should change hands. For trades on EU trading venues the Central Securities Depositories Regulation (CSDR) sets it at no later than two business days after the trade date, moving to one business day from October 2027.
Data catalogueA data catalogue is a searchable inventory of an organisation's data assets with their metadata: descriptions, owners, location, quality scores and lineage. Users search it to find trusted data before building a report or model. Also spelled data catalog.
Generative AIGenerative AI is a family of AI models that produce new content (text, code, images, audio) in response to a prompt, by learning patterns from very large datasets. In finance it is used for drafting, summarising documents, coding help and customer service assistants.
Data governanceData governance is the set of roles, policies, standards and forums that decide how data is defined, owned, protected and kept fit for use. It assigns accountability (data owners and stewards), sets quality thresholds and resolves disputes on definitions.