Software Engineer 1

Job Title: Software Engineer 1

Company: Grange Insurance Association

Location: Seattle, WA

Pay Range: $67,725 - $90,000

Join Grange Insurance Association, a well-established leader in the insurance sector for over a century! Headquartered in the city of Seattle, with a footprint stretching across six Western states, we've been protecting families, farms, and businesses with unwavering commitment. As you embark on a fulfilling career with Grange, discover why our average employee tenure surpasses a decade. Make your mark with an organization that values quality, service, and the lasting impact you can bring!

Position Overview:

The Software Engineer 1 delivers end-to-end solutions related to Data Engineering, Business Intelligence (BI), Reporting, and Analytics projects working with business and technical staff across the organization.

• Work with business units to understand business needs and requirements.
• Design and Implement BI solutions to meet requirements and objectives.
• Understand data models and data structures using various methods of investigation.
• Develop various visualization and reporting solutions including dashboards and interactive reports.
• Develop moderately complex SQL and T-SQL queries, scripts, functions, procedures, packages, and other data extracts.
• Test development work and verify that the solutions developed meet the requirements and objectives.
• Document business requirements, solution designs, code, testing, and implementation approaches as necessary.
• Perform analysis of production jobs, backup processes, system monitors, systems availability, and provide solutions by working with all groups impacted.
• Support QA functions including production deployments and change management. This includes completing quality assurance reviews ensuring that the system/program achieves the objectives of both the User and Organization.

Qualifications:

• 1-3 years of progressive IT data services experience, including direct development experience in SQL Server tools (T-SQL, SQL Management Studio, SSIS, SSRS, SSAS etc.).
• Experience with utilizing data warehouses/star schemas/data cubes.
• Ability to learn and use new technologies and tools required to develop BI solutions.
• Experience working with Power BI is a plus.
• Working knowledge of MS Excel including development of formulas, macros, charts, and pivot tables.
• Working knowledge of Team Foundation Server (TFS) and Visual Studio.
• Ability to work well independently and with teams, possess excellent problem solving, communication, and attention-to-detail skills.
• P&C Insurance industry experience preferred.
• Bachelor's degree in a related field preferred.

Comprehensive Benefits:

• Pay Range: $67,725 - $90,000
• Flexible hybrid work schedule (2 days per week in Seattle office required)
• Medical, Dental, and Vision plans
• 401(k) plan with up to 5% match
• Employer sponsored LTD, life insurance, and AD&D
• Discretionary profit sharing and bonuses
• Fully subsidized ORCA card and/or free parking for Seattle employees
• Education Reimbursement
• On-Site Fitness Center
• Opportunities for career growth and advancement within the organization.
• A supportive and collaborative work environment.
• Ongoing training and professional development opportunities.

How to Apply:

If you are passionate about helping people, have a strong understanding of property claims, and are ready to join a dynamic team, we encourage you to apply.

Grange Insurance Association is an equal opportunity employer and welcomes all qualified candidates to apply.

Grange Insurance Association is committed to ensuring a diverse and inclusive workplace where all employees are treated with respect and dignity. We encourage applications from candidates of all backgrounds and experiences.