Treasury Analyst

Spectraforce Technologies
United States, Texas, Richardson
Feb 03, 2025
Position Title: Treasury Analyst Duration: 1 Year Working hours: Monday to Friday: about 40 hours/week - flexible hours Working Location: Richardson, TX (Hybrid - In Office 2/3 days a week typically) Pre-Screening Questions: Can you explain how you would use a Pivot Table to analyze large datasets and summarize key insights? How would you use VLOOKUP or an alternative function (such as INDEX/MATCH or XLOOKUP) to retrieve specific data from another sheet? Please give specific examples of situations where you have used Excel and what formulas you have used? Job Responsibilities: Morning - running cash position (looking at bank accounting and reviewing money on hand). Update forecasting. Investing or borrowing decision-making/proposal. Adjusting system - reviewing/reclassifying transactions. Afternoon - Run cash position again ensuring all updates went through. Investing and withdrawing. Back-up for corporate projects. Cash funding needs. Weekly Team meetings with the Global Team. Ability to calculate intermediate figures such as percentages, discounts, and/or commissions. Intermediate skills with Microsoft Office Suites (good with Excel and numbers overall). Conducts basic financial analysis. Conduct financial/business analysis including the preparation of reports. Ability to comprehend, analyze, and interpret documents. Ability to solve problems involving several options in situations. Responsible for the treasury activities of the organization, ensuring that financial transactions, policies, and procedures meet corporate needs and/or objectives. Executes authorized electronic payments including wire transfers, ACH, and tax payments. Assists Treasury Manager in implementing/maintaining banking services to improve the efficiency of cash collection and disbursement. Acts as liaison between bank and users of various banking products to ensure and maintain optimal service. Researches and resolves bank and cash-related inquiries and variances. Prepares daily, monthly, and quarterly treasury reports. Supports Sr Treasury Manager in all treasury matters as needed. Other duties may be assigned. No formal supervisory responsibilities in this position. Decisions are made with an understanding of procedures and company policies to achieve set results and deadlines. Responsible for setting own project deadlines. Errors in judgment may cause short-term impacts on co-workers and supervisors. Years of Experience needed: 0 to 4 Years preferred Level of Education: BA in a Finance-related area. Systems/Software Proficiencies: Excel Proficient (embedded formulas, pivot tables, vlookups, etc.) Top Must have Skills: Excel Experience (embedded formulas, pivot tables, vlookups, etc.). Good with Numbers. Good working with others in a Team (high collaboration). Computer proficient, quick to learn new systems. Requires intermediate analytical and quantitative skills. Knowledge of cash management principles, bank products, and bank services. Excellent written and verbal communication skills. Strong organizational and analytical skills. Ability to provide efficient, timely, reliable, and courteous service to customers. Ability to effectively present information. Ability to effectively respond to complex inquiries or complaints from clients, co-workers, supervisors, and/or management. Requires knowledge of financial terms and principles. Certifications/Licenses: CTP (Certified Treasury Professional) is nice to have but not required.