Explicitly calls out "vibe coding" and use of AI assistants (Claude, Copilot, ChatGPT) to accelerate analysis and dashboard prototyping.
About the Role
Senior BI Analyst responsible for defining and owning business metrics, building production-grade Power BI dashboards, and delivering actionable insights across Trading, Sales, Marketing, Product and Risk. The role combines deep SQL and data-modelling skills with stakeholder management and AI-augmented "vibe coding" workflows to improve trading volume, conversion and retention.
Job Description
Role
A Senior BI Analyst who partners with Trading, Sales, Marketing, Product and Risk to define North Star metrics, build decision-ready dashboards and drive measurable business outcomes. This is a high-visibility individual contributor role with direct engagement with C-level sponsors and a clear progression path into BI Lead and Head of BI.
Key Responsibilities
- Translate business requirements into clean data solutions and decision-ready metrics.
- Design, build and maintain production Power BI dashboards with robust data modelling, performance tuning and version-controlled semantic definitions.
- Write complex SQL (joins, window functions, CTEs) against large production datasets for extraction, transformation and analysis.
- Own business metrics, KPIs and reporting frameworks, including metric dictionaries and ownership/versioning.
- Conduct deep-dive analysis on customer behaviour, trading activity, funnel conversion and revenue drivers and turn findings into testable recommendations.
- Provide actionable insights that improve trading volume, client lifetime value, conversion and retention.
- Leverage modern AI tools and βvibe codingβ workflows to accelerate analysis, prototype dashboards and automate repetitive BI tasks.
- Communicate findings clearly to senior stakeholders and drive execution to close the loop.
Requirements
- 5β8 years in data analysis / BI / analytics roles, with at least 2 years in a Senior IC capacity.
- Strong SQL skills (multi-table joins, window functions, CTEs, aggregations) and experience with performance tuning on large fact tables.
- Hands-on Power BI experience at production level: dashboard design, data modelling (star schema), DAX, RLS, and semantic model governance.
- Strong business acumen; ability to connect metrics to real-world outcomes.
- Comfortable using AI tools (Claude, Copilot, ChatGPT) and modern data workflows to boost productivity.
- Excellent written and verbal communication and stakeholder management up to C-level.
- Strong execution and ownership mindset; ability to drive decisions through to measurable impact.
Nice to Have
- Direct exposure to CFD / MT4 / MT5 data models (trades, positions, P&L, spreads, slippage).
- CFA or finance-related degree / CFA candidate status.
- Experience with dbt, Snowflake, Databricks or similar modern data stacks.
- Prior work on semantic layer / metric dictionary projects.
- Exposure to AML/compliance reporting, risk reporting, or broker P&L attribution.
Benefits
- Work on high-volume trading data powering a leading CFD platform.
- Clear progression pathway: Senior BI Analyst β BI Lead β Head of BI.
- Genuine hybrid model with a structured work-from-home benefit.
- Conference, certification and AI-tooling budget.
- Opportunity to work with Power BI, modern data stack and AI-native workflows without legacy constraints.