IT Business Analyst

at  Allstate

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

JOB DESCRIPTION

The Business Analyst (BA) Sr Consultant II leads the analysis of business requirements and requests from the business, operations, and other users of IT services. Acts as a lead and contact for the business divisions and technology solution providers for all aspects of solution identification. Coaches and leads other Business Analysts. A BA Sr Consultant II supports projects of moderate to high complexity.

EXPERIENCE

• 3 or more years of experience (Preferred)

EDUCATION & EXPERIENCE (IN LIEU)

• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

SKILLS

Business Needs, Business Processes, Business Requirements, Data Analysis, Deliverables Management, Functional Requirements

• Knowledge of Power BI report development, including datasets and dashboard creation•

• Familiar with SQL and running SQL queries
• Ability to develop process/workflow documentation and presentations
• Ability to create an agenda and keep meetings on track
• Familiar with VersionOne
• Ability to work independently and as a part of a team
• Adaptability to changing business requirements and timeline

Education

• 4 year Bachelors Degree (Preferred

KEY RESPONSIBILITIES

• Consults on the functional test plans and conditions for assigned applications or projects of moderate complexity; ensure that the test plans cover the testing of all defined functional requirements; supports data analysis and validation from functional tests
• Assists with project initiation or planning for projects of moderate complexity
• Analyzes requirements and create or contribute to functional designs, leveraging more advanced technical skills; Assist with design application prototypes
• Uses appropriate tools and techniques to elicit and define requirements that address more complex business processes or projects of moderate to high complexity
• Leads information gathering sessions
• Executes change control process to manage changes to base lined deliverables and scope for projects of moderate to high complexity
• Strong Excel skills including pivot tables, cubes and Power BI datasets
• Participates in design reviews, application design impacts between concurrent releases, and technical walk-throughs
• Provides business knowledge and support for resolving technology issues across multiple areas of the business
• Provides expertise for multiple areas of the business through analysis and understanding of business needs; applies a broad knowledge of programs, policies, and procedures in a business area or technical field

• Knowledge of Power BI report development, including datasets and dashboard creation•

• Familiar with SQL and running SQL queries
• Ability to develop process/workflow documentation and presentations
• Ability to create an agenda and keep meetings on track
• Familiar with VersionOne
• Ability to work independently and as a part of a team
• Adaptability to changing business requirements and timelines

planned/unplanned after hours and weekends time is required

Education

• 4 year Bachelors Degree (Preferred)