Trading Portfolio Analyst

3Degrees•Portland, ME

1d•$91,000 - $104,000•Hybrid

About The Position

Every day, we work together for what matters – bold, swift, and equitable climate action. ABOUT THE ROLE At 3Degrees, we are committed to advancing a decarbonized future through bold, swift, and equitable climate action. We do this work by originating, marketing, selling, and trading environmental commodities. As a member of our Research and Analysis team within the Environmental Markets (EM) division, you’ll apply your analytical and strategic expertise to conduct portfolio analysis, develop reporting tools and processes used by multiple stakeholders, and enhance our informational capabilities. As a Trading Portfolio Analyst, you'll play a critical role in shaping our approach to the environmental commodities market while driving real-world impact. You will apply strong quantitative and communication skills to the analysis of our portfolios, positions, and commodity pricing in order to deliver insights that sharpen our trading edge. Your responsibilities will include developing internal reporting and reconciliation tools, as well as translating complex datasets into actionable insights for both portfolio managers and non-technical stakeholders. In a word, you will help shape what we know and how we know it. Your expertise will go beyond supporting the trading desk. You’ll challenge conventional thinking, identify strategic gaps, and introduce innovative solutions to improve cross-functional performance. This is a full-time opportunity within the 3Degrees Environmental Markets division, based in Portland, ME. Exceptional candidates within commuting distance to our office hubs in San Francisco, CA; Portland, Oregon; or New York, NY will also be considered. Please Note: 3Degrees does not provide sponsorship or work authorization assistance; therefore, pre-existing right-to-work status is a prerequisite to be considered for this position.

Requirements

2+ years of experience in quantitative data analysis
Demonstrated financial or accounting literacy, with an understanding of reconciliations, trial balances, or fund accounting logic (e.g., valuation stacks, balance checks, and dataset matching)
Advanced proficiency in Excel, with proven experience building, maintaining, and troubleshooting complex downstream workbooks and reporting templates
Functional proficiency in Python for data manipulation, process automation, and general scripting
Familiarity with Power BI and DAX (or strong proficiency in Tableau accompanied by a willingness to transition to Power BI)
Familiarity or strong interest in leveraging AI tools (LLMs) and low-code platforms (e.g., Copilot Studio, Glean, RPA) to automate routine workflows and streamline reporting processes. Knowledge of Databricks or Microsoft Fabric is a plus
Meticulous attention to detail, with a strong ability to detect data anomalies, perform sensitivity analysis, and ensure absolute reporting accuracy
Excellent communication skills, with a proven ability to translate complex, dense data into clear, digestible formats for non-technical stakeholders and leadership
Highly collaborative, stakeholder-first approach (“How can I help?”) with the ability to manage multiple projects simultaneously and process feedback quickly
Ability and willingness to work in-person at our office in Portland, Maine
BA/BS degree in economics, finance, statistics, computer science, or a related quantitative field preferred

Nice To Haves

Knowledge of Databricks or Microsoft Fabric is a plus
Strong proficiency in Tableau accompanied by a willingness to transition to Power BI

Responsibilities

Manage, execute, and deliver weekly portfolio valuation reports and performance updates for key front-office stakeholders, portfolio managers, and executive leadership
Maintain, troubleshoot, and support critical downstream Excel workbooks used by Trading Associates and Portfolio Managers to track positions and market values
Design, maintain, and execute financial reconciliations (e.g., trial balances, valuation stacks, exchange-to-system position matching) to ensure accurate reporting across tools
Act as a responsive communication bridge between non-technical stakeholders, traders, and risk management to explain valuation movements and resolve data questions
Audit existing workflows to identify manual steps, streamline processes, and eliminate redundant clicks across workbooks
Identify, pilot, and deploy low-code AI interventions and agentic tools (e.g., Copilot Studio, Glean, RPA) to automate routine tasks like report generation and distribution
Utilize Python and modern data platforms (such as Power BI, Databricks, or Microsoft Fabric) to transition manual reports into scalable, automated solutions
Support the development and refinement of proprietary models using Python, Excel, and Power BI to analyze portfolio positioning and performance
Translate complex quantitative outputs and datasets into clear, actionable reports for trading decision-makers
Bandwidth permitting, partner with internal teams to analyze risks and opportunities across North American REC and clean fuel markets (e.g., LCFS, CCA)