-SSIS and SQL development as well as Maintenance and Support
-Maintains information policies and procedures to support current and future data information needs.
-Ensures proper data definitions, ownership, use and integrity of data.
-Facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.
-Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues.
-Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.
-STRONG SKILLS IN SSIS AND SQL are the most important!
-Knows ins and outs and techniques of SSIS and SQL
-Knows stored procedures, functions, and data modeling
-Someone who is an expert at process and will ask questions if design flaws exist
**Strong UNIT TESTING to unit test their work before it goes to Change management for system testing
-Extensive experience with SQL Server 2005 T-SQL and stored procedures required. (6 years)
-Experience with Microsoft SSIS required. (2 - 3 years)
-Requires BA/BS in related field and 6-8 years experience in data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background.
-Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required.
-Excellent analytical, problem-solving and PC skills required.
-Excellent oral and written communication skills required.
-Experience with large Data Warehouses and Data Marts preferred.