Excel Vba Developer Jobs in Dallas, TX (NOW HIRING)

Overview

Who we are

Toyota does not offer support or sponsorship of job applicants for employment-based visas or any other work authorization for this role now or in the future. You must have the right to work in the United States and not require Toyota support or sponsorship for immigration-related employment (e.g., H-1B, O-1, E-3, H-1B1, TN, F-1 OPT, F-1 STEM OPT, F-1 CPT, TN, (job flexibility benefits) (also known as I-140 or Adjustment of Status portability), etc.) now or in the future. You should not apply for this role if you will require Toyota to assist with immigration support or sponsorship now or in the future.

Who we're looking for

Toyota'sTreasury department is looking for a passionate and highly motivatedSenior Treasury ALM & Analytics Analyst.

The primary responsibility of this role is to provide critical thought-leadership and experience on Interest Rate Risk (IRR), Liquidity Risk, Funds Transfer Pricing (FTP), Valuation, and Financial Forecasting utilizing measures such as Net Interest Income (NII), Earnings at Risk (EAR), Economic Value of Equity (EVE), and other Key Risk Indicators. The candidate will help maintain and automate financial analytical reports and dashboards with deep understanding of data and databases. In addition, the candidate is expected to have good problem-solving skills and understand complex processes.

Reporting to the Manager, Treasury Risk & Analytics, the person in this role will support the Treasury department's objective to manage balance sheet and liquidity strategy for the company.

What you'll be doing

• Develop complex financial Asset Liability Management (ALM) models in Empyrean/ Excel/SQL to be used as the primary source for TMCC/TFSB/Other Global SFC Asset/Liability Management program.

• Develop, maintain and grow automated processes leveraging Excel, VBA, Tableau, Power BI, python, Snowflake, .Net, C# etc.

• Advise finance subsidiaries on treasury management activities, practices and procedures ensuring compliance with policies and guidelines and review and provide input on funding forecasts and associated funding programs.

• Provide analytical support for management forums including Asset/Liability Committee (ALCO) decisions by conducting robust and comprehensive market and financial analysis to support strategy, proposals and market transactions.

• Conduct balance sheet analysis, analyze economic impact and build ALM strategies.

• Develop sophisticated interest rate and liquidity risk analyses (e.g. Value at Risk, Monte Carlo simulations) to be used for enhanced managerial reporting.

• Collaborate with Treasury Front Office to develop hedging and funding strategies.

• Collaborate with the Financial Planning and Analysis (FP&A), Credit Risk and Economic Capital teams to produce balance sheet and net interest income forecasts for annual budgeting, monthly forecasting, risk appetite and other scenarios.

What you bring

• BA or BS or higher in Economics, Finance, Mathematics, Engineering, other relevant fields or equivalent professional work experience.

• Basic accounting knowledge and understanding of the financial statements.

• Hands-on experience with SQL, VBA, Python and/or other programming skills.

• Strong technical, data, and analytical skills, including experience with database platforms such as SQL.

• Strong proficiency with building reports in MS Excel

• Experience leading presentations and sharing insights with a broad range of colleagues including an executive-level audience

Added bonus if you have

• MBA or an advanced degree in Finance, Financial Engineering, Quantitative Finance or related fields

• CFA charter-holder

• Practical experience with ALM analysis and/or financial modeling

• Hands-on experience configuring and using ALM tools (e.g., Empyrean, Bancware, QRM)

• Experience using reporting tools such as Tableau, Qlik Sense, Power BI

What We'll Bring

During your interview process, our team can fill you in on all the details of our industry-leading benefits and career development opportunities. A few highlights include:

• A work environment built on teamwork, flexibility and respect

• Professional growth and development programs to help advance your career, as well as tuition reimbursement

• Team Member Vehicle Purchase Discount

• Toyota Team Member Lease Vehicle Program (if applicable)

• Comprehensive health care and wellness plans for your entire family

• Toyota 401(k) Savings Plan featuring a company match, as well as an annual retirement contribution from Toyota regardless of whether you contribute

• Paid holidays and paid time off

• Referral services related to prenatal services, adoption, childcare, schools and more

• Tax Advantaged Accounts (Health Savings Account, Health Care FSA, Dependent Care FSA)

• Relocation assistance (if applicable)

Belonging at Toyota

Our success begins and ends with our people. We embrace all perspectives and value unique human experiences. Respect for all is our North Star.

Applicants for our positions are considered without regard to race, ethnicity, national origin, sex, sexual orientation, gender identity or expression, age, disability, religion, military or veteran status, or any other characteristics protected by law.

Have a question, need assistance with your application or do you require any special accommodations? Please send an email to talent.acquisition@toyota.com.