Data Engineer (SQL Server)

Our purpose is to provide clients with access to global financial and commodities markets, improving price discovery, liquidity, and distribution of data, through responsible and innovative solutions. Through our people and technology, we connect clients to superior liquidity and data solutions. The Group is home to a stable of premium brands. Collectively, TP ICAP is the largest interdealer broker in the world by revenue, the number one Energy & Commodities broker in the world, the world's leading provider of OTC data, and an award winning all-to-all trading platform. We work as one to achieve our vision of being the world's most trusted, innovative, liquidity and data solutions specialist. Role Overview Effective Market Abuse Surveillance is highly dependent on data of multiple types and from many different sources. Trade Surveillance requires complete Trade and Pre-Trade transactional data, Instrument and Client Reference Data and Market Data. This role will play a critical role in ensuring the reliability, scalability, and compliance of data pipelines that support surveillance systems across communications and trading activities, covering the above structured and unstructured data. The role bridges engineering and operations, enabling robust data ingestion, transformation, and monitoring to meet regulatory and internal compliance requirements. The Data Ops Engineer will play a critical role in collaborating with upstream teams to ensure data completeness, accuracy, and timeliness is as expected and that any data completeness or quality issues are visible. The role will also work on other Surveillance data initiatives such as persisting Surveillance Alerts in the firm's data lake for analytics purposes. Role Responsibilities Design, build, maintain and optimise end-to-end data pipelines and workflows between the source data points and target destinations, working with the wider Surveillance Technology team to prioritise automation, scalability and strategy at the heart of the design. Implement automated data completeness and quality checks, validation rules, and reconciliation processes to ensure accuracy, completeness, and timeliness of the data ingested and to make visible any data that is not processed. Identify Critical Data Elements and implement failover and recovery strategies for the respective Data Flows. Build AWS infrastructure using Terraform or CDK Write unit, integration, and infrastructure tests Monitor, investigate and resolve data anomalies through collaboration with, Business Analysts, Developers, and Testers across functions and verticals. Implement data management and governance frameworks to ensure data is ingested and loaded per the requirements of the consuming platform; Partnering with the Data Strategy and Data Infrastructure team to ensure Data Lineage, auditability and retention policies are enforced across all necessary pipelines. Ensuring that Data consumed and processed is compliance with regulatory, legal, and security protocols. Partnering closely with stakeholders and subject matter experts such as the Cloud Infrastructure team to optimise performance and costs. Experience / Competences Essential Strong experience ETL/ELT data pipeline builds from design, to implementation, to maintenance in relation to financial market messaging platforms, and trade & order systems. Solid understanding of CI/CD pipelines, ideally with a background in software engineering, product management or data analytics. Strong proficiency in Python or Java, SQL, and data pipeline frameworks (e.g., Airflow, dbt, Spark), with solid experience with the AWS ecosystem. Bachelor's degree in Computer Science, Data Science, Engineering, or related field. Previous experience in Data Ops and Data Engineering. Strong experience with Agile software delivery. Desired Experience with market data ingestion, metadata extraction, and event-driven architectures. Experience with some of EKS, Lambda, EventBridge, Step Functions, S3, DynamoDB, AWS Glue, Snowflake, Terraform and Transfer Family. Knowledge of streaming technologies (Kafka, Kinesis) and API integrations, and hands-on experience with monitoring tools (e.g. Bloomberg, ICE, Symphony, Teams Chat, etc. Familiarity with security best practices, IAM, and VPN configuration. Experience with regulatory compliance and data security in financial services. Knowledge of financial markets and trading platforms. Strong understanding of modern foundation models, including Claude (Sonnet / Opus), OpenAI GPT models, and other leading LLMs. Practical experience building applications using agentic or multi-agent workflows (e.g., tool use, planning, orchestration, retrieval, reasoning patterns). Band & Level - Professional, 5 Not The Perfect Fit? Our dedicated Talent Acquisition team is here to assist you in recognising how your unique skills and abilities can be a valuable contribution. That's why we're building a culture where everyone plays a part in making people feel welcome, ready and willing to contribute. TP ICAP Accord - our Employee Network - is a central to this. As well as representing specific groups, TP ICAP Accord helps increase awareness, collaboration, shares best practice, and holds our firm to account for driving continuous cultural improvement.