Skyrim Special Edition Changes:
Cost value of the spell tomes were reduced considerably. The Liquefaction spell is twice the cost of the Electro-Mining spell. Electro-Mining spell is now a hostile spell with the same magicka cost and half the damage of the Sparks spell. Be careful when mining in populated mines. However, it can be of use when mining in the wilds to fend off those pesky wolves. This change means that while you cannot get magic skill from mining without a mining script that provides such skill gain, you can gain Destruction skill should you use the spell against any creature.
Original Skyrim version

Why it exists:
In my desire to attempt playing a spell-sword character I wanted to use spells as much as possible. Enter the original mod Mining For Mages. While the original worked with the base game it did not work with stalhrim in the Dragonborn DLC. Story wise, it makes sense because only the specific pickaxe can be used. But all things being moddable, I wanted it to work with stalhrim. But more than that, I didn't like the effects for the mining spell. You had to be right on the mine because it was impossible to see where you were aiming not to mention the range was really short.

What it does:
Provides two spells

• Electro-Mining - Lightning that splits precious minerals from mundane rocks
• Liquefaction - Liquifies raw materials into purified ingots
  
  

Both spells are in the Alteration family. They are added to the levelled lists via a script that runs when the mod starts. As a result they may be found at spell book vendors as well as out in the wild. At early levels the purchase cost can be prohibitive. No particular reason why, I picked a number and went with it. Liquefaction provides 15 points of Alteration per cast. Electro-Mining by itself does not provide experience. To gain experience with Electro-Mining you need to use a mining mod that alters the MineOreScript to include skill experience gain. Random Mining is one such mod.

Requirements:
Should be obvious...  
Dragonborn DLC is required.

Installation:
Use the mod manager of your choice or install manually to the data folder

Files and Folders:
Data > Mining For Mages Redux.esp
Data > Mining For Mages Redux.bsa

Things to note:
Electro-Mining effective range is the same as the Lightning spell. It can be cast at a greater distance but has no effect other than to drain magicka and leave scorch marks. At a base of 100 magicka, if you drain half without obtaining ore, move closer.
Regarding stalhrim the spell works on the basic veins. There are a few veins used to block off access to specific locations, these veins have a different script and require the pickaxe to be used.

Credits:
Dementor for the original Mining For Mages mod 
While I used no part of the original mod, the idea was born from it.

Permissions:
Do what you wish. Please give credit.