IT Data Engineering Intern

Description

Western National Insurance Group is a private mutual insurance company with over 120 years of experience serving customers' property-and-casualty insurance needs in the Midwestern, Northwestern, and Southwestern United States. Known as “The Relationship Company®,” we define success as a measure of the relationships we have built over time. In everything that we do, we know that delivering a friendly and helpful interaction makes for a better experience for everyone involved.

That is the power of “nice.” At Western National, nice is something we work to bring to every person and organization with whom we partner and serve.

Western National Insurance is seeking a Data Engineering Intern to join our Data & Integrations team as part of the Summer 2027 Internship Program. Our company growth, combined with our focus on innovation, transformation, and investments in the customer experience are key drivers supporting the expansion of our team. The Data Engineering Intern will provide support to a variety of projects and initiatives, while playing a key role in our day-to-day operations.

• Are you looking to jump start your career in the IT field?
• The individual in this role will have the opportunity to directly assist the Data & Integrations team with a wide range of projects including, researching and implementing new approaches for protecting sensitive customer data, and improving customer satisfaction by optimizing data loading and access strategies, so the right data is available quickly.

Western National provides a robust internship program designed for individuals aiming to acquire valuable experience in the insurance industry. This program not only offers practical, hands‑on opportunities and project work in partnership with our Data & Integrations team; but interns will also have the opportunity to enhance their existing skill sets through a range of professional development activities, cultivate relationships with employees and fellow interns, and participate in impactful volunteer initiatives within the community.

As a Data Engineering Intern in our Internship Program, you will join our Data & Integrations team and gain hands‑on experience supporting the systems and processes that turn business data into useful information. You will work alongside experienced data engineers and business partners while learning about enterprise data warehousing, data integration, software development, and Agile delivery practices.

Potential responsibilities include:

• Work with technologies used in our data environment, including SQL Server, SSIS, Snowflake, Python, and other tools that support enterprise data warehousing and automation. Our team is also transitioning selected data workloads from SSIS and SQL Server toward Snowflake, providing exposure to both established and modern data engineering practices.
• Develop and test enhancements to data applications, ETL/ELT workflows, and supporting processes based on business requirements.
• Troubleshoot and debug data integration and Enterprise Data Warehousing (EDW) issues by analyzing data, reviewing code, and working with team members to identify solutions.
• Write clear, maintainable code and contribute to code reviews, unit testing, and other quality practices.
• Participate in Agile activities such as backlog refinement, work estimation, planning, and team discussions.
• Help identify opportunities to improve data processes, documentation, automation, and team efficiency.
• Create and maintain technical documentation to support learning, onboarding, ongoing maintenance, and production releases.
• Follow data security, privacy, quality, and change‑management practices…