Apply Now    
Job ID :
Location :
Irving, TX US
Level :
Experienced Professional
Job Category :
Information Technology
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


The Allstate Corporation is the nation’s largest publicly held personal lines insurer. Encompass is a growing, $1B+ business that is part of the Allstate Corporation.  Encompass sells and services personal insurance products exclusively through independent agencies. Encompass Technology Organization and is looking for bright motivated individuals to join their team. Individuals will work with clients, technology leaders and business analysts to enhance and maintain a complex large-scale web application platform for selling and servicing insurance policies for multiple business units. Allstate is looking for a bright & motivated individual to join their team.

The Data Warehouse Systems Analyst provides technical leadership from project inception through rollout, creating high-level technical requirements and designs to develop and support optimal IT solutions by applying knowledge of business processes and systems architecture.

The Data Warehouse Systems Analyst (SA) Sr. Consultant creates high-level technical designs for complex projects and maintenance efforts by analyzing requirements and systems architecture, collaborating with technology partners and adhering to tool standards with little assistance. The SA Consultant assesses, documents, and mitigates design constraints and/or risks and performs design reviews to develop and support optimal IT solutions.

Job Description

Key Responsibilities

  • Creates the high-level technical design for one or more highly-complex projects and maintenance efforts by analyzing and tracing designs to requirements (business and functional) and systems architecture 
  • Accountable for creation high level technical designs, leading design reviews, and performing analysis for a portfolio of applications
  • Understands the technical details, integration, and functions of multiple applications, hardware, and/or software within a team. Executes and enforces best practices. May be responsible to identify and design for non-functional requirements
  • Acts as a liaison between the business analyst and the development /test team
  • Troubleshooting and root cause analysis for systems issues
  • Applies extensive technology and business experience to identify and define strategic information technology needs across all major business functions in data warehouse product suite.
  • Consults and provide inputs on the development, review and final approval of project estimates and statements of work for large and complex efforts or those which have a significant technical impact regardless of size
  • Provides inputs to the Quality Control Analysts on the approach and content required to conduct module, integration, and functional testing
  • Collaborates with appropriate parties to resolve complex change control issues. Communicates the results of these decisions to all affected stakeholders
  • Review and approves operations, environment, and/or desktop training plans for the largest/most complex projects
  • Leads the effort to obtain agreement from the technology organization leadership on required operations, environment, and/or desktop design


Job Qualifications




Bachelor’s degree or equivalent experience


• 5+ yrs hands-on experience with data warehouse Management Systems (ETL and Reporting)

• Sound knowledge of system configuration options to support business processes, is required
• Hands-on experience with Oracle DBMS, SQL, Stored Procedures
• Sound functional, analytical, and troubleshooting skills
• Experience with Microsoft Office suite
• Good understanding of Business Intelligence Best Practices/Methodologies, relational structures, dimensional data modeling,  data warehouse and reporting techniques, ETL and ELT processes



• Informatica and Business objects exposure is a plus

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 click "here" for information regarding the San Francisco Fair Chance Ordinance. 

For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring 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    
Link for schema