SQL Report Developer - Business Intelligence
- Employer
- Allstate Insurance Company
- Location
- Northbrook, Illinois
- Salary
- Not Specified
- Closing date
- Sep 28, 2019
View more
- Category
- Actuary
- Job Type
- Not Specified
- Career Level
- Not Specified
Job Details
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 is a growing, $1B+ business that is part of the Allstate Corporation. Encompass sells and services personal insurance products exclusively through independent agencies.
Encompass Product Operations is seeking a collaborative, innovative, analytical problem-solver with the technical ability to apply quantitative skills to develop business intelligence (BI) solutions to enable data-based decision making. This role provides technical analysis, design, and build services for reporting and analytic tools and data support to the Encompass organization.
Responsibilities
- Collaboration with data managers and internal Allstate/Encompass clients, including Encompass Product Operations, the Encompass Underwriting, Encompass Countrywide Risk Management, Encompass Pricing, and Encompass Finance
- Design, build and modify reporting and analytic tools and related data ETL processes
- Evaluate requirements and advise on technology solution options
- Advise Developers & Business Analysts on ad hoc queries
- Complete assigned regulatory data calls for Encompass companies
- Troubleshoot and resolve end-user issues with systems and reporting tools
- Act as liaison between IT and the business, translating business requirements to technical resources and translating technical documentation into terminology & language understood by the business
Responsibilities (Cont'd)
- Provide research, analysis, high-level design and estimates for data transformation from front end sources to end-user BI solutions
- Consult with Developers on technical specifications modifying our data lake and end-user BI solutions to ensure accuracy and usability
- Support Data Governance Processes through Metadata documentation and data quality investigations
- 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
- Advanced SQL skills and understanding of multi-dimensional and relational database data organization concepts
- 5 years experience in business intelligence, reporting, data analysis or technology related field preferred
- Advanced Business Intelligence Tool skills with tools like Business Objects
- Advanced ETL skills with tools such as SQL Server Information Services (SSIS)
- Proficiency with Microsoft Office (Excel, Word, PowerPoint)
- Strong interpersonal, collaboration and team skills including working with cross-functional teams to achieve shared goals
- Strong verbal and written communication skills
- Big data (ex. Hadoop) experience preferred
- Knowledge of insurance pricing, rating plan design and insurance product offerings preferred
- Programming experience preferred
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.
Allstate generally does not sponsor individuals for employment-based visas for this position.
It is the Company’s policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee’s ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race, religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment
Company
- Website
- https://www.allstate.com/
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert