Trayport

BIEngineer

London, United Kingdom FULL TIME Remote Friendly
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Mid+ candidates.

The Brief

“BI Engineer at Trayport. Skills: SQL, Python, Tableau, Data warehousing, Dashboard design, Data quality, Data automation. Design, build, and maintain a robust data warehouse. Oversee the ingestion of varied and complex datasets at scale”

What You'll Achieve.

Surface critical business metrics and actionable insights for stakeholders; Promote a culture of data-driven decision-making across the organization; Ensure accuracy, reliability, and timeliness of data; Uphold best-in-class data management practices across the business; Promote data-driven decisions

Industry & Context.

Problems you'll solve

Transform complex data into actionable insights

What They're Looking For.

Must Have

Expert SQL, Programming skills in Python (or a similar) 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

Nice to Have

Experience using ingestion tooling and orchestration platforms to build and manage automated data pipelines, Hands-on experience with Snowflake (highly desirable) or similar cloud-based data warehouses (e. g. , BigQuery, Redshift), Knowledge of C# and experience working within a. NET environment, 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

What You'll Do.

and maintain a robust data warehouse

Oversee the ingestion of varied and complex datasets at scale

and optimize data warehouse schemas

and maintain user-friendly dashboards and complex data visualisations

Implement data automation pipelines to ensure accuracy

and timeliness of data

Drive improvements in data governance

ensuring best-in-class data management practices are upheld across the business

How You'll Work.

Team & Collaboration

Collaborate closely with Data Engineers and BI Analysts to design, implement, and optimize data warehouse schemas; 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; Mentor other BI Analysts, actively upskilling the team in technical competencies and best practices; Collaborating with technical teams (using Git)

Communication Scope

Exceptional Communication; Outstanding verbal and written communication skills; Proven ability to translate highly technical concepts for both technical and non-technical leadership

Full 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 (o

Free ATS check

Applying for this BI Engineer role?

Most applicants get filtered before a human reads their resume. See if yours makes the cut.

How to Apply on Workday

  • Workday has a multi-step form — save your progress after every section.
  • "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
  • Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
  • Job requisition numbers are useful when following up with HR by email.

ANONYMOUS · UNFILTERED

What do employees actually say about Trayport?

Real rants from real employees. Read before you apply.

Read Company Rants →