There are actually two types of sponsors to take into account here: the sacramental sponsor for Baptism (i.e. godparent) and/or Confirmation and the RCIA sponsor.
The sacramental sponsor for someone coming through RCIA has the same canonical requirements and responsibilities as a sponsor for a baby being baptized or a child being confirmed. In most instances the sacramental sponsor is present when the sacraments are received, i.e. at the East Vigil if it’s an RCIA participant. However if the person chosen to be the sacramental sponsor cannot be present when the sacraments are received, another person can serve as a proxy (can fill in for the actual sacramental sponsor) at the ceremony. This is not all that unusual.
The RCIA sponsor is a practicing Catholic, often a member of that parish, who accompanies the RCIA participant during their faith journey into the Catholic Church. Think travel companion, moral supporter, friendly advisor, bridge to the parish community. Ideally the RCIA sponsor is available to be present for the Rite of Acceptance/Welcoming, the Rite of Election, and at least some of weekly sessions. I say ideally because this is the most helpful but usually someone will fill in if the RCIA sponsor cannot be present for one of the rites. I say usually because each parish will have its own specific requirements. In this age of technology I suppose that the RCIA sponsor could still be supportive from afar on a limited basis.
Finally, the sacramental sponsor and the RCIA sponsor can be but need not be the same person. In my experience when there are different persons in the two roles, the sacramental sponsor sometimes has not been present for any of the RCIA rites or sessions.
Assuming that you meet the canonical requirements, it seems to me that you could be the sacramental sponsor.
Whether or not you could or should be the RCIA sponsor will depend on how available you will be and what his particular parish requires.
Again, from my experience, I think you will find it rewarding to serve in one or both roles.
.