Castleton Commodities International
Associate, Treasury Data Analyst
Castleton Commodities International, Stamford, Connecticut, United States, 06925
The Treasury Data Analyst will report to the Treasurer and is an integral part of the treasury team. The primary responsibilities of this position include daily cash flow reporting and forecasting, reporting and analysis associated with the company’s primary credit facilities, automation of data and reports sourced from multiple trade and accounting systems, and engagement in treasury-related projects for Castleton Commodities International entities.
Responsibilities:
Prepare daily cash flow reports and aggregate cash flow forecasts for multiple corporate entities in multiple currencies. Coordinate the collection of information from various functions and company data sets to ensure the cash forecast is highly accurate. Requires engagement with trade settlements, cash operations, credit, futures clearing and business development teams.Develop and implement custom solutions to enhance and improve reporting and data analysis for Treasury management, business performance reviews, annual budgeting and associated financial planning.Coordinate and maintain data sets used to support financial reporting requirements, which can include foreign exchange exposure, working capital usage, counterparty exposures, and changes in cash and liquidity positions.Prepare monthly borrowing base reports required under the company’s lines of credit, including detailed schedules and analysis of inventory, accounts receivable, mark-to-market gains, and affiliate transactions. Enhance the reporting process to improve timeliness and reconciliation of associated financial data. Support additional diligence and audit requests in connection with monthly treasury reports.Provide timely and accurate analysis and reporting for variety of daily, monthly, and quarterly reporting packages.Work closely with corporate accounting to ensure that treasury-related activities are recorded in an accurate and timely manner.Analyze FX cash positions and forecasting to ensure FX cash needs are met while minimizing exposure due to currency market fluctuations.Support bank account management and detailed reporting of cash positions.Qualifications:
Bachelor’s Degree in Accounting, Finance, Economics, Management Information Systems, or a related field of study.1-5 years in a Data Analyst, Data Management, or Treasury related role preferred.Demonstrated capability in database management, SQL and VBA coding; familiarity with Alteryx and Power Automate tools preferred.Proficiency in MS Excel, Word, and PowerPoint required.Strong analytical and communication skills, including verbal and written skills. Highly organized and ability to work independently.Energetic and determined attitude.Detail-oriented.Problem-solving skills.Ability to simultaneously manage multiple activities to completion.General knowledge of corporate finance and accounting.Employee Programs & Benefits:
CCI offers competitive benefits and programs to support our employees, their families and local communities. These include:Competitive comprehensive medical, dental, retirement and life insurance benefits.Employee assistance & wellness programs.Parental and family leave policies.CCI in the Community: Each office has a Charity Committee and as a part of this program employees are allocated 2 days annually to volunteer at the selected charities.Charitable contribution match program.Tuition assistance & reimbursement.Quarterly Innovation & Collaboration Awards.Employee discount program, including access to fitness facilities.Competitive paid time off.Continued learning opportunities.Visit
https://www.cci.com/careers/life-at-cci/#
to learn more!
#J-18808-Ljbffr
Responsibilities:
Prepare daily cash flow reports and aggregate cash flow forecasts for multiple corporate entities in multiple currencies. Coordinate the collection of information from various functions and company data sets to ensure the cash forecast is highly accurate. Requires engagement with trade settlements, cash operations, credit, futures clearing and business development teams.Develop and implement custom solutions to enhance and improve reporting and data analysis for Treasury management, business performance reviews, annual budgeting and associated financial planning.Coordinate and maintain data sets used to support financial reporting requirements, which can include foreign exchange exposure, working capital usage, counterparty exposures, and changes in cash and liquidity positions.Prepare monthly borrowing base reports required under the company’s lines of credit, including detailed schedules and analysis of inventory, accounts receivable, mark-to-market gains, and affiliate transactions. Enhance the reporting process to improve timeliness and reconciliation of associated financial data. Support additional diligence and audit requests in connection with monthly treasury reports.Provide timely and accurate analysis and reporting for variety of daily, monthly, and quarterly reporting packages.Work closely with corporate accounting to ensure that treasury-related activities are recorded in an accurate and timely manner.Analyze FX cash positions and forecasting to ensure FX cash needs are met while minimizing exposure due to currency market fluctuations.Support bank account management and detailed reporting of cash positions.Qualifications:
Bachelor’s Degree in Accounting, Finance, Economics, Management Information Systems, or a related field of study.1-5 years in a Data Analyst, Data Management, or Treasury related role preferred.Demonstrated capability in database management, SQL and VBA coding; familiarity with Alteryx and Power Automate tools preferred.Proficiency in MS Excel, Word, and PowerPoint required.Strong analytical and communication skills, including verbal and written skills. Highly organized and ability to work independently.Energetic and determined attitude.Detail-oriented.Problem-solving skills.Ability to simultaneously manage multiple activities to completion.General knowledge of corporate finance and accounting.Employee Programs & Benefits:
CCI offers competitive benefits and programs to support our employees, their families and local communities. These include:Competitive comprehensive medical, dental, retirement and life insurance benefits.Employee assistance & wellness programs.Parental and family leave policies.CCI in the Community: Each office has a Charity Committee and as a part of this program employees are allocated 2 days annually to volunteer at the selected charities.Charitable contribution match program.Tuition assistance & reimbursement.Quarterly Innovation & Collaboration Awards.Employee discount program, including access to fitness facilities.Competitive paid time off.Continued learning opportunities.Visit
https://www.cci.com/careers/life-at-cci/#
to learn more!
#J-18808-Ljbffr