Lead Software Engineer at State Farm Mutual Automobile Insurance Company
Bloomington, Illinois | posted: January 23, 2024
Lead Software Engineer
Job ID: 2023-35191
Type: Regular Full Time
# of Openings: 1
Category: Technology and UX
Bloomington, IL
Overview
We are not just offering a job but a meaningful career! Come join our passionate team!
As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of all associates, and creates a Good Neighbor culture.
We offer competitive benefits and pay with the potential for an annual financial award based on both individual and enterprise performance. Our employees have an opportunity to participate in volunteer events within the community and engage in a learning culture. We offer programs to assist with tuition reimbursement, professional designations, employee development, wellness initiatives, and more!
Responsibilities
- Utilize up-to-date coding, testing, security, DevOps, and software engineering practices to maintain and create new applications that support business requirements (25%).
- Analyze, design, deploy, support, and secure technology to ensure the organization is efficiently managing its technology and data-related assets in accordance with market best-practices and external regulations (15%).
- Improve usability and interaction between customer and product based on understanding of user experience (5%).
- Apply a wide application of complex principles, theories, and concepts in computer science for software engineering solutions (10%).
- Take responsibility of product from inception to sunset using DevOps and Agile mindset (5%).
- Collect and analyze information to identify customer’s technical needs, suggest solutions and develop implementation and integrations plans (5%).
- Support data services and automation using data infrastructure knowledge (10%).
- Develop data access related to storing, retrieving or acting on housed data (5%).
- Develop for technical data platforms (10%).
- Develop and maintain services that retrieve output of product models that are called by other applications as part of a workflow (10%).
Occasional travel required within the U.S. upon request. Option to work remotely from anywhere in the U.S.
Qualifications
Position requires a Bachelor’s degree or foreign equivalent, in Computer Science, Electronics Engineering, or a closely related field of study, plus 5 years of experience in the job offered, or similar position in software development with expertise in data processing applications. Must have 5 years of experience working with the following:
- SQL, including data joins, partitioning, indexing, performance tuning, and query optimization;
- Python;
- ETL tooling using structured and unstructured data including Informatica and Ab initio;
- Interacting with and maintaining relational databases, such as Oracle, SQL server, Teradata, and DB2;
- Data processing and ingestion patterns across various complex systems, including Korn Shell scripting and SQL scripting;
- Data analysis and research using SQL and ETL tools, such as Informatica, Ab initio, or similar tools to troubleshoot errors and data defects;
- Various software development methodologies including Waterfall and Agile with requirement gathering, designing and development of software solutions and testing.
Occasional travel required within the U.S. upon request. Option to work remotely from anywhere in the U.S.
#J-18808-Ljbffr