Modeling Summer Jobs in Madison, WI (NOW HIRING)

Rural Mutual Insurance is looking for an experienced and motivated data professional to play a critical role in the design, development, and maintenance of the company’s data warehouse and related data marts.

As a Data Engineer, you will be responsible for implementing and optimizing data pipelines, ensuring data quality, and building data models that support analytics and business intelligence initiatives. The ideal candidate will have a deep understanding of data engineering and data modeling principles, with a proven track record of designing, implementing, and maintaining robust, scalable data pipelines and models on cloud platforms. 

This is a remote position with periodic on-site presence required. Candidates must live and work in Wisconsin and have eligibility to work in the United States without sponsorship. 

If you're ready to be part of a team that values your expertise and encourages your professional growth, apply today!

Rural Mutual, a leading property and casualty insurance company based in Wisconsin, is well known for its financial strength and longevity in the insurance industry. Our reputation in the marketplace ensures stability and opens up numerous growth opportunities for our employees. Committed to our employees and their families, we offer a suite of benefits promoting health and wellness. We prioritize work-life balance, offering flexible start times as well as summer hours for this role. Join our experienced and talented team of IT professionals dedicated to excellence, innovation, and collaboration. 

$105,000 - $120,000 yearly

• Architect, design, and implement scalable data pipelines and integration frameworks that support enterprise analytics, reporting, and data-driven decision making.
• Optimize data pipelines and models for performance, scalability, and cost-efficiency.
• Design and implement dimensional (star schema) data models that accurately represent business processes and support analytical needs.
• Partner with business stakeholders, analysts, and technical teams to translate complex business requirements into scalable and sustainable data solutions.
• Implement data validation and quality checks to ensure the integrity and accuracy of the data and subsequent analytics.
• Monitor and maintain data pipelines and systems, identify issues, and implement solutions to ensure continuity and uptime.
• Create and maintain comprehensive documentation for data pipelines and models.
• Evaluate emerging technologies and recommend improvements to the organization's data architecture, engineering and modeling practices.

• Bachelor’s Degree in Computer Science, Data Analytics, Software Engineering, or related field, or an equivalent combination of education and experience.

• Proven experience designing, implementing, and supporting enterprise data warehouse and analytics solutions.

• Deep expertise designing and optimizing modern data integration and enterprise-scale ETL/ELT solutions using Fivetran and dbt.

• Strong experience designing and supporting Snowflake-based data warehouse solutions.

• Strong with SQL and other programming languages. (Python preferred).

• Experience with version control and code management within a multi-tier code repository.

• Experience in designing and implementing dimension (star schema) data models.

• Proven ability to translate business requirements into successful data solutions.

• Experience using Infrastructure as Code tools. (preferred).

• Experience in the property and casualty insurance industry. (preferred).

• Candidate must live and work in Wisconsin.

• Eligible to work in the United States without sponsorship.

What You'll Love About Rural Mutual Insurance:

We are a leading property and casualty insurance company based in Wisconsin, well known for our financial strength and longevity in the insurance industry. Our reputation in the marketplace ensures stability and opens up numerous growth opportunities for our employees.

We created a welcoming place to work with friendly and professional leadership. We are known for the great care we take with our staff, our agents, and our customers. We are passionate and determined about delivering the best customer service, preserving insurance industry knowledge, and making a difference through the work that we do.

We believe in a healthy work/life balance and, to that end, offer a competitive and comprehensive compensation package including health, dental, life, LTD, and vision insurance as well as an employee bonus plan, matching 401(k) plan, and generous time off benefits. Rural Mutual is an Equal Opportunity employer.