Data Engineer Rural Mutual Insurance - 3.5 Madison, WI Job Details $105,000 - $120,000 a year 22 hours ago Benefits Disability insurance Health insurance Dental insurance Vision insurance 401(k) matching Qualifications Data model design Commercial use (data warehousing systems) Data Integration (Data management) Software design Requirements design Cloud data warehouses Integration Architecture Design (Architecture design skills) Schema design Technical solutions implementation Programming languages Data Architecture Design (Architecture design skills) Version control systems Integration Platforms (Enterprise solutions) Cloud Native Design Business requirements Implementing IT solutions Dimensional modeling Full Job Description 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 and scalable data pipelines and data models on cloud technologies. 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.

Compensation:

$105,000 - $120,000 yearly

Responsibilities:

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.

Qualifications:

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 in designing and optimizing enterprise-scale ETL/ELT solutions and modern data integration architectures. (Fivetran and dbt preferred) Strong experience designing and supporting cloud-native data warehouse solutions. (Snowflake preferred) Strong with SQL and other programming languages. (Python preferred) Experience in designing and implementing dimension (star schema) data models Experience with version control and code management within a multi-tier code repository. Experience using Infrastructure as Code tools. (preferred) Proven ability to translate business requirements into successful data solutions. 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.

About Company 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.