IT Data

Role Overview We are looking for a Junior Analyst based in Mexico City. The role is suitable for early-career professionals who enjoy working with data, investigating problems, learning new technologies, and collaborating with technical and business teams in an international environment. Position Title: Information Technology Support Analyst Business area: IT Finance Function: Technology

Location:
Mexico City Position Type: Full-time Schedule: Hybrid Business Overview Hartree Partners, LP is a leading global merchant commodities firm facilitating the flow of energy, metals, agriculture, and environmental products across the full commodity supply chain, connecting producers and consumers. Hartree was founded in 1997, is jointly owned by senior management and funds managed by Oaktree Capital Management, LP, and employs over 5,000 individuals worldwide. Hartree is uniquely positioned to capitalize on opportunities across a diversified set of commodities businesses with focus on trading, asset investments, risk management and advisory services. These businesses are supported by a centralized operating model including risk, technology, operations, finance, HR, legal and compliance, ensuring strong governance and effective execution. As a growing and evolving firm, Hartree continues to expand its commercial footprint, invest in new assets, and build new capabilities to meet emerging market opportunities. This growth mindset shapes our culture and attracts people who want to innovate, build, and drive meaningful impact. Key Accountabilities:
• Analyze and reconcile data across reports, systems, and datasets to identify discrepancies and support business questions.
• Use SQL and Excel to investigate issues, validate results, and provide clear findings to stakeholders.
• Perform structured root cause analysis (RCA), identifying underlying causes, contributing factors, and appropriate follow-up actions.
• Support incident and issue investigation, tracking items through to resolution and communicating progress when needed.
• Create and maintain clear documentation for requirements, processes, analysis, findings, and operational procedures.
• Collaborate with business and technology teams while continuously learning new tools, systems, and processes. Skills and

Experience:
• Strong English communication skills, with the ability to participate in meetings and write clear emails and documentation; B1/B2 Level.
• 2-4 years of experience in similar roles.
• Intermediate SQL knowledge, including SELECT, WHERE, JOIN, GROUP BY, aggregate functions, CASE WHEN, subqueries, and CTEs.
• Intermediate Excel skills, including filters, sorting, XLOOKUP/VLOOKUP, SUMIF/SUMIFS, COUNTIF, PivotTables, basic formulas, and dataset reconciliation.
• Data analysis skills with the ability to investigate mismatches, identify discrepancies, determine likely causes, and document conclusions clearly.
• Root Cause Analysis (RCA) skills with a structured approach to identifying underlying causes rather than only addressing symptoms.
• Python: Basic understanding of Python syntax, variables, data types, conditions, loops, scripts and functions.
• AI Tools: Familiarity with tools such as Claude, ChatGPT, and Copilot is preferred. Candidates should be comfortable using AI tools to troubleshoot errors, structure an investigation, summarize documentation, and learn new concepts. Understand the importance of validating AI-generated answers and results rather than relying on them without verification. Additional Valuable

Skills:
• Basic accounting or finance knowledge is preferred.
• Basic Python knowledge is preferred, including syntax, variables, data types, conditional statements, loops, scripts, and functions.
• Familiarity with AI tools such as Claude, ChatGPT, and Copilot is preferred, including using them to troubleshoot errors, structure investigations, summarize documentation, and learn new concepts. Ability to validate AI-generated answers and results rather than relying on them without verification.
• Able to clearly document requirements, processes, analysis, findings, and follow-up actions. Soft

Skills:
• Works well in a team and communicates clearly when blocked.
• Comfortable asking questions, while trying to investigate independently first.
• Can learn unfamiliar systems, tools, and business processes.
• Shows curiosity about why something happened rather than only completing assigned steps.
• Can research and learn independently using documentation, search tools, and AI assistants.
• Takes ownership of problems and follows them through to resolution.
• Can communicate technical findings clearly to non-technical colleagues.
• Is organized and documents work consistently.
• Is open to feedback and learn from mistakes. For candidates, selection should not be based only on who writes the best SQL. The strongest profile combines English communication, analytical reasoning, learning ability, teamwork, and a proactive attitude. SQL, accounting knowledge, and internal systems can be developed more easily than curiosity, ownership, and communication skills. Our Offer: We provide a fast-paced, stimulating and truly global environment, which will stretch your abilities and channel your talents. We also offer competitive salary and benefits combined with outstanding career development opportunities in one of the global leaders of commodity trading. Our Values: Integrity, Collaboration, Entrepreneurship Our values define who we are. They are the fundamental beliefs that determine our actions and guide our behavior. They influence the way we communicate and collaborate, and define the way we engage with our clients, partners, and communities. Our Commitment: We are committed to maintaining a work environment where all employees are treated with dignity and respect. We provide equal opportunities to all qualified applicants without regard to race, colour, sex, gender, age, religion, ethnic or national origin, marital or civil partner status, physical or mental disability, military or veteran status, sexual orientation, gender identity or expression, genetic information or any other characteristic protected by applicable law. We are willing to make any reasonable adjustments throughout our recruitment process. To apply you must have the right to work for the provided location.