BI Engineer

TMX Group; City Of London; On-site; GBP 90,000 - 130,000; Full time

Job summary

Trayport is seeking a highly technical Business Intelligence Engineer to join our BI team in London. You will architect a robust data warehouse, automate data ingestion, and deliver user-friendly dashboards that surface actionable insights for stakeholders.

You will collaborate across Data Engineering and BI Analysts, mentor teammates, and translate complex data concepts for executives. The ideal candidate combines deep SQL, Python, data warehousing expertise, and a passion for data-driven

Qualifications

• Advanced SQL skills and performance tuning required.
• Strong Python or similar for data manipulation.
• Deep understanding of data warehousing concepts.
• Experience with Tableau or equivalent BI tools.
• Familiarity with source control (Git).
• Excellent communication across technical and non-technical audiences.

Responsibilities

• Design, build, and maintain a robust data warehouse.
• Ingest, validate, and automate data pipelines at scale.
• Create dashboards and visualisations for business metrics.
• Ensure data quality and governance across the organization.
• Collaborate with stakeholders, including the C-suite, to drive data-driven decisions.
• Mentor BI Analysts and promote best practices.

Skills

SQL

Python

Data Warehousing

Tableau

Git

Communication

Tools

Git

Job description

We are seeking a highly technical Business Intelligence Engineer to join our growing BI team. Sitting at the crucial intersection of Data Engineering and Business Intelligence, you will be the technical cornerstone of our BI function. You will architect robust data solutions, automate data ingestion, quality and governance checks, build user-friendly dashboards, and promote a culture of data-driven decision-making across the organization. You will be a self-starter, taking the initiative to understand the whole data lifecycle, Trayport's products and business to transform complex data into actionable insights.

Key Responsibilities

• Architecture & Engineering: Design, build, and maintain a robust data warehouse. Oversee the ingestion of varied and complex datasets at scale.
• Schema Design: Collaborate closely with Data Engineers and BI Analysts to design, implement, and optimize data warehouse schemas.
• Dashboard & Visualisation Design: Architect, build, and maintain user-friendly dashboards and complex data visualisations that effectively surface critical business metrics and actionable insights for stakeholders.
• Data Quality & Automation: Champion data quality across the organization. Implement data automation pipelines to ensure accuracy, reliability, and timeliness of data.
• Data Governance & Management: Drive improvements in data governance, ensuring best-in-class data management practices are upheld across the business.
• Stakeholder Collaboration: Act as a strategic partner to the business. Communicate complex technical concepts clearly to all levels of the organization, including the C-suite, to promote data-driven decisions.
• Mentorship & Leadership: Mentor other BI Analysts, actively upskilling the team in technical competencies and best practices.

Required Skills & Qualifications

• Expert SQL: Master-level proficiency in writing, optimizing, and troubleshooting complex SQL queries.
• Programming Skills: Strong programming skills in Python (or a similar) for data manipulation and automation.
• Data Warehousing: Deep knowledge of modern database and data warehouse design principles and architectures.
• BI Tooling: Extensive experience with industry-leading BI tools such as Tableau or similar.
• Version Control: Solid experience using source control, such as Git, for managing code and collaborating with technical teams.
• Exceptional Communication: Outstanding verbal and written communication skills, with the proven ability to translate highly technical concepts for both technical and non-technical leadership.

Desirable Skills (Nice-to-Haves)

• Data Ingestion & ETL/ELT: Experience using ingestion tooling and orchestration platforms to build and manage automated data pipelines.
• Cloud Data Platforms: Hands-on experience with Snowflake (highly desirable) or similar cloud-based data warehouses (e.g., BigQuery, Redshift).
• Additional Programming: Knowledge of C# and experience working within a .NET environment.
• AI Tooling: Experiencing utilising AI-assisted development tools, such as Github Copilot, or integrating AI capabilities into data workflows with a clear understanding of their strengths and limitations.

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.

Our Culture

At Trayport, our people power our success. We are a place where talented people never stop learning, innovating and working together to make an impact! We offer you more than a job - we offer you the opportunity to work with, and learn from the most respected industry and thought leaders in the business. We're always pushing the boundaries, rapidly expanding our global presence across London, Vienna, Singapore, Bremen and North America. At Trayport, we understand that our people are crucial to our future. We strive to provide a challenging and inspirational atmosphere; employing intelligent, enthusiastic, adaptable individuals and giving them the freedom, training, and guidance to allow them to consistently achieve their potential. If you share our vision and are motivated to challenge the status quo - we want to hear from you!