IT Data Engineering Intern

Job Type
Internship
Description
Who are we?
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 Mutual Insurance Company is seeking to expand its IT team by adding a Data Engineering Intern. 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.
Does this interest you?

• Are you looking to jump start your career in the IT field?
• Directly assisting the Data Engineering 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.

We ARE? The Relationship Company ®! We are successful because we differentiate ourselves through exceptional service and the customer experience. We are here for our policyholders and independent agents in their time of greatest need. Whether it be commercial property/casualty insurance or personal home, auto, and/or property insurance, we have policy coverage to protect what's most important. Our super-regional footprint in the Midwest, northwest and Alaska extends our reach and expands our network.
Western National Internship Program Summary:
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 IT Product Engineering 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.
Position Summary:
As a Data Engineering intern in our Internship Program, you will be a key member of our agile Data Engineering team responsible for the full software development lifecycle: design, development, testing, deployment, and support. We work with the traditional Microsoft Business Intelligence (BI) stack (SQL Server, SSIS, and SSAS) and more; incorporating industry standards and trends related to Enterprise Data Warehousing (EDW), unit testing, automation, and Agile development methodology. Possible tasks that you assist with include:

• Develop changes to existing application systems to meet the requirements of our business partners and improve our customer experience.
• Troubleshoot and debug EDW and other data related Extract-Transform-Load (ETL) issues to identify solutions.
• Contribute to code quality by writing human-readable code, giving and receiving feedback in code reviews and writing and executing unit tests.
• Collaboratively refine and estimate work with the team.
• Brainstorm process improvements for our team and enhancements for our processes.
• Prepare documentation for purposes of learning and onboarding, as well as for releases of code to production.

Requirements
What You'll Need to Succeed:

• Possess a passion for technology - especially managing and analyzing data.
• Strong communication skills and ability to give and receive feedback effectively.
• Engagement in on-going training & education in Computer Science or a related field.
• Two years of college preferred.
• Database development and management.
• Use of ETL/ELT tools such as SSIS.
• C# and Python scripting.
• DevOps experience (CI/CD processes and tools, GIT/GITLab/Docker/Jenkins).
• Translating technical or complex concepts into more accessible terms for a broad audience.
• Agile software development practices.

Compensation Overview:
The base pay offered for this position will be $20.00/hour.
More About Western National Mutual Insurance Company:
Western National is a growing, A+ rated group of property/casualty insurance companies serving individuals, families, and businesses in 20 states across the Midwest and Northwest U.S., including Alaska. Some of the recognitions we have received include:

• Star Tribune Top Workplace
• Wards Top 50 performing Property/Casualty Insurance Company - 15 consecutive years
• 41st largest private company by revenue in Minnesota (Minneapolis-St. Paul Business Journal)
• Wellness by Design Platinum +Green Award (Hennepin County)

Western National has long been known as "The Relationship Company®" and caring for our employees is part of that relationship commitment. We value connectiveness, empowerment, and accountability, and we believe that our employees are our biggest asset. We also offer competitive pay, robust wellbeing programs, and a healthy work-life balance; and these attributes are just some of the reasons why half of our employees have chosen to stay with us for 10 or more years. ? Check out our website ( ) for additional information about our company and the many reasons to work with Western National Insurance Group.
Western National provides employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.