SQL BI Developer

Description

Job Description MemberHealth has 5 SQL/SSIS Developer positions open. The candidate must have a strong SQL development background as well as some .NET development experience. They are creating two seperate teams for two different projects. The one is a Bid System project. This will be working directly with the Part D Prescription which MemberHealth must submit to the Government on an annual basis to apply for renewal. The other project is the Veroli project which is the Outbound Messaging Package. This would be creating files, receiving files, and creating reports for internal customers and must meet federal compliance.
Additional Job Info The right candidate would have a thorough understanding of how indexes work in SQL Server as well as experience with basic normalized Database concerpts, advanced SQL Server troubleshooting and tuning skills. They would also be looking for someone with good stored procedure development skills and a solid understanding of Slowly Changing Dimensions concepts. As far as SSIS, the candidate must have experience with loading and exporting files, solid understnading of diiferenct components within SSIS, good scripting skills, and somewhat of a .NET background. Data Warehouse experience and Cognos experience is a plus. MemberHealth, LLC, a prescription benefit management company, engages in the design and execution of prescription drug programs for employers, government agencies, and consumers. It offers its programs for worksite companies; professional employee organizations; companies with large segments of parttime or other groups not qualifying for group medical benefits; groups that are not offering comprehensive group medical plans; gap plans; MSA/FSA/HRA programs; companies or programs that desire to integrate the prescription data into other medical management and disease management programs; HMO's and other managed care organizations; and selfinsured prescription plans. The company also sponsors Medicare Part D prescription drug plans under the Community Care Rx brand in the United States, District of Columbia, Puerto Rico, and the U.S. Virgin Islands; and under the Community Pharmacists Care Rx brand in Oklahoma. In addition, it offers discount drug cards, a discount prescription drug plan that provides individuals with the buying power of group purchasing. The company was founded in 1998 and is headquartered in Solon, Ohio. As of September 21, 2007, MemberHealth, LLC is a subsidiary of Universal American Financial Corp.