Financial Modeler

btd grupo; Madrid; Hybrid; EUR 50,000 - 65,000; Full time

Job summary

BTD is seeking a skilled Financial Modeling Analyst in Madrid to build and validate complex project-finance models. You will prepare detailed projections, structure debt schedules, and analyze financial viability to guide investment decisions.

The role requires 3+ years in financial modeling, strong Excel (VBA) skills, and the ability to communicate with banks and stakeholders. English is advantageous, and the team values precision and teamwork.

Qualifications

• Bachelor’s degree in Business Administration, Industrial Engineering, Mathematics, or a related field.
• Minimum of 3 years of experience in financial modeling and Project Finance.
• Advanced Excel skills (including VBA) and experience with complex financial models.
• Knowledge of financial instruments, Project Finance contracts, and variables such as CAPEX, OPEX, and inflation.
• Experience in model validation and financial reporting.
• English proficiency is desirable.

Responsibilities

• Develop comprehensive financial models under Project Finance structures.
• Prepare financial projections (revenues, costs, CAPEX, OPEX, etc.).
• Structure debt drawdown and repayment schedules.
• Calculate financial ratios and returns.
• Conduct sensitivity and scenario analysis.
• Monitor the evolution of project financing.
• Support communication with financial institutions and stakeholders.
• Analyze the financial viability of projects.
• Support divestment processes through financial and economic analysis.

Skills

Advanced Excel (incl. VBA)

Analytical skills

Attention to detail

Communication skills

English proficiency

Education

Bachelor's degree in Business Administration / Industrial Engineering / Mathematics

Tools

Excel

VBA

Job description

• Develop comprehensive financial models under Project Finance structures.
• Prepare financial projections (revenues, costs, CAPEX, OPEX, etc.).
• Structure debt (drawdown and repayment schedules).
• Calculate financial ratios and returns.
• Conduct sensitivity and scenario analysis.
• Monitor the evolution of project financing.
• Support communication with financial institutions and stakeholders.
• Analyze the financial viability of projects.
• Support divestment processes through financial and economic analysis.

Requirements

• Bachelor’s degree in Business Administration, Industrial Engineering, Mathematics, or a related field.
• Minimum of 3 years of experience in financial modeling and Project Finance.
• Advanced Excel skills (including VBA) and experience with complex financial models.
• Knowledge of financial instruments, Project Finance contracts, and variables such as CAPEX, OPEX, and inflation.
• Experience in model validation and financial reporting.
• English proficiency is desirable.
• Analytical, organized profile with strong attention to detail and good communication skills.

At BTD, we value the diversity and uniqueness of each person. We strive to create an inclusive and respectful work environment where everyone can fully develop, regardless of their gender, age, disability, sexual orientation, gender identity or expression, religion, ethnic origin, marital status, or any other personal or social circumstance. We firmly believe that diversity enriches and strengthens us as a team, and we work every day to ensure equal opportunities in all our processes. Join our team and help build a more inclusive future!