Data Warehouse Developer III (217023-004): Dean Health System

For 25 years, Dean Health Plan has dedicated itself to setting the standard for the health insurance industry and its employees. We maintain a position of leadership in insurance services through a physician-led integrated health system that improves the health of its members and delivers a superior level of service and care. Dean Health Plan has earned a place in the U.S. News & World Report list of America's Best Health Plans and received the 2008 Best of Business Award in the from Corporate Report Wisconsin.

Position Summary

Provides technical expertise and direction in developing and supporting system-level programs, interfacing with customers on requirements. The individual in this position participates in all phases of the data warehouse development cycle. The incumbent is responsible for production support and maintenance of the data warehouse, and works with the team on system performance optimization and interoperability issues.

Responsibilities

• Code, extract and summarization routines
• Code, test, and implement complex programs; develop appropriate programs and systems documentation according to established IT standards
• Lead the support and troubleshooting of production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports
• Plan, schedule, and conduct decision support system tests; monitor test results; and take required corrective action
• Develop restructure process routines; create index and view scripts
• Interface with customers to determine requirements
• Aid in systems development planning and monitoring
• Provide technical direction and training to other IT personnel
• Provide technical consultation in new systems development, new package system evaluations, and enhancement of existing systems; participate in structured walkthroughs and technical reviews

Knowledge/Skills

• Strong knowledge of ETL tools; high preference for Informatica
• Experience working in a Service Oriented Architecture (SOA)
• Strong knowledge and understanding of structured analysis and technical design techniques
• Some knowledge of database management and file access methods is desirable; experience in online analytical processing (OLAP) is a strong plus
• Strong analytical and problem-solving skills
• Strong team-oriented interpersonal and communication skills
• Solid project management skills in planning and monitoring projects in a cross-functional environment
• Ability to effectively adapt to rapidly changing technology and apply it to business needs
• Ability to establish and maintain a high level of customer trust and confidence in the enterprise analytics team's knowledge of and concern for customers' business needs
• Preference for candidates with health insurance industry experience

Requirements

• Bachelor's degree in Computer Science, Engineering, or related discipline
• Typically 7 or more years of experience in systems development and programming; preferably ETL and data warehouse
• Familiarity with line-of-business legacy systems
• Experience as a team member on project teams in a cross-functional environment

Experience in design and implementation of data warehouse required