Apply Now    
Job ID :
Location :
Northbrook, IL US
Level :
Experienced Professional
Job Category :
Description :

Where good people build rewarding careers.

Think that working in the insurance field can’t be exciting, rewarding and challenging? Think again. You’ll help us reinvent protection and retirement to improve customers’ lives. We’ll help you make an impact with our training and mentoring offerings. Here, you’ll have the opportunity to expand and apply your skills in ways you never thought possible. And you’ll have fun doing it. Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life.

Job Description

Encompass Insurance is one of the largest personal property and casualty insurance brands sold exclusively through a network of more than 3,000 independent agents in most states. With a legacy that dates back to 1897, Encompass employees and agents are committed to delivering a superior insurance experience for our customers. Encompass is a solely owned subsidiary of The Allstate Corporation (NYSE: ALL), the nation’s largest publicly held personal lines insurer.

Encompass is growth focused, looking to expand its presence throughout the country. We are seeking enthusiastic, creative, results-oriented people who thrive in a fast-paced environment. Encompass offers an exceptional career experience for our employees, with impactful work and exciting opportunities to make a difference. Join Encompass and you’ll be part of an exciting future.

Business Intelligence is responsible for developing and implementing Encompass business intelligence solutions to enable data-based decision making.  They promote the value and potential of BI within Encompass.

The Technical Analyst is responsible for delivering business intelligence solutions to enable data-based decision making.  Provide technical analysis, design, and build services while developing a broader & deeper understanding of business operations.  

Key Responsibilities:

  • Evaluate requirements and advise on technology solution options
  • Provide research, analysis, high-level design and estimates for data transformation and movement from sources to end-user BI solutions.
  • Leverage knowledge of transactional applications to reporting & analytics data stores to model, extract, transform, and load data.
  • Build and modify database tables and semantic layers.
  • Assist in navigation of release mgmt schedule and other enterprise processes to improve speed to market.
  • Review code with Developers and recommend improvements.
  • Liaison between IT and the business translating business requirements to technical resources and translating technical documentation into terminology & language understood by the business.
  • Support Data Governance Processes through Metadata documentation and data quality investigations.
  • Troubleshoot and resolve end-user issues with systems and reporting tools.
  • Advise Developers & Business Analysts on ad hoc queries.
  • Consult during BI tools reviews & provide recommendations.
  • Support in technical conversations with our technology partners outside of team.
  • Train Business Analysts & Developers on technical aspects of BI. 

Job Qualifications

  • Bachelor’s degree required.
  • Minimum of 5 years experience in business intelligence, reporting, data analysis or technology related field.
  • Strong customer service orientation that places high value on customer satisfaction.
  • Advanced Business Intelligence Tool skills.
  • Advanced ETL skills with tools such as Informatica.
  • Advanced with SQL and understanding of multi-dimensional and relational database data organization concepts.
  • Develop & demonstrate increasingly broad business knowledge and organizational awareness.
  • Strong interpersonal collaboration and team skills including working with cross-functional teams to achieve shared goals.
  • Strong verbal and written communication, facilitation, and interpersonal skills.
  • Versatile and willing & able to play a variety of roles beyond Title.

The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen.

Good Work. Good Life. Good Hands®.

As a Fortune 100 company and industry leader, we provide a competitive salary – but that’s just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, you’ll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy.

Learn more about life at Allstate. Connect with us on Twitter, Facebook, Instagram and LinkedIn or watch a video.

Allstate generally does not sponsor individuals for employment-based visas for this position.

Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

For jobs in San Francisco, please see the notice regarding the San Francisco Fair Chance Ordinance.

For jobs in Los Angeles, please seethe notice regarding the Los Angeles Ordinance.

It is the policy of Allstate to employ the best qualified individuals available for all jobs without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity/gender expression, disability, and citizenship status as a veteran with a disability or veteran of the Vietnam Era.


Apply Now