Business Intelligence Analyst

**Business Intelligence (BI) Analyst**

A vibrant FX Brokerage House are seeking a Business Intelligence Analyst with a minimum 1+ years’ experience (ideally 2+) to work within their Financial Planning and Analysis team supporting the whole company.

The Business Intelligence Analyst is responsible for creating a strategy for collecting and analysing customer and drawing insights beneficial for both commercial optimization and future product development. You’ll be responsible for creating insightful,accurate analysis and presenting this to stakeholders in understandable and actionable formats.

You’ll be building data sets for the organization, maintaining data integrity and developing business intelligence solutions, (dashboards, reports, visualisations).

Producing high quality and high impact analytical work, this is an exciting opportunity to work across the business and shape the course of the company moving forward.

**Duties and responsibilities**:

- Develop a thorough understanding of business objectives and issues, interpret business needs into data and analytical requirements, and deliver valuable insights to internal customers to support operational needs and strategic planning
- Extraction and analysis of data to the specifications required by the business
- Regular reconciliation and validation of the daily reporting.
- Liaise with the Sales Managers to gather requirements for future projects and to ensure alignment of strategic goals.
- Build and maintain existing dashboard reports, assisting the Sales team with any queries or troubleshooting issues.
- Provide proactive advice to the Sales Management Team around trends and opportunities as well as any recognizable retention issues.
- Working cross-departmentally including Sales, Financial Reporting Team and Chief of Staff on KPI monitoring.
- Involvement in Group PLC annual report and investor presentations with a focus on producing KPIs.

**Required Skills**:

- In-depth SQL knowledge and understanding of relational schemas, ideally in Microsoft SQL Server
- Some knowledge of procedural SQL, an ability to strip down stored procedures and functions to reverse engineer logic
- Ability to build and manage BI reports
- Ability to build and maintain dashboards, with drill downs
- Experience with Tableau and/or proficient in BI products
- Develop reports from the data warehouse
- Ability to analyse large data sets
- Digest concepts and effectively transfer this into actionable analysis
- 'Can do’ attitude

**Desirable**:

- Previous Financial / Banking experience ideally with some business knowledge of Foreign Exchange / FX and or payments.
- Knowledge of financial reporting, controls or audits.