Data Engineer, Finance

Job description

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 in…