For 25 years, Dean Health Plan has dedicated itself to setting the standard for the health care 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. If you have the passion and drive to set the standard for our next 25 years, this might be the opportunity for you!

Position Summary

The Data Warehouse/Integration Developer 2 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
• Support and troubleshoot production systems with the assistance of senior team members 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 consultation in new systems development, new package system evaluations, and enhancement of existing systems; participate in structured walkthroughs and technical reviews

Skills and Knowledge:

• Knowledge of extract tools (e.g., Informatica, ETL), SQL, PL/SQL
• 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
• Clear understanding of project management methodology 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

Requirements:

• Bachelor's degree in Computer Science, Engineering, or related discipline
• Minimum 4 + years of experience in systems development and programming
• 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

At Dean Health Plan, our rewards go beyond your paycheck. Our competitive benefits package also includes programs and services that will make your life and work more enjoyable and rewarding.  Here is a snapshot of some of what we have to offer for our full time employees.

Insurance/Retirement:  Comprehensive health and dental insurance plan that includes domestic partner coverage and limited out-of-pocket expenses; life insurance; long term and short term disability insurance; flexible spending account; 401(k) with a ROTH option; retirement and profit sharing programs

Other Benefits:  Generous paid time off accrual; tuition reimbursement and continuing education program; Dean University corporate training programs; flexible/alternative scheduling options; employee led health and wellness and social committees.

Dean Health Plan is proud to be an Equal Opportunity and Affirmative Action employer.