BI Engineer

Salary: £44,000 - 84,000 per year

Requirements:

• Master-level proficiency in writing, optimizing, and troubleshooting complex SQL queries.
• Strong programming skills in Python or a similar language for data manipulation and automation.
• Deep knowledge of modern database and data warehouse design principles and architectures.
• Extensive experience with industry-leading BI tools such as Tableau or similar.
• Solid experience using source control, such as Git, for managing code and collaborating with technical teams.
• Outstanding verbal and written communication skills, with the proven ability to translate highly technical concepts for both technical and non-technical leadership.
• Experience using ingestion tooling and orchestration platforms to build and manage automated data pipelines.
• Hands-on experience with Snowflake or similar cloud-based data warehouses such as BigQuery or Redshift.
• Knowledge of C# and experience working within a .NET environment.
• Experience 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.

Responsibilities:

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

Technologies:

• AI
• Redshift
• Architect
• BigQuery
• Business Intelligence
• C#
• Cloud
• Copilot
• Data Warehouse
• Git
• GitHub
• Python
• SQL
• Snowflake
• Tableau
• ASP.NET
• ETL

More:

We are seeking a highly technical Business Intelligence Engineer to join our growing BI team at Trayport. Sitting at the 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. We are looking for a self-starter who can understand the whole data lifecycle, our products and business to transform complex data into actionable insights. 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. Location: London - 2 Gresham Street. Type: Full time.

last updated 36 week of 2026