Architects and maintains data warehouses, designs schemas, automates data ingestion and quality checks, builds dashboards and visualizations, and advances data governance. Partners with stakeholders to translate complex data into actionable insights and supports organization-wide data-driven decisions. Mentors BI analysts and promotes technical best practices across the BI team.
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.
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.
Trayport London, England Office
7th Floor, 9 Appold Street, London, United Kingdom, EC2A 2AP
Similar Jobs
Fashion • Retail
Develop and maintain cloud data pipelines, ETL/ELT processes, warehouse schemas, semantic models, and integrations across internal and external data sources. Own pipeline reliability, monitoring, performance, and data quality while supporting governance, security, documentation, and DevOps practices. The role also supports BI analysts and managers, promotes consistent data practices, and helps improve team capabilities using Microsoft Fabric, Power BI, SQL, Python, and PySpark.
Top Skills:
AgileAPIsCi/CdData WarehousingDevOpsDimensional ModellingEltETLKimball MethodologyMedallion ArchitectureMicrosoft FabricPower BIPysparkPythonSemantic ModelsSource ControlSQLSsasT-Sql
Artificial Intelligence • Information Technology • Software • Consulting
Build and support scalable AWS data platforms, ETL/ELT pipelines, CI/CD automation, and Power BI reporting solutions. Responsibilities include data integration, modeling, dashboard and semantic model development, deployment automation, monitoring, validation, troubleshooting, and production support. The role requires strong Power BI, native AWS, SQL, data engineering, DevOps, Git, and data warehousing experience, with collaboration across technical, analytics, and business teams.
Top Skills:
Amazon AthenaAmazon CloudwatchAmazon EmrAmazon RdsAmazon RedshiftAmazon S3Apache AirflowSparkAWSAws CloudformationAws GlueAws IamAws LambdaAws Step FunctionsDatabricksDaxDbtDockerGitGitGitlabKafkaKinesisKubernetesMwaaPower BIPower QueryPythonSQLTerraform
Cloud • Information Technology • Cybersecurity
Develops business intelligence solutions across the full lifecycle, including requirements analysis, technical specifications, logical and physical data modeling, data warehouse and data mart design, configuration, testing, implementation, and handover to support. Works with analysts to translate BI requirements into scalable data stores and reporting solutions using the Microsoft SQL Server and BI stack.
Top Skills:
Data ModelingData WarehousingDaxMdxMicrosoft Sql ServerSql Server EngineSsasSsisSsrsT-Sql
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.
