A lawyer who advises the court or the government

Previamente a su entrada a la Universidad de Texas fue Abogado Consejero en la Oficina Jurídica del Departamento de Estado del Gobierno estadounidense. fride.org
Before joining the Texas Faculty in 1993, he was an Attorney-Adviser in the Office of the Legal Adviser at the U.S. State Department. fride.org

--------------------------------------------------
Note added at 15 hrs (2022-08-01 11:40:42 GMT)
--------------------------------------------------

Abogado-consejero, with a dash, not a comma, is definitely not an in-house lawyer but an external advisor providing legal advice, as in the following example:

También fue profesor invitado en la Academia de Derecho Internacional de La Haya y abogado-consejero ante la Corte de Derecho Internacional

--------------------------------------------------
Note added at 15 hrs (2022-08-01 11:42:43 GMT)
--------------------------------------------------

Abogado-consejero, with a dash, not a comma, is definitely not an in-house lawyer but an external advisor providing legal advice, as in the following example:

También fue profesor invitado en la Academia de Derecho Internacional de La Haya y abogado-consejero ante la Corte de Derecho Internacional

See also:
What Is an Attorney Advisor?
Attorney advisors work closely with government officials to help them understand pending laws that will affect their agencies or for which they hold responsibility for implementation and enforcement. If Congress passes a cybersecurity law, the U.S. Department of Homeland Security, which is responsible for cybersecurity, will counsel with attorney advisors to determine the regulations needed to enact the intent of the law. When necessary, attorney advisors recommend ways to alter agencies’ current policies. They also consider the policies needed to ensure that the agencies’ operations and practices adhere to the new legislation. They may also give advice on issues relevant to the agencies. For instance, an attorney advisor working for the Office of Tribal Justice may discuss legal ways to protect Native American rights.

Attorney advisors also represent their agencies before state and federal regulatory bodies such as the U.S. Equal Employment Opportunity Commission and federal and appellate courts. Additionally, they may represent their agencies in meetings or on task forces with domestic and international government officials, deliberating on the legal aspects of subjects like arms control or information sharing in the intelligence community.

Attorney advisors also assist in formulating and putting into practice U.S. foreign policies. These legal professionals also participate in U.S. diplomacy. When government agencies, such as the U.S. Department of State, handle international issues, attorney advisors help them make decisions within an international legal framework that best promotes U.S. interests. These issues may relate to the environment, economics, and international business, among other topics. The attorney advisor’s work can involve advising agencies about the technical language of international agreements and helping officials to consider specific legal provisions. Responsibilities also may require participating in diplomatic conferences, representing the U.S. in meetings with international organizations, and assisting in the representation of the U.S. in United Nations sessions.



--------------------------------------------------
Note added at 15 hrs (2022-08-01 11:59:55 GMT)
--------------------------------------------------

and it looks as though "advisor" would be better than "adviser"

There is no difference between adviser and advisor besides spelling, and both are acceptable for someone who gives advice. Some people, though, feel that advisor is more formal. Advisor tends to be used for people having an official position—for example, an advisor to the president.

'Advisor' vs. 'Adviser': Who Will Win? - Merriam-Webster