MAJOR DUTIES AND RESPONSIBILITIES Primary duties may include, but are not limited to: Undertakes complex assignments requiring additional specialized technical knowledge. Develops very complex and varied strategic report applications from a Data Warehouse. Establishes and communicates common goal and direction for team. Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues. Acts as a source of direction, training and guidance for less experienced staff. Monitors project schedules and costs for own and other projects. Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables. Conducts training on use of applications developed. 　 Additional Job Description Details This position requires an analytical thinker who can translate business requirements for information/data content needs into actionable ETL source-to-target data mapping and business logic for extracting/transforming/loading source system data into a data warehouse. The primary function is to design and develop ETL code with SSIS on a SQL Server platform. Extensive experience working with SQL Server 2000/2005/2008, T-SQL scripts and stored procedures. EDUCATION/EXPERIENCE Requires a BS/BA degree; 6 years experience; or any combination of education and experience, which would provide an equivalent background. Expert level PC, spreadsheet, and database skills, as well as experience in Business Information tools and programming/query languages is also required. Ability to communicate effectively with multiple levels within the organization. This job is focused on spending time thinking about programming and how it would be used to design solutions as compared to the Bus Info Developer Consultant job.