Data Engineer, Finance

About Us 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 b