Data Engineer, Finance
Engelhart, a global commodities trading company founded in 2013 by BTG Pactual Group, is seeking a Data Engineer to join its Finance department in London. The company operates with an "asset light" and diversified business model, enabling adaptability to changing market conditions. Engelhart's multidisciplinary teams leverage advanced fundamental analysis, quantitative research, and weather research capabilities, underpinned by strong risk management practices and operational excellence. In 2024, Engelhart expanded its capabilities by acquiring Trailstone, a global energy trading and technology company, enhancing its expertise in renewable energy services and physical natural gas across North America.
As a Data Engineer within Engelhart's Finance department, you will be responsible for building and maintaining reliable data pipelines that connect the data warehouse and CTRM platform with brokers, Futures Commission Merchants (FCMs), margin and collateral processes, and the broader Finance technology stack. Your role will involve automating manual Finance workflows into tested and monitored jobs, implementing reconciliations and data controls to ensure data completeness and accuracy, and integrating data from various Finance systems, including P&L and F+, SAP General Ledger, Accounts Payable and Receivable, and bank statements. Additionally, you will handle the ingestion and processing of external files and feeds, investigate data and reconciliation issues, and develop serverless ETL solutions on AWS using infrastructure as code and CI/CD practices.
The ideal candidate will possess strong Python development skills, including experience with Pandas and/or Polars, NumPy, and automated testing with pytest. Hands-on experience in building AWS serverless ETL pipelines using services such as Lambda, EventBridge, ECS/Fargate, DynamoDB, CloudWatch, and S3 is essential. Proficiency with AWS Cloud Development Kit (CDK), infrastructure as code, and CI/CD pipelines is required. Experience in building APIs using Python frameworks, preferably FastAPI, is advantageous. Strong SQL skills, including the ability to query, transform, validate, and reconcile data, are necessary. A good understanding of Finance processes and data, with analytical skills to investigate and explain P&L or cash breaks, is important. A disciplined approach to testing, monitoring, reconciliation, and control design, along with strong problem-solving skills and attention to detail, is expected. Clear communication skills and the ability to work effectively with Finance and technical stakeholders are essential.
Engelhart offers competitive compensation and participation in its discretionary bonus plan. Employees are entitled to 25 days of annual holiday, excluding UK public holidays. The company provides a robust benefits package, including medical, dental, and life insurance, generous pension contributions, and supplemental benefits partially subsidized by the company. Employees are eligible for external and internal training in accordance with Engelhart's Training & Development Policy.
Engelhart fosters a collaborative culture across products and competencies, driven by its core values of Performance, Agility, Collaboration, and Entrepreneurship. The company promotes inclusivity and diversity, ensuring all employees feel welcome and included. Engelhart's diverse global teams work together to adapt effectively to changing market conditions, leveraging advanced analysis and research capabilities to drive success.