User avatar
$40 - $60 Per Hour
Albany, New York, United States
6 months ago
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
$40 - $60 Per Hour