Software Engineer Consultant II

Key Responsibilities

• Develop and maintain automation scripts using Python, SAS, Bash, or PowerShell for data processing, reporting, and workflow optimization.

• Write, optimize, and maintain complex SQL queries, stored procedures, and functions across enterprise database platforms (Oracle, SQL Server, PostgreSQL).

• Design, develop, and maintain scalable back-end services using Java Spring Boot and Node.js.
• Build responsive front-end interfaces using React.js, HTML, and CSS.
• Develop and consume RESTful APIs, SOAP web services, and JSON-based integrations.
• Write clean, maintainable code following object-oriented programming (OOP) principles and coding standards.

• Implement comprehensive testing strategies including unit, integration, and acceptance testing (TDD).
• Perform code refactoring to improve performance, readability, and maintainability.
• Manage source code using Git and participate in code reviews.
• Support CI/CD pipelines using Jenkins, Gradle, and containerization with Kubernetes.
• Implement web and API security best practices to protect applications and data.

• Partner with business analysts, front office, and operations teams to translate requirements into technical solutions.
• Collaborate with cloud infrastructure teams to deploy and manage applications on cloud platforms (Apigee, AWS, Azure).
• Troubleshoot production issues and support continuous improvement initiatives.

Qualifications

• 3–6 years of hands-on software development experience.
• Strong proficiency in scripting languages such as Python, SAS, Bash, PowerShell, or Perl for automation, data processing, and analytics.
• Advanced SQL skills with experience writing complex queries, joins, aggregations, stored procedures, and performance tuning across Oracle, SQL Server, or PostgreSQL.
• Proficient in back-end programming with Java and JavaScript.
• Experience with Java Spring Boot for building enterprise-grade applications.
• Working knowledge of React.js and advanced JavaScript libraries/frameworks.
• Solid understanding of Object-Oriented Programming (OOP) principles and design patterns.
• Experience developing and integrating SOAP/REST APIs and working with JSON data formats.
• Hands-on experience with Test-Driven Development (TDD).
• Proficient with Git for version control and collaborative development.
• Familiarity with CI/CD pipelines using Jenkins and Gradle.
• Experience with containerization and orchestration using Kubernetes.
• Working knowledge of Node.js for server-side development.
• Proficiency with development tools including IntelliJ IDE and Postman.
• Understanding of web security and API security principles.
• Familiarity with HTML/CSS for front-end development.
• Exposure to cloud infrastructure and API management platforms (Apigee, AWS, Azure).
• Familiarity with Agile/Scrum methodologies and SDLC best practices.
• Bachelor's degree in Computer Science, Software Engineering, or a related discipline preferred.

Nice to Have

• Exposure to investment management platforms (eFront, Aladdin) or financial services domain.
• Understanding of AI, generative AI, or information agent concepts.
• Experience with reporting and visualization tools (Power BI, Tableau, SSRS).
• Familiarity with Alternative Investments (Private Equity, Private Credit, Real Assets, Hedge Funds).
• Knowledge of ETL processes and data integration concepts.
• Experience with additional scripting languages (R, VBA, Groovy).

Experience

2 or more years of experience (Preferred)

#LI-TH1

Skills

Collaboration, Continuous Deployment, Continuous Integrations, JavaScript, JavaScript Object Notation (JSON), Java Spring, Python (Programming Language), Software Development

Compensation

Compensation offered for this role is 70,100.00 - 121,475.00 annually and is based on experience and qualifications.

The candidate(s) offered this position will be required to submit to a background investigation.

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

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 Know Your Rights” 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.

Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse. Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.

When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating. Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.

To help create a more personal and engaging experience, we ask that you join with your camera on if your interview is virtual. Please also have a Valid Photo Identification available at the start of your interview. If you require any accommodations or have questions ahead of your interview please reach out to your recruiter.

Note: Internal candidates are only asked to join on video; a Valid Photo Identification is not needed for the interview.