Data Engineer, Finance

Engelhart; Greater London; On-site; GBP 90,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

25 days holiday

Robust benefits package

Job summary

Engelhart is seeking a Data Engineer in its London office to build and operate data pipelines connecting the data warehouse and CTRM platform with brokers, FCMs, and finance systems. You will automate Finance workflows with robust reconciliations, ingest external feeds (CSV/XML/SFTP), and implement strong data controls.

You will develop serverless ETL on AWS using IaC/CI-CD, apply Python-based processing, and collaborate with Finance and Technology stakeholders to evolve data flows.

Qualifications

• Strong Python development experience with testing practices.
• Hands-on AWS serverless ETL pipelines using Lambda and related services.
• Proficient SQL for transforming, validating and reconciling data.
• Experience with data ingestion from external files (CSV/XML/SFTP).
• Finance domain knowledge and data governance awareness.

Responsibilities

• Build, operate and maintain data pipelines between data warehouse, CTRM platform, brokers, and FCMs.
• Integrate data from the Finance stack (P&L, GL, AP/AR) and bank statements.
• Automate manual Finance processes with reliable, monitored jobs.
• Implement reconciliations and data controls; produce exception reports.
• Ingest external files/feeds via SFTP and common formats (CSV/XML).
• Investigate data and reconciliation issues; explain P&L or cash breaks to stakeholders.
• Develop and maintain serverless ETL on AWS with IaC and CI/CD.
• Work with Finance/Tech stakeholders to improve workflows and controls.

Skills

Python

Pandas/Polars

NumPy

pytest

SQL

Data pipelines

AWS serverless

Tools

AWS

Lambda

EventBridge

ECS/Fargate

DynamoDB

CloudWatch

S3

CDK

CI/CD

dbt

Airflow

SFTP

Job description

Engelhart was founded in 2013 by BTG Pactual Group as a commodities trading company. Our business model is “asset light” and highly diversified – giving us the ability to adapt effectively and nimbly to changing market conditions. We have assembled successful multidisciplinary teams, leveraging advanced fundamental analysis with deep quantitative and weather research capabilities. Our activities are underpinned by strong risk management practices and by powerful technology and operational excellence. We have exceptional teams with diverse global backgrounds and decades of experience, and are driven by a highly collaborative culture, across products and competencies.

In 2024, Engelhart acquired Trailstone, a global energy trading and technology company. The acquisition provides us with new expertise, analytics and proprietary technology which is being used to provide risk management and optimisation services to help maximise the value of our clients’ renewable power. The acquisition also expanded Engelhart’s capabilities into physical natural gas across North America, a critical fuel to support the energy transition.

Our talented and experienced individuals work together according to its four company values: Performance, Agility, Collaboration, Entrepreneurship.

About the Role

As a Data Engineer within Engelhart's Finance department, you will build and operate reliable data pipelines connecting the data warehouse and CTRM platform with brokers and Futures Commission Merchants (FCMs), margin and collateral processes, and the wider Finance technology stack. You will help automate manual Finance workflows into tested, monitored jobs, with robust reconciliations and controls that give stakeholders confidence in the completeness and accuracy of financial data.

This will be a full-time role based in our London office and owning the following responsibilities :

• Build, operate and maintain data pipelines between the data warehouse, CTRM platform, brokers and FCMs, margin and collateral processes, and Finance systems.
• Integrate data from the Finance stack, including P&L and F+, SAP General Ledger, Accounts Payable and Accounts Receivable, and bank statements.
• Automate manual Finance processes by developing reliable, tested and monitored jobs that can be operated and supported effectively.
• Implement reconciliations and data controls to identify missing or incomplete records, duplicates and breaks, and produce clear exception and break reporting.
• Ingest and process external files and feeds, including data received over SFTP and in formats such as CSV and XML.
• Investigate data and reconciliation issues, trace discrepancies through source systems and pipelines, and explain P&L or cash breaks to relevant Finance stakeholders.
• Develop and maintain serverless ETL solutions on AWS, using infrastructure as code and CI/CD practices to support consistent, controlled releases.
• Apply strong SQL and Python-based data processing to transform, validate and reconcile data accurately and efficiently.
• Work with Finance and technology stakeholders to understand requirements, improve existing workflows and deliver maintainable solutions with appropriate controls.
• Contribute to improving the reliability, observability and quality of Finance data flows as the business and its systems evolve.

About You

You will be a practical, analytical data engineer who combines strong software engineering skills with an understanding of Finance processes and controls. You can work with varied data sources, investigate discrepancies and explain the cause of a P&L or cash break clearly. You take ownership of the reliability of the jobs you build and look for opportunities to simplify and automate manual processes.

As a result, we believe the following experiences and skills are essential for application:

• Strong Python development skills, including experience with Pandas and/or Polars, NumPy, and automated testing with pytest.
• Hands-on experience building AWS serverless ETL pipelines, using services such as Lambda, EventBridge, ECS/Fargate, DynamoDB, CloudWatch and S3.
• Experience with AWS Cloud Development Kit (CDK), infrastructure as code and CI/CD pipelines.
• Experience building APIs using Python frameworks, preferably FastAPI.
• Strong SQL skills, including the ability to query, transform, validate and reconcile data.
• Experience ingesting external files and data feeds, including SFTP transfers and formats such as CSV and XML.
• Good understanding of Finance processes and data, with the analytical skills to investigate and clearly explain a P&L or cash break.
• A disciplined approach to testing, monitoring, reconciliation and control design, including checks for completeness, duplicates and exceptions.
• Strong problem-solving skills and attention to detail, with the ability to trace issues across systems and data pipelines.
• Clear communication skills and the ability to work effectively with Finance and technical stakeholders.

The following experience is not required , but highly desirable for this role:

• Experience using Kafka from Python.
• Experience integrating with SAP or treasury systems.
• Exposure to trading data, including positions and P&L.
• Familiarity with dbt and/or Airflow.

What we offer

• Competitive compensation and participation in Engelhart’s discretionary bonus plan.
• 25 days of annual holiday entitlement, excluding UK public holidays.
• Robust benefits package such as m edical, d ental, l ife insurance, generous pension contribution, and supplemental benefits partially subsidised by the Company.
• Eligibility to receive external and internal training in accordance with our Training & Development Policy.

We believe in inclusivity and are therefore dedicated to ensuring all employees – across gender identity, race, ethnicity, sexual orientation, religion, life experience, background and more – feel welcome and included in the company. We promote diversity because we believe it is essential to our ability to think holistically.