Senior BA – EEC

Eightelevengroup; Frankfort, Northern (KY, KY); Hybrid; USD 80,000 - 110,000; Full time

Job summary

The Kentucky Energy and Environment Cabinet (EEC) is seeking a Senior Business Analyst on a contract basis to support the migration of Microsoft Access databases to a new system. The Senior BA will document processes, data mappings, and migrations, working closely with DBAs, developers, IT support, and business stakeholders to ensure accuracy and data integrity.

Responsibilities include creating migration guides, facilitating requirements gathering, and maintaining a centralized repository of

Qualifications

• Demonstrated ability to develop clear technical documentation, including architecture diagrams, structured user stories, and formal requirements specifications.
• Experience facilitating requirements gathering workshops with non-technical SMEs.
• Familiarity with Microsoft Access, SQL, and Excel.
• Strong attention to detail and ability to document processes, data mappings, and data integrity checks.
• Ability to analyze data structures, mappings, migration processes, and migration scripts.
• Strong communication and collaboration to translate technical information for business users and stakeholders.
• Adaptability to changing requirements and priorities.

Responsibilities

• Develop step-by-step migration guides, checklists, procedures, and troubleshooting documentation for migrating Access databases to the new system.
• Collaborate with database administrators, developers, IT support, and business stakeholders to gather requirements and ensure technical accuracy.
• Facilitate requirements analysis with technical and non-technical stakeholders.
• Provide strategic leadership and, when needed, lead re-engineering or project management efforts.
• Maintain centralized project documentation repositories and ensure materials remain current post-migration.
• Review and edit technical content for clarity, consistency, and accuracy.
• Monitor migration outcomes and incorporate feedback from end users and stakeholders.
• Develop technical standards, procedures, and policies that meet customer needs.
• Adapt priorities as departmental requirements evolve.

Skills

Technical Writing

Requirements gathering

MS Access

SQL

Excel

Data mapping

Communication

Adaptability

Job description

The Kentucky Energy and Environment Cabinet (EEC), Division of Information Services (DIS), is seeking qualified candidates for a Senior Business Analyst (BA) contract position.

Please review the position overview, project description, responsibilities, deliverables, and qualifications below.

Position Overview

• Job Title/Classification: Senior Business Analyst
• Work Location: Onsite

Project Description

The Energy and Environment Cabinet is seeking a qualified Senior Business Analyst to support the migration of Microsoft Access databases and other data repositories to a new, separate database system.

The Senior BA will serve as a bridge between technical teams and end users by developing clear, accurate, and actionable documentation to support a smooth transition, minimize downtime, and maintain data integrity.

The selected contractor must be able to create clear and comprehensive project documentation using consistent templates and styles. Documentation must be technically accurate, easy to understand, and aligned with business objectives.

The Senior BA will work at the highest level of most phases of information systems analysis while considering the business implications of applying technology to both the current and future environment.

Key Responsibilities and Deliverables

• Document Migration Processes: Develop step-by-step migration guides, checklists, procedures, and troubleshooting documentation for migrating Microsoft Access databases and other data repositories to the new system.
• Collaborate with Technical and Business Teams: Work closely with database administrators, developers, IT support, and business stakeholders to gather requirements, validate data mappings, and ensure technical accuracy.
• Facilitate Requirements Analysis: Identify and implement appropriate systems analysis procedures and practices. Facilitate requirements-gathering activities with technical and non-technical stakeholders.
• Provide Strategic Leadership: Contribute to strategic planning, promote the effective use of technical services to resolve business problems, manage customer expectations, and, when needed, lead re-engineering efforts or serve in project management capacity.
• Maintain Documentation Repositories: Organize and maintain project documentation in a centralized repository, ensuring materials remain accurate and current following migration activities.
• Review and Edit Technical Content: Proofread and edit technical documentation to ensure clarity, consistency, accuracy, and completeness.
• Monitor and Follow Up: Evaluate migration outcomes, update documentation as needed and incorporate feedback from end users and project stakeholders.
• Develop Standards and Policies: Assist in developing technical standards, procedures, and policies that meet customer and departmental needs.
• Adapt to Changing Requirements: Adjust priorities and deliverables as departmental needs and project requirements evolve.

Candidate Qualifications and Requirements

• Technical Writing: Demonstrated ability to develop clear and comprehensive technical documentation, including architecture diagrams, structured user stories, and formal requirements specifications.
• Requirements Gathering: Experience facilitating requirements gathering workshops and collaborating effectively with non-technical Subject Matter Experts (SMEs).
• Database Knowledge: Familiarity with Microsoft Access, SQL, and Microsoft Excel.
• Attention to Detail: Strong attention to detail and demonstrated ability to accurately document technical processes, data mappings, and data integrity checks.
• Analytical Skills: Ability to analyze data structures, data mappings, migration processes, and migration scripts.
• Communication and Collaboration: Strong interpersonal and communication skills with the ability to effectively translate technical information for business users and stakeholders.
• Adaptability: Demonstrated ability to remain flexible and adapt to changing solutions, priorities, and departmental requirements.

Background Check and Onboarding Requirements

The selected candidate will be required to:

• Successfully pass a comprehensive background check completed within 60 days prior to the start date.
• Sign all applicable Commonwealth confidentiality agreements and acceptable electronic mail use agreements prior to onboarding.