Senior ETL Developer

Senior ETL Developer

 

 

U.S. Citizenship is required for this position due to Department of Defense restrictions.

 

 

Who We Are

 

 

WPS Health Solutions is a leading not-for-profit health insurer in Wisconsin. Our services offer health insurance plans for individuals, families, seniors, and group plans for small to large businesses. We process claims and provide customer service support for beneficiaries of the Medicare program and manage benefits for millions of active-duty and retired military personnel across the U.S. and abroad. In 2021, WPS Health Solutions celebrated 75 years of making health insurance easier for those we serve. Proud to be military and veteran ready.

 

 

Our Culture

 

 

WPS' Performance-Based Culture is where the great work and innovations of our people are seen, fueled, and rewarded. We accomplish this by creating an inclusive, empowering employee experience, focusing on People, Work, and Conditions. This results in people bringing their authentic selves to work every day in an organization that successfully adapts to business changes and new opportunities. We are guided by our Purpose: Together, making health care easier for the people we serve.

 

 

In 2021, 2022 and 2023 WPS Health Solutions was recognized for several awards including:

 

 

• Madison, Wisconsin's Top Workplaces
• Top Workplace national cultural excellence awards for Remote Work and Work-Life Flexibility
• Achievers 50 Most Engaged Workplaces® with the further honor of Achievers "Elite 8" winner in the category of Culture Alignment

 

 

Role Snapshot

 

 

As a Senior ETL Developer, you will be part of a team that designs and develops Business Intelligence data integration solutions for internal and external business partners here at WPS. You will design, develop, and test extract, transform, and load processes for enterprise-wide data warehouse and data store implementations.

 

 

In this role you will:

 

 

• Design, develop, test, optimize, and deploy SQL Server Integration Services (SSIS) packages to perform all data integration requirements.
• Assist in research and issue resolution for processing of data.
• Design and implement performance tuning capabilities into deliverables to ensure service levels are met.
• Provide expertise and technical leadership to SSIS development.
• Ensure design and development tasks conform to all data consolidation, data integration, data transformation, and data quality best practices.

 

 

How do I know this opportunity is right for me? If you:

 

 

• Enjoy collaborating with business and technical teams to translate requirements into design specifications.
• Have a passion for designing, developing, testing, optimizing, and deploying ETL packages to perform all data integration requirements.
• Enjoy designing and implementing performance tuning capabilities into deliverables to ensure service levels are met.
• Want to provide technical leadership to ETL developers assigned to projects.
• Love providing quality project oversight for all activities related to data consolidation, data integration, data transformation, and data quality.

 

 

What will I gain from this role?

 

 

• Working in a cutting-edge data centric environment.
• Gaining experience in a new formed and evolving Agile environment.
• Experience working in an environment that serves our Nation's military, veterans, Guard and Reserves and Medicare beneficiaries
• Working in a continuous performance feedback environment.

 

 

Minimum Qualifications

 

 

• U.S. Citizenship is required for this position due to Department of Defense restrictions.
• 1 or more years of related work experience.
• Bachelor's Degree in related field or equivalent post high school and/or related work experience.

 

 

Preferred Qualifications

 

 

• Proven experience leading high performing teams
• 2 or more years as a Microsoft SSIS ETL Developer
• 2 or more years utilizing Microsoft SSDT or Management Studio
• 2 or more years working in Data Warehousing roles
• Dynamic SSIS Framework development

 

 

Salary Range

 

 

$95,000 - $115,000

 

 

The base pay offered for this position may vary based on your experience, knowledge, skills and may fall outside the posted range.

 

 

Work LocationThis role is open to remote work for this opportunity in the following approved states:

 

Arizona, Colorado, Connecticut, Florida, Georgia, Illinois, Indiana, Iowa, Michigan, Minnesota, Missouri, Nebraska, Nevada, New Jersey, North Carolina, North Dakota, Ohio, South Carolina, South Dakota, Texas, Virginia, Wisconsin

 

 

Remote Worker Requirements

 

 

For remote position, employee is required to meet remote worker requirements, including a designated work station, a wired (Ethernet) connection to the network, and a minimum of 10Mbps downstream connection with at least 1Mbps upstream (can be checked at https://speedtest.net)

 

 

Benefits

 

 

• Remote and hybrid work options available
• Performance bonus and/or merit increase opportunities
• 401(k) with dollar-per-dollar match up to 6% of salary (100% vested immediately)
• Competitive paid time off
• Health, dental insurance, Teladoc starts DAY 1
• Review additional benefits here

 

 

Sign up for Job Alerts

 

 

FOLLOW US!

 

 

LinkedIn

 

 

Facebook

 

 

Twitter

 

 

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

 

 

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)