SQL Consultant - Remote

Posted on Jun 7 Northbrook, IL 201 views

The world isn’t standing still, and neither is Allstate. We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs. That’s why now is an exciting time to join our team. You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.

You’ll do all this in an environment of excellence and the highest ethical standards – a place where values such as integrity, inclusive diversity and accountability are paramount. We empower every employee to lead, drive change and give back where they work and live. Our people are our greatest strength, and we work as one team in service of our customers and communities.

Everything we do at Allstate is driven by a shared purpose: to protect people from life’s uncertainties so they can realize their hopes and dreams. For more than 89 years we’ve thrived by staying a step ahead of whatever’s coming next – to give customers peace of mind no matter what changes they face. We acted with conviction to advocate for seat belts, air bags and graduated driving laws. We help give survivors of domestic violence a voice through financial empowerment. We’ve been an industry leader in pricing sophistication, telematics, digital photo claims and, more recently, device and identity protection. We are the Good Hands. We don’t follow the trends. We set them.

Job Summary

The Application Developer Consultant II develops code for intermediate modules, participates in design reviews, conducts code reviews, creates test plans and participates in testing reviews, and resolves moderate defects.  The Consultant II designs, documents, reviews, and maintains components of software solutions for intermediate projects.  Under limited supervision, the Application Developer Consultant II, works closely with business partners and Project Mangers to identify needs and design technology solutions to: increase operational efficiency, reduce compliance risks and/or advance strategic initiatives. Their work can vary from tactical solutions that need to be delivered within a few days, to a strategic project that may shape how a business unit will operate far into the future. They may be responsible for all phases or portions of the development cycle beginning with: concept modeling and requirements gathering, to release and ongoing user support.  

Key Responsibilities

The ideal candidate will be able to demonstrate the following: 

  • Ability to work in a team environment as well as independently
  • Deep problem solving skills
  • An enthusiasm for SQL development and a proven ability to investigate and apply new technologies in your current role will also be strongly considered. 
Preferred Qualifications

Job Qualifications

  • 1+ years technology development and implementation experience.
  • Knowledge of Agile methodologies including test-driven development.

Undergraduate degree in Computer Science preferred

Compensation Data

Compensation range for this position is $60,000- $90,000 per year, based on experience and qualifications. 

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. For a full description of Allstate’s benefits, visit


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.


To view the “EEO is the Law” poster click “here”. This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs


To view the FMLA poster, click “here”. This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.


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 (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), 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.

More From Allstate

National General - Product Management - Senior Manager

Posted on Jul 2 Northbrook, IL 451 Views

PIP/Med Pay Claims Service Specialist

Posted on Jun 26 Northbrook, IL 187 Views

Independent Agency Sales Senior Manager

Posted on Jun 23 Northbrook, IL 215 Views

Claims Customer Care Specialist - (Remote/Hybrid)

Posted on Jun 5 Northbrook, IL 350 Views

Field/Virtual Property Adjuster Seattle, WA

Posted on Jun 3 Seattle, WA 318 Views

Related Job Listings


Data Scientist - Insurance Modeling

Posted on Apr 14 Northbrook, IL 188 Views


Senior Data Scientist - Transformative Growth Property (Remote - Home Based Worker)

Posted on Jun 7 Northbrook, IL 203 Views


Data Analytics Consultant

Posted on Jun 9 Northbrook, IL 315 Views


D3 Data Analytic Engineer

Posted on Jun 10 Northbrook, IL 160 Views


Lead Management Analyst

Posted on Jun 30 Northbrook, IL 182 Views