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 nationargest 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 Education: Bacheloregree or equivalent experience
Requirements: - 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
Preferred - 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.
