Develops Tableau dashboards and reports, analyzes complex datasets, and delivers actionable market, product, operational, commercial, and financial insights. Collaborates with technical and business stakeholders, writes optimized SQL for SQL Server and Snowflake, promotes data governance and quality, automates analytical workflows, builds data pipelines and API integrations, and maintains version-controlled code using modern deployment practices.
We are looking for a highly capable and self-driven BI professional to join our growing Business Intelligence team, providing market, product, operational, commercial and financial insights for stakeholders across Trayport. As a core member of the BI team, you will be instrumental in transforming complex, often unstructured data into clear, actionable insights that drive strategic business decisions.
You are a self-starter who thrives in ambiguity and isn't afraid of "messy" data. More than just a technical expert, you act as a bridge between our data infrastructure and the wider business, seamlessly adapting your communication style to collaborate with both technical engineering teams and non-technical stakeholders.Key Responsibilities
Required Skills
Desirable Skills (Nice to Have)
You are a self-starter who thrives in ambiguity and isn't afraid of "messy" data. More than just a technical expert, you act as a bridge between our data infrastructure and the wider business, seamlessly adapting your communication style to collaborate with both technical engineering teams and non-technical stakeholders.Key Responsibilities
- End-to-End Analytics: Design, develop, and maintain interactive, high-performance dashboards and reports using Tableau.
- Stakeholder Collaboration: Build strong relationships across departments, acting as a trusted data advisor to both technical teams and non-technical business leaders.
- Data Storytelling: Extract meaning from messy, complex datasets and present clear, compelling visual narratives that guide executive decision-making.
- Database Management: Write, optimize, and troubleshoot complex queries within SQL Server and Snowflake environments to ensure efficient data extraction and processing.
- Data Governance & Quality: Champion data governance best practices, ensuring high data literacy, accuracy, and security across the organization.
- Automation & Scripting: Enhancing our analytical capabilities through automation, building data pipelines, and integrating APIs. Using AI tooling where appropriate, demonstrating an understanding of its strengths and limitations.
- Code Management: Maintain clean, version-controlled code using Git/source control best practices.
Required Skills
- BI Expertise: Hands-on experience with leading BI visualization tools (Tableau, QuickSight, Power BI) in a commercial analytics role
- Interpersonal & Communication Skills: Excellent communication skills with the ability to translate complex technical concepts into plain language, managing stakeholder expectations and building cross-functional relationships.
- Data Literacy & Governance: Highly data literate with a strong grasp of data governance principles, data modeling, and master data management.
- Database Skills: Strong proficiency with SQL, with the ability to write robust, performant queries and manage relational data.
- Programming: Practical coding experience in Python, .NET or similar for data manipulation, scripting, and automation.
- Engineering Best Practices: Solid understanding of source control (e.g., Git) and modern deployment workflows.
- Mindset: A proactive self-starter who is comfortable navigating ambiguity and bringing structure to messy data environments. Naturally curious who will dig a level deeper into the data and question assumptions.
Desirable Skills (Nice to Have)
- Snowflake, DBT, Airflow: Practical experience working with Snowflake, DBT and Airflow
Trayport is committed to creating and sustaining a collegial work environment in which all individuals are treated with dignity and respect and one which reflects the diversity of the community in which we operate. We provide accommodations for applicants and employees who require it.
Trayport London, England Office
7th Floor, 9 Appold Street, London, United Kingdom, EC2A 2AP
Similar Jobs
Automotive • Insurance • Logistics • Professional Services
Develop and maintain Power BI dashboards and reports, translate stakeholder requirements into actionable insights, support data preparation and modelling, validate data quality, and help migrate legacy Excel and Tableau reporting. The role collaborates with Data Engineering and business stakeholders, applies BI standards, documents datasets and business logic, and contributes to continuous improvement across reporting and analytics processes.
Top Skills:
AzureDaxExcelMicrosoft FabricPower BISQLTableau
Digital Media • Information Technology • Sports • Analytics
Develop interactive BI applications, customer reports, dashboards, and automated reporting processes. Query and model large datasets using SQL, Power BI, Excel, DAX, and Power Query. Collaborate with business and technical stakeholders to improve data-driven products, establish reporting solutions, support data governance and security, and contribute to the business intelligence roadmap.
Top Skills:
Amazon AthenaAmazon RedshiftDaxExcelMicrosoft Sql ServerPower BIPower QuerySQLVBA
Information Technology • Sports
Develop interactive business intelligence applications, customer reports, dashboards, and automated reporting processes. Query and model large datasets using SQL, create Power BI and Excel visualizations, support data governance and security, and collaborate with business and technical stakeholders. The role also contributes to the BI roadmap, recommends innovative data solutions, and presents analytical ideas clearly to users and developers.
Top Skills:
Amazon AthenaAmazon RedshiftDaxExcelMicrosoft Sql ServerPower BIPower QuerySQLVBA
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.



