Senior Business Analyst

WPS, a health solutions company, is a leading not-for-profit health insurer and federal government contractor headquartered in Madison, Wisconsin. We offer health insurance plans for individuals, families, seniors, and group health plans for small to large businesses. We process claims and provide customer support for Medicare beneficiaries and manage benefits for millions of active-duty and retired military personnel across the U.S. and abroad.

About the role

The Sr. Business Analyst serves as the primary liaison between business stakeholders and Information Technology, translating business requirements into technical solutions that improve efficiency, accuracy, and reporting capabilities. The role is responsible for analyzing business processes, developing and enhancing automated workpapers and reporting tools, and supporting the design and maintenance of systems used throughout the cost reporting process. The Sr. Business Analyst supports the delivery of scalable solutions that align with organizational objectives.

Responsibilities

• Partner with business stakeholders to gather, analyze, and document business requirements, translating operational needs into technical solutions and system enhancements.
• Design, develop, maintain, and enhance automated workpapers, reports, and business processes using VBA, SQL, Power Query, and related technologies.
• Analyze data from multiple sources to improve reporting accuracy, streamline workflows, and support audit and financial reporting activities.
• Collaborate with IT teams to define system requirements, test new functionality, troubleshoot issues, and support implementation of technology solutions.
• Develop and maintain technical documentation, process documentation, and user guides for automated tools, databases, and reporting solutions.
• Research emerging technologies and recommend process improvements to enhance automation, efficiency, and data integrity across the department.
• Other job-related responsibilities may be assigned as required.

Requirements

• Bachelor’s degree in Business Administration, Information Systems, or related field or equivalent combination of education and related work experience.
• Five (5) or more years of experience as a Business Analyst or in a similar analytical role.
• Proficient in VBA, Power Query, and SQL Database.
• Demonstrated experience leading requirements gathering and producing documentation to capture and organize business needs into clear, actionable items.
• Expertise documenting workflows and identifying opportunities for incremental improvements.

Skills

• Strong communication and collaboration skills with ability to effectively engage stakeholders and maintain progress visibility.
• Strong organization and time management skills with the ability to effectively manage priorities and deadlines within short delivery cycles.
• Strong analytical, problem-solving, and critical thinking skills.

Preferred Qualifications

• MS Access experience.
• Knowledge of Medicare cost report process.

Work Location

Our first consideration is for this employee to live in the state of Wisconsin to take advantage of hybrid work and collaboration. Employees within 45 miles of WPS Headquarters (1717 W. Broadway in Madison, WI, 53713) will be expected to work hybrid 2 days a week on a regular basis. As a secondary consideration, we offer remote work in the following approved states: Colorado, Florida, Georgia, Illinois, Indiana, Iowa, Michigan, Minnesota, Missouri, Nebraska, New Jersey, North Carolina, Ohio, South Carolina, Texas, Virginia, and Wisconsin.

Remote Work Requirements

• Wired (ethernet cable) internet connection from your router to your computer.
• High-speed cable or fiber internet.
• Minimum of 10 Mbps downstream and at least 1 Mbps upstream internet connection (can be checked at speedtest.net).

Pay

The base pay offered for this position ranges from $80,000 to $90,000 and may vary based on your job-related knowledge, skills, and experience.

Benefits

• Remote and hybrid work options available.
• Performance bonus and/or merit increase opportunities.
• 401(k) with a 100% match for the first 3% of your salary and a 50% match for the next 2% of your salary (100% vested immediately).
• Competitive paid time off.
• Health insurance, dental insurance, and telehealth services starting on day 1.
• Professional and Leadership Development Programs.