Interface with sponsoring business units, IT and third party developers through the product development and testing process to ensure the delivery of error free business intelligence applications.
Develop new and support existing Cognos BI reporting solutions to include reports and framework manager models.
Write and maintain technical specifications that describe program development, data modeling, coding, testing, changes and corrections.
Provide technical assistance and analysis with troubleshooting reports and data models by effectively responding to inquiries and questions.
Interact with assigned business analysts and project manager to ensure an accurate and comprehensive understanding of data and reporting requirements.
Ensure timely and thorough issue escalation and resolution as well as strict adherence to all project milestones and deadlines.
Serve as the Cognos subject matter expert during all applicable product implementations and bug fixes.
Work in conjunction with the quality assurance team to create and/or validate system acceptance and user acceptance test plans and test scripts to ensure error free delivery of tools and reports as required.
Thoroughly walkthrough applicable functional requirements and prototype designs with appropriate staff to ensure they accurately reflect business needs and needed capabilities.
Effectively interface, support and report to the project manager for all assigned projects.
Provide project status updates and reports to senior leadership as required.
Other duties as assigned.
Candidate Skill Set
Bachelor’s Degree in information technology, computer science, business administration, or a related field.
4 -7 years experience working with Cognos Business Intelligence Suite in a data warehouse/mart environment.
Full life cycle experience of designing and developing Cognos 8 BI solution together with a complete understanding of data warehousebusiness intelligence development lifecycle.
Four years of professional experience in data modeling using Cognos 8 BI Framework Manager.
Two years of extensive Cognos BI report development experience.
Must have demonstrated experience in the creation of complex data models using framework manager, complex reports and dashboard style solutions using Cognos 8 Series.
Must have strong SQL writing and programming skills, preferably in SQL Server environment.
Must have sound understanding and foundation of both relational and dimensional modeling techniques.
Must have demonstrated experience in the creation of requirements and design documents, technical specifications.
Must be able to shift priorities and demonstrate the ability to meet urgent operational deadlines.
Must exhibit excellent interpersonal, written and oral communication skills. Must be a motivated team player committed to working toward departmental and organizational goals.
Must be flexible and adaptable in regards to learning and understanding new technologies.
Previous experience working with healthcare related data model andor standards will be a great plus.
Experience in ETL development using TSQL, SSIS and/or other ETL development tools are desirable.
Experience with Microsoft SQL Server Analysis Services and MDX desirable.
Previous experience working in a web technology position, with a working knowledge of Visual Basic, C#, HTML, XML, Java script, SQL and .net technology a plus.