Remote Data Transformation Analyst Jobs in Madison, WI

Rural Mutual Insurance, one of the top 50 property and casualty companies in the nation, has been protecting what we value in Wisconsin for over 90 years and proudly continues that mission today. We seek a Data Analyst to play a key role in delivering high-impact analytics and reporting solutions to drive sound business decision-making. This position requires deep expertise in Power BI, data modeling, and stakeholder engagement, along with the ability to contribute to broader data architecture and engineering initiatives.

• This is a remote position.
• Candidate must live and work in Wisconsin.
• Requires eligibility to work in the United States without sponsorship.

At Rural Mutual Insurance, we offer a supportive work environment, career growth opportunities, and a comprehensive compensation package that includes health, dental, and vision insurance, a matching 401(k), and generous time off. We’ve earned consistent recognition as a Madison Magazine Best Places to Work, and an A+ AM Best financial strength rating. If you're ready to be part of a team that values your expertise and encourages your professional growth, apply today!

$100,000 - $115,000 yearly

• Develop and maintain high-quality reports and dashboards using Microsoft Power BI
• Gather and analyze technical requirements from stakeholders across the organization
• Develop and maintain data models to support analytics, reporting, and self-service BI
• Provide ongoing administration, tuning, and support for Power BI and related tools
• Establish and promote standards for report design, data modeling, and data visualization
• Collaborate with cross-functional teams to ensure data integrity, quality, and alignment across systems and reporting solutions
• Analyze complex datasets to identify trends, risks, and opportunities, delivering actionable insights to business leaders
• Support and influence data governance, documentation, and data quality initiatives
• Contribute to the design and evolution of data architecture, including data transformations and pipeline development using tools such as dbt or similar frameworks
• Mentor and guide less experienced analysts, fostering best practices in BI development and data modeling
• Stay current with emerging trends and technologies in business intelligence, data engineering, and analytics

• Bachelor’s Degree in Computer Science, Information Technology, or related field, or an equivalent combination of education and experience
• 5+ years of relevant data analyst experience
• Advanced experience building scalable, insight-driven dashboards and reports using Microsoft Power BI or similar business intelligence tools, including performance optimization and troubleshooting
• Strong understanding of data visualization best practices, including user experience (UX) design and storytelling with data
• Experience developing and maintaining standards for report design, performance, and usability
• Solid knowledge of data modeling techniques, including dimensional modeling and semantic layer design
• Strong analytical skills with the ability to interpret complex datasets and translate findings into actionable insights
• Proficiency in SQL for data extraction, transformation, and analysis.
• Working knowledge of data warehousing concepts, including ETL/ELT processes, data pipelines, and layered data architectures.
• Experience with data transformation tools (e.g., dbt)
• Familiarity with cloud-based data platforms (e.g., Azure, AWS, Snowflake)
• Understanding of version control tools (e.g., Git) and collaborative development practices is a plus
• 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.