Structural Beam Installation Calculations

I need professional calculations to safely install a steel beam for knocking through a brick wall between my kitchen and dining room. The steel beam can be standard off-the-shelf.

Requirements:
- Structural engineering expertise
- Experience with steel beam installations
- Knowledge of brick wall modifications

Ideal Skills:
- Structural engineering degree
- Previous similar project experience
- Licensure or certification in relevant field

Please provide detailed calcs and ensure safety compliance.