Business Analyst - Any Line Shop Location OH

FirstEnergy•Akron, OH

8d•Onsite

About The Position

FirstEnergy Service Company is hiring a Business Analyst for a full-time, on-site position at any FirstEnergy line shop location in Ohio. The role primarily designs, builds, and optimizes relational databases, custom macros and modules, and automation tools using Microsoft Access and Excel. It translates complex business requirements into scalable, user-friendly solutions; creates interfaces such as forms, dashboards, and reports for non-technical users; improves legacy databases, spreadsheets, and VBA applications; and prepares technical documentation and user guides. As backup or as needed, the role supports other Business Analysts with work-plan meetings, collecting and logging agreed-upon changes, coordinating database updates, and preparing or distributing WMO Consolidated Planning reports. It also supports Consolidated Planning systems and processes, business research and analysis, process improvements, management and business partners, and implementation of corrective actions. The position promotes safe work practices and may provide storm support outside regular hours, including weekends and holidays. Occasional travel for meetings or training may occur but is expected to be very infrequent. The posting describes qualifications for Assistant, Associate, Business Analyst/Advanced Business Analyst, and Senior Business Analyst levels. Requirements vary by level, including relevant STEM education or equivalent experience and, for advanced and senior levels, specified years of relevant work experience.

Requirements

For the Assistant Business Analyst level: a two- or four-year degree in a STEM field such as Computer Science, Engineering, Mathematics, Physics, Software Development, Programming, Data Science/Analytics, or Information Technology, or a related field; equivalent practical experience is also accepted. A certificate in a related Computer Science field will be considered.
Strong understanding of relational databases, SQL, and data modeling.
Advanced knowledge of Microsoft Access and Microsoft Excel; both are required.
Detail-oriented analytical VBA design and development skills to streamline business operations by automating and optimizing existing processes.
Strong collaboration skills and ability to build relationships with key stakeholders.
Ability to analyze and interpret information and make recommendations based on analytics.
Ability to communicate effectively with technical and non-technical stakeholders.
Strong problem-solving, analytical, and logic skills.
Questioning attitude and willingness to challenge the status quo.
Ability to maintain confidentiality, work independently and/or in teams, and demonstrate sound decision-making.
Model FirstEnergy core values and behaviors.
Ability to deliver quality, accurate work within established guidelines.
Basic analytical, critical-thinking, problem-solving, and decision-making skills, with proven ability to work effectively in a team environment.
Ability to research and use best practices.
Actively seek ways to take on challenges and add value within the scope of assignments.
Awareness of changes to tasks, processes, and procedures that affect the organization.
For the Associate Business Analyst level: meet the requirements above and have deeper knowledge of the listed requirements.
For the Business Analyst/Advanced Business Analyst level: a STEM bachelor's degree or equivalent practical experience, with at least 4 to 7 years of relevant work experience; alternatively, at least 7 years of relevant work experience in lieu of a degree.
For the Business Analyst/Advanced Business Analyst level: advanced ability to analyze data and deliver recommendations, and ability to communicate with different levels of upper leadership while representing the Voice of the Employee.
For the Senior Business Analyst level: a STEM bachelor's degree or equivalent practical experience, with at least 7 years of relevant work experience; alternatively, at least 10 years of relevant work experience in lieu of a degree.
For the Senior Business Analyst level: ability to independently drive thought and lead collaborative efforts.

Nice To Haves

Knowledge of TOAD (Tool for Oracle Application Developers) is preferred.
A certificate in a related Computer Science field will be considered.

Responsibilities

Design, build, and optimize relational databases, custom macros and modules, and automation tools within Microsoft Access and Excel.
Translate complex business requirements into clean, scalable, user-friendly automation solutions.
Create user-friendly GUIs, forms, dashboards, and reporting interfaces for non-technical end-users.
Analyze and upgrade legacy databases, spreadsheets, and VBA applications to improve performance and stability.
Write technical documentation and user guides for tools and scripts.
As backup or as needed, facilitate recurring work-plan meetings with short-term planning personnel, Operations management when available, and Engineering personnel responsible for designers.
Collect agreed-upon target changes for remaining work and absences through meetings and stakeholder collaboration.
Enter collected data into a change log and provide it to the database administrator for implementation.
Prepare, publish, and/or distribute WMO Consolidated Planning reports as needed.
Promote safety and safe work practices.
Provide storm support, including off-hours, weekends, and holidays.
Support and champion Consolidated Planning systems and processes for FirstEnergy Utility Operations.
Support management and business partners by following established practices and providing consistent service, continuous support, and proactive involvement.
Recommend and develop solutions to issues and assignments.
Identify and support process improvements and efficiencies in collaboration with corporate departments such as Engineering.
Anticipate and meet internal and external customer needs.
Conduct business-specific research, analyze work-plan data, interpret results, and assist with corrective-action implementation when necessary.
Participate in developing WMO Consolidated Planning programs and policies.
Travel to meetings and training on an infrequent basis, as needed.