Job Description :
Position: Cognos Developer
Location: Albany, NY
Duration: 12+ Months
Interview: Phone then Skype


Here''s where you come in:
You will work on a small dynamic team that provides strategic know how through Business Intelligence (BI) and Data Visualization platforms to deliver quality reports for State & Federal Agencies.
Here’s what You’ll Do:
Analyze – Apply an understanding of business metrics and a commercial mindset to perform trend analysis, and review.
Collaborate – Work closely with functional teams to understand requirements regarding solutions to ensure data quality. Collaborate on definition, development, and maintenance of standards and processes.
Design – Develop models and create templates to ensure timely and accurate deliverables, data integrity, efficient workflow, reusability, and automation. Create dashboards using workspace advance to facilitate drill up/down and slicing/dicing of data. Produce AdHoc reports with a turnaround time based on business needs.
Improve – Support continuous improvement and automation in BI solutions and processes.
Leverage – Support client data exchange and integration needs by leveraging technical expertise in database applications, ETL processes, and automation. Apply knowledge of upstream and downstream Enterprise applications to support dashboard development lifecycle discipline.
Here’s what You’ll Bring to the Table:
Education/Experience
· Bachelor’s degree in Business, Computer Science, Mathematics, Engineering, or related discipline
· Six (6) year’s of experience in the IT industry
Business Intelligence and Reporting
· Hands on experience installing and configuring Cognos on Linux.
· Strong understanding of OLAP business intelligence applications
· Strong understanding of reporting and database environments, processes, and associated applications
· Knowledge of logical and physical data modelling concepts.
· Ability to translate business requirements into specifications that will be used to implement required reports and dashboards
Tools
· Minimum of five years experience with Cognos.
· Good working experience in Cognos 11.x dashboard, data modules and data sets.
· 5 years experience in framework manager, transformer, Query studio, Reporting studio etc.
· Knowledge of RTC or similar tools
· Competencies in database architectures such as relative, star and snowflake schemas.
· Competencies in DB2 (or other RDBMS)
· Understanding of Cognos BI OLAP Architecture and Administration.
Languages
· Experience with Level 3 Procedural Languages (i.e.: ANSI, SQL, PL/SQL)
· Experience writing complex SQL queries, SQL PL procedures in IBM DB2 environment.
Environment
· Two (2) years Healthcare Industry experience
· Competencies with UNIX/LINUX operating systems
Here are the Bonus Points:
· Experience with IBM Cognos Business Intelligence 10.0 suite of tools or higher .
· Minimum 1 years experience with Cognos Analytics 11.x.
· Proven ability to independently champion business intelligence principles with business owners, application owners, data analysts and DBAs
· Expertise with tuning Cognos BI OLAP components for faster access and performance.
· Hands-on experience with data architecture and data analysis skill sets
· Strong analytical, problem solving and communication skills, including mapping of business need or issue to development of application requirements or procedural initiatives.
· Strong understanding of reporting and database environments, processes, and associated applications.
· Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities
· Proven ability to ensure effective forms of documentation essential for support of overall technical and user needs.
· Familiarity with PMI standards and practice
· Experience authoring and maintaining reports using the IBM Cognos Business Intelligence 10.0 suite of tools or higher against relational, dimensional, and transactional databases
· Ability to work in complex matrix organization
· Good written and oral communication skills
Here are the Attributes for Success:
· Track record in business reporting, and an analytical environment.
· Well-developed ability to turn data into business information and concisely articulate performance improvements and enhancements.
· Hands on. Passionate. Persistent. Creative. A Doer. A Team Player.