Consider the function $$ I(a,x) = x^{-a} \int_{1}^x y^{a-1} \exp(-y a) dy $$ where $x \geq 1$, and $a \geq 0$.
I am not really interested in the parameter $x$, so define $$ I(a) = \sup_{x \geq 1} I(a,x) $$
Now what is the asymptotic behavior of $I(a)$ as $a \rightarrow 0$?
I can show the bound $I(a) = \log(1/a) + O(1)$. This is by noting that $I(a,x) \leq \int_{1}^x \exp(-y a)/y \ dy \leq \int_{1}^{\infty} \exp(-y a)/y \ dy = \Gamma(0, a) = \log(1/a) + O(1)$.
The asymptotic behavior of $I(a)$ appears to be smaller than this, though, something like $I(a) \sim 0.9 \log(1/a)$

In a first step, we use the variable transform $y=(y-1)/(x-1)$ and obtain $$I(a,x)= \int_0^1\!dt\, x^{-a} (x-1) [1+ t(x-1)]^{a-1} e^{-a [1+ t (x-1)]}.$$ As we are interested in $a\to0$, we expand the integrand to first order in $a$ and obtain $$\begin{align}I(a,x) &= \int_0^1\!dt\, \left[ \frac{x-1}{1+t(x-1)} + a \frac{(x-1)(\log[1+t (x-1)] - \log x -1 - t(x-1)}{1+ t (x-1)} + O(a^2) \right] \\ &=\log x +a \left(1-x - \tfrac12 \log^2 x\right) + O(a^2) \end{align}.$$
The function $I(a,x)$ assumes its maximum at $x^* = a^{-1} + O(\log a) $. Thus, we have $$I(a) = I(a,x^*) = \log a^{-1} -1 + o(a). $$
Edit: As oenamen pointed out the answer is not self consistent. In expanding the exponent to get from the first expression to the second, I assumed that $ax\ll1$. Then I found that $x \simeq a^{-1}$ which of course outside the scope of the first assumption. However, it is not difficult to convince oneself that the $\log a^{-1}$ scaling (with unit prefactor and not like the OP assumed with a different pre factor) is indeed the correct asymptotic expression. Thus $$I(a) = \log a^{-1} + O(1).$$