IT Data Engineering Intern

About the role

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 Midwest, North, and South regions of the United States. Known as “The Relationship Company®,” we define success as a measure of the relationships we have built over time. 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.

Responsibilities

• Research and implement new approaches for protecting sensitive customer data.
• Optimize data loading and access strategies to improve customer satisfaction.
• Work with technologies used in our data environment, including SQL Server, SSIS, Snowflake, Python, and other tools that support enterprise data warehousing and automation.
• 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.
• 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 appropriate for an insurance environment.
• Complete special projects and other duties as assigned.

Requirements

• Currently pursuing a degree, certificate, or coursework in Computer Science, Data Engineering, Information Systems, Mathematics, or a related field.
• A passion for technology and an interest in working with, analyzing, and improving data.
• Basic experience with SQL and relational databases through coursework, projects, employment, or personal learning.
• Exposure to Python or another scripting/programming language.
• Strong problem-solving and analytical skills, with an interest in understanding how systems and processes work.
• Strong written and verbal communication skills, including the ability to explain technical concepts to both technical and nontechnical audiences.
• Willingness to ask questions, learn from feedback, and collaborate effectively with others.
• Able to pay close attention to detail when working with data, code, and documentation.
• Familiarity with Agile software development practices, source control tools such as Git or GitLab, or ETL/ELT technologies such as SSIS or Snowflake is preferred but not required.
• Exposure to DevOps concepts, CI/CD processes, testing practices, or tools such as Docker or Jenkins is a plus.
• Two years of college or equivalent relevant experience is preferred.

Compensation

The base pay offered for this position will be $20.00/hour.