Internship Excel Vba Programmer Jobs in Virginia

At Freddie Mac, our mission of Making Home Possible is what motivates us, and it's at the core of everything we do. Since our charter in 1970, we have made home possible for more than 90 million families across the country. Join an organization where your work contributes to a greater purpose.
Position Overview:
Freddie Mac's Investments & Capital Markets Division is seeking a Quantitative Analytics Senior to develop, implement, monitor, and execute quantitative models that support counterparty credit risk management, fixed-income derivatives valuation, and related business and risk management decisions.
The candidate should be self-motivated, has a strong quantitative and computational background, and communicates effectively with technical and business stakeholders. As part of the Models & Analytics team, this role will primarily support Freddie Mac's Counterparty Credit Risk Management and Asset-Liability Management functions, with responsibilities spanning model development, implementation, monitoring, data processes, documentation, and business user support.
Our Impact:
This role focuses on the design, development, implementation, and monitoring of quantitative models and analytics that support counterparty credit risk, exposure measurement, derivatives valuation, and related risk management activities.
The models and analytics developed by the team provide key inputs into counterparty credit risk management, portfolio management, business reporting, and risk-informed decision-making across the division.
Your Impact:
• Develop, implement, and maintain quantitative models primarily for counterparty credit risk measurement, with additional coverage of interest rates, derivatives valuation, and valuation components related to mortgage products.
• Implement models and analytics using programming languages and tools such as MATLAB, Python, SQL, Java, and Excel/VBA.
• Manage data processes that support model development, implementation, monitoring, and reporting, including data sourcing, validation, reconciliation, quality controls, and issue resolution.
• Analyze large financial datasets, including market, trade, counterparty, collateral, margin, and reference data used in risk analytics.
• Design and execute model monitoring plans, produce performance monitoring reports, and respond to questions from business users, model validators, and other stakeholders.
• Prepare detailed model documentation and technical documentation for internally developed and vendor models in accordance with model risk standards.
• Support business users by monitoring model use and performance, producing business-line reports, and explaining model analytics in clear business terms.
• Collaborate with Counterparty Credit Risk Management, model governance, model validation, technology, and other stakeholders to support model implementation, controls, and ongoing use.
• Develop practical solutions to complex business problems and support the implementation and validation of business strategies.
• Proactively partner with teammates and business users to develop practical analytical approaches and advance new ideas.
Qualifications:

• Doctorate or Master's degree + 3 years relevant experience in quantitative finance, economics, statistics, mathematics, or a related quantitative field.
• Coursework or work experience applying finance, statistics, mathematics, data science, and computer programming techniques to quantitative modeling problems in the financial industry.
• Relevant coursework may include statistics, mathematical programming, optimization, machine learning and AI, computational methods, design and analysis of algorithms, derivatives, and Monte Carlo methods.
• Coursework or work experience developing models, analytics, and algorithms using programming languages and tools such as MATLAB, Python, SQL, Java, and Excel/VBA.
• Experience sourcing, analyzing, validating, and reconciling large financial datasets used in model development, execution, monitoring, and risk reporting.
• Familiarity with counterparty credit risk concepts, including initial margin, variation margin, PD, LGD, EAD, exposure measurement, and related regulatory requirements.
• Familiarity with regression models, stochastic process modeling, and Monte Carlo simulation.
• Experience with financial derivatives, valuation, risk analytics, and Greeks.

Keys to Success in this Role:

• Strong quantitative, technical, research, and programming skills.
• Strong analytical skills with attention to detail, data quality, and model controls.
• Self-motivated and able to own projects, manage priorities, and work efficiently under tight deadlines.
• Ability to understand complex business requirements, define relevant analytical problems, and translate model results into business terms.
• Strong verbal and written communication skills, with the ability to collaborate effectively across technical, business, and governance teams.

Current Freddie Mac employees please apply through the internal career site.
We consider all applicants for all positions without regard to gender, race, color, religion, national origin, age, marital status, veteran status, sexual orientation, gender identity/expression, physical and mental disability, pregnancy, ethnicity, genetic information or any other protected categories under applicable federal, state or local laws. We will ensure that individuals are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
A safe and secure environment is critical to Freddie Mac's business. This includes employee commitment to our acceptable use policy, applying a vigilance-first approach to work, supporting regulatory mandates, and using best practices to protect Freddie Mac from potential threats and risk. Employees exercise this responsibility by executing against policies and procedures and adhering to privacy & security obligations as required via training programs.
CA Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com and register with our referral code: MAC.
Time-type:Full time
FLSA Status:Exempt
Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.
This position has an annualized market-based salary range of $126,000 - $190,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.