Senior ETL Developer at WPS Health Solutions in Houston, Texas

Posted in Other 8 days ago.

Job Description:


Senior ETL Developer

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

Role Summary:

The Senior 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:

  • Private health insurance subscribers and their families.

  • Medicare eligible beneficiaries.

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

  • 2 or more years working in Data Warehousing roles

  • Dynamic SSIS Framework development

  • Certified Business Intelligence Professional (CBIP)

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

  • Microsoft Azure expertise

This role is open to considering 100% remote work the following approved states:
Approved States: Arizona, Colorado, Florida, Georgia, Illinois, Indiana, Iowa, Michigan, Minnesota, Missouri, Nebraska, New Jersey, North Carolina, North Dakota, South Carolina, Texas, Virginia, Wisconsin

Your team:

The team consists of 8 SSIS developers, two leads and one data analyst. 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.

WPS Health Plan
WPS Health Plan offers Health Maintenance Organization and Point-of-Service plans to the group and individual markets in eastern and north-central Wisconsin, plus third-party administrator services.

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





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)