Senior ETL Developer

Wisconsin Physicians Service Insurance Corporation Madison , WI 53706

Posted 2 months ago

Senior ETL Developer

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

Role Summary:

The ETL Developer will design and develop Business Intelligence data integration solutions for WPS. You will design, develop, and test extract, transform, and load processes for enterprise-wide data warehouse and data store implementations. You will need to demonstrate effective communication skills to interpret needs of clients and coordination with other teams.

Oversee design and development of Business Intelligence data integration solutions for WPS. Design, develop, and test ETL processes for enterprise-wide data warehouse implementations. Serve as technical lead on projects ensuring all design methodologies conform to industry best practices and processes. Serve as technical lead for large, complex data integration projects and direct technical work efforts of other ETL developers. Identify and design process and technical improvements for Enterprise Data Warehouse. Share knowledge with and mentor ETL development staff.

In this role you will:

Development (70%)

  • Work with business and technical teams to analyze and prepare specifications and documentation according to departmental standards.

  • 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.

  • Demonstrate effective communication skills (both verbal and written) with coworkers, clients, and project managers.

  • Design and implement performance tuning capabilities into deliverables to ensure service levels are met.

  • Provide technical leadership to SSIS developers assigned to projects.

  • Ensure design and development tasks conform to all data consolidation, data integration, data transformation, and data quality best practices.

  • Provide daytime and nighttime production support for applications.

  • Peer review code and technical documents for other team members.

  • Utilize source control software to maintain integrity of production software, including prior versions of code.

  • Follow defined Software Development Life Cycle (SDLC) and change control processes.

Leadership (30%)

  • Assist clients in a professional and accommodating manner.

  • Take a leadership role on moderately complex projects independently or as part of a larger project team.

  • Handle multiple competing initiatives and escalate issues effectively.

This role could be a good fit 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.

You'll benefit from this experience by:

  • Working in a cutting-edge data centric environment.

  • Gaining experience in a new formed and evolving Agile environment.

  • Supporting multiple lines of business serving:

  • Retired and active duty military, veterans, guard and reserves along with their families.

  • Medicare eligible beneficiaries

  • Private health insurance subscribers and their families

You need to have:

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

  • 1 or more year of related work experience

  • Bachelor's Degree in related field or equivalent post high school and/or related work experience

We also prefer:

  • 2 or more years as a Microsoft SSIS ETL Developer

  • 2 or more years utilizing Microsoft SSDT or Management Studio

  • 2 or more years using a scheduling tool such as Control-M

  • 2 or more years utilizing Microsoft SSRS or SSAS

  • Certified Business Intelligence Professional (CBIP)

  • experience with Blueprint, TFS (Team Foundation Server) and SharePoint

  • Microsoft Azure expertise

Your team:

The team consists of 8 SSIS developers, one lead, one data analyst, two Mark Logic developers and one enterprise BI architect. We support three data warehouses, four operational data stores and two cubes for internal and external customers, across all lines of business within WPS. We also support several data marts and data feeds to and from external customers.

Compensation and Benefits

  • Eligible for annual Performance Bonus Program

  • 401(k) with dollar-per-dollar match up to 6% of salary

  • Competitive paid time off

  • Health and dental insurance start DAY 1

  • Vision insurance

  • Flexible spending, dependent care, and health savings accounts

  • Short- and long-term disability, group life insurance

  • Dress for your day

  • Innovative professional and cognitive development programs

Who We Are

WPS Health Solutions is an innovator in health insurance and a worldwide leader in claims administration, serving millions of beneficiaries in the United States and abroad.

Founded in 1946, WPS offers health insurance plans for individuals, families, and seniors, and group plans for small and large businesses. We are a world-class claims processor and program administrator for the government's Medicare program. And we manage benefits for millions of active-duty and retired military personnel and their families.

WPS has been named one of the World's Most Ethical Companies by the Ethisphere Institute for 10 years in a row.

Learn more about WPS.

Our Purpose and Values

Our purpose is to make healthcare easier for those we serve. Click Here

Our values - Customer Focused, Individual Responsibility, Mutual Respect, and Driven & Passionate - are the core of who we are and how we conduct business every day.

Health Insurance

WPS Health Insurance offers high-quality health insurance plans for individuals and families, Medicare supplement plans for seniors, and group health plans for businesses of every size.

Military and Veterans Health

WPS Military and Veterans Health administers claims and provides customer service and related activities for the U.S. Department of Defense and the U.S. Department of Veterans Affairs and their beneficiaries.

Government Health Administrators

WPS Government Health Administrators manages Medicare Part A and Part B benefits for more than 7 million beneficiaries. As one of the largest contractors for the Centers for Medicare & Medicare Services, we've served Medicare beneficiaries and their health care providers since 1966.


Arise Health Plan provides innovative and high-value health plans to groups and individuals in eastern and northeastern Wisconsin. With our quality Wisconsin-based customer service, Arise offers health care expertise with a personal touch.

EPIC Specialty Benefits

EPIC Specialty Benefits provides businesses group insurance products that cover:

  • Life

  • Disability

  • Dental

  • Vision

  • Voluntary benefits

Stay connected: Sign-up for Job Alerts





icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Management Developer 1212 Deming Way (5151)

UW Health Partners

Posted 1 week ago

VIEW JOBS 5/20/2020 12:00:00 AM 2020-08-18T00:00 Join the #1 hospital in Wisconsin! We are seeking a Senior Data Management Developer to: * Partner on the creation of standards, templates, procedures, and technical frameworks for the department. * Design data warehouse workflows and mappings to extract, transform, and load data into staging areas and dimensional target tables. * Contribute to a culture of continuous learning and strong trusted-advisor relationships. Education: Minimum - Bachelor's degree in Healthcare, Information Systems, Engineering, Business, Data Science, or related field (relevant work experience may be considered in lieu of educational requirement). Preferred - Master's degree in Healthcare, Information Technology, Data Science, or related field strongly preferred. Work Experience: Minimum - Five (5) years relevant experience in the following: Full software development life cycle frameworks. Database technologies including traditional RDBMS such as Oracle and SQL Server as well as MPP appliances such as Netezza, Teradata, or Exadata. Advanced SQL coding with an emphasis on data transformation functions. Transformation tools such as Informatica PowerCenter, Microsoft SSIS, IBM Data Stage, etc. Experience in the health care field, specifically with systems such as Epic Clarity or CDW Preferred - Three (3) years of data or analytics experience. Experience in healthcare provider or payer strongly preferred. Licenses and Certifications: Preferred - Certified Data Management Professional (CDMP) -, Certified Business Intelligence Professional (CBIP) -, Certified Informatica Professional Epic Data Model or CDW Certifications. Required Skills, Knowledge, and Abilities: * Demonstrates professional standards surrounding data access, data security, data sensitivity, and data confidentiality. * Advanced verbal and written communication skills. * Advanced interpersonal relations skills, ability to effectively collaborate with others and work as part of a team. Physical Requirements: Sedentary: Ability to lift up to 10 pounds maximum and occasionally lifting and/or carrying such articles as dockets, ledgers and small tools. Although a sedentary job is defined as one, which involves sitting, a certain amount of walking and standing is often necessary in carrying out job duties. Jobs are sedentary if walking and standing are required only occasionally and other sedentary criteria are met. Work Schedule: Full-time, 40 hours per week. Monday through Friday, between the hours of 8:00 am - 5:00 pm. Hours may vary based on the operational needs of the department. UW Health Administrative Facilities - UW Health has administrative locations throughout Madison and beyond where thousands of employees provide vital support to our clinical areas. These locations are home to departments such as Access Services, Compliance, Human Resources, Information Services, Patient Medical Records, Payroll and many others. Learn more about this opening UW Medical Foundation benefits UW Health values and embraces diversity and is proud to be an Equal Employment Opportunity, Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability. UW Health Partners Madison WI

Senior ETL Developer

Wisconsin Physicians Service Insurance Corporation