Job Title: Cognos Developer
Location: Albany, New York
Duration: Long term contract
Job Duties and Responsibilities:
• Work with various business stakeholders to identify their information needs
• Work with Data Architecture team to understand the data models
• Work closely with cross-functional business and business intelligence teams to document reporting requirements and design documents
• Developing, adhering to, and being a proponent for Data Warehouse development standards, including Cognos/Qlikview standards and best practices
• Design and develop Cognos frameworks, ensure appropriate database views and/or tables are available to support the Framework information needs and that accurate information is presented through the framework
• Design and develop Canned Reports, Analytics packages (OLAP), Dashboards, etc., using Report Studio, Cognos Workspace Advanced and Transformer
• Provide documentation for all developed stored procedures, including process flow and source and target mapping, report design, etc.,
• Conduct performance tuning and troubleshooting of all data delivery mechanisms
• Work with database administrators to make sure that the report/analytics are tuned and optimized
• Conduct data analysis thru various database techniques, SQLs, etc., and compile results appropriately for senior/executive management/legal
• Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
• Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data
Minimum Qualifications:
• Bachelor's Degree or higher or equivalent, relevant experience
• Minimum of 5 years of experience in building various data delivery mechanisms in Business Intelligence
• Excellent understanding of navigating data warehouses and relational database structures
• Experience in writing complex SQLs to analyze and troubleshoot the issues/problems
• Strong data analysis and troubleshooting skills
• Excellent understanding of report development and data delivery
• 5+ years of experience working with Cognos (Report Studio, Workspace Advanced, Framework Manager, Transformer, etc., )
• Any experience in Qlikview/Qliksense, is a plus
• 5+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, etc.,
• 5+ years of experience in data analysis, troubleshooting, etc., by writing SQL statements and stored procedures
• Knowledge of MS-Office Suite (Word, Excel, PowerPoint
