Business Intelligence and Data Analytics Consultant II

Role Description

Business Intelligence and Data Analytics Consultant II is responsible for leveraging data and analytics to answer moderately complex questions and influence business strategy through communication of findings to management. The position is also responsible for developing standards of practice around data retrieval, data manipulation, data reporting and data analytics.

• Influences strategy through data and analytics.
• Utilizes data and analytics expertise to coach and develop less experienced analysts.
• Communicates and presents project information to team and provides presentations/updates to management.
• Establishes, modifies, documents and communicates standards of practice around:
  • Data retrieval
  • Data manipulation
  • Data quality
  • Data reporting
  • Data analytics
• Compiles, cleans, organizes and analyzes moderately complex data to understand business results.
• Monitors and evaluates business initiatives against key performance indicators and communicates results and recommendations to management.
• Makes the business insights derived from data analytics accessible to those without technical skills.
• Provides technical expertise in advanced Power BI dashboard development, including building and enhancing line-of-business reporting for Claims and expanding analytical insights across existing projects.
• Partners with stakeholders to present findings, articulate reporting products, and translate technical insights into clear business recommendations.

Qualifications

• 2 or more years of experience.
• 4-year Bachelor’s degree.
• Prior experience with reporting and visualization tools such as Power BI or Tableau.
• Power BI technical expertise preferred, including experience building dashboards, enhancing reporting capabilities, and developing analytical insights for business stakeholders.
• Experience with data languages and database tools such as SQL, DAX, M Code, or Oracle preferred; candidates do not need to have experience with all.
• Ability to present technical products, reporting outputs, and analytical recommendations to stakeholders in a clear and business-oriented manner.
• Claims experience is preferred.

Requirements

• This job does not have supervisory duties.
• This position is not available to Alaska, California, Hawaii or Washington residents.

Compensation

• Compensation offered for this role is $60,000.00 - $97,125.00 annually and is based on experience and qualifications.

Benefits

• Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
• Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.
• When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating.
• Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.