Responsibilities:
• Stored procedure development and tuning Data Modeling, Analysis and Extraction / Transformation / Load (ETL) development using Microsoft SQL Server Integration Services.
• Support Development teams by reviewing their designs and stored procedures for adherence to design practices and standards.
• Assess proposed database changes for consistency, compliance and integration with data architecture standards and policies.
You will work in the following environment … (with an opportunity to be trained on some of the tools):
• Cognos: Report Studio, Transformer, Framework Manager, Analysis Studio, Metric Studio
• Microsoft SQL Server 2005/2008
• ETL
• T-SQL or SQL scripting
• Stored Procedures
• SSIS or other similar (SSRS, etc.)
• Reporting skills (examples.. SQL, Crystal Reports, Excel)