Category : SDV - System Developer
Location/City : FL - Boca Raton
Job Type : Direct
Id : 64240
Consultis, a premier Minority Owned Technical Recruiting Services Company with the single focus of pairing the right candidate with the right employment opportunity, is currently searching for a Cognos Developer in the Boca Raton area. This is an Extended Contract opportunity with one of our well known clients.DescriptionThe successful candidate will demonstrate 5-7 years experience in the design, development, testing, implementation and migration of COGNOS cubes and reports in Cognos 8.4 and later versions. Must have recent practical experience with Data modeling and Dimensional modeling, with a working knowledge of the star schema. Must be proficient in the use of Framework Manager/ReportNet, Report Studio, Event Studio, Oracle, SQL, DirectConnect, and demonstrated success managing DEV, TEST and PROD environments and effectively controlling migration across environments.Skills NeededAbility to troubleshoot query issues during report development using a methodical approach, including comparing the tabular data from Cognos queries with SQL queries on the database based on the reports specification.Translate business requirements into a data model and be able to convert results into a Framework Manager Model to deliver reportingCreate enterprise-wide Relational and Multidimensional data modelsDevelop and execute unit test plans to successfully deliver a projectDevelop and maintain supporting documentationScripting of SQL for investigating, researching and verifying results of queries and reportsUtilize UNIX commands to support basic functionality with files and to support the Cognos configuration and environmentOracle database architecture and terminologyAdminister the Cognos suite of productsSupport users in problem resolution including troubleshooting of operational, data and performance issuesProvide analytical and decision support for the implantation and on-going enhancement of existing reports and cubesWork well independently or as a team memberKnowledge and Experience Needed5-7 years experience with the Cognos 8.4 and later/Framework Manager/ReportNet suite of tools on UNIX as both metadata Modeler and Report DeveloperWorking with business users to design and develop correct and well-performing Cognos reports and cubes using Report Studio with data drill-down and slice & dice optionsSolid knowledge of Microsoft Excel (including advance use of Pivot Tables, Look-ups, If Statements, Macros etc) and SQL programming language a plusExperience developing and scheduling complex reports using Event Studio and applying filters, prompts and calculationsAbility to consume Relational and Multidimensional models and translate this into the development of the metadata layer in Framework Manager in conjunction with the logical and physical data modelsExtensive understanding of Multidimensional Analysis5+ years writing SQL queries to validate reports and research data in the tablesKnowledge of UNIX commands to be able to navigate directories, invoke shell scripts, move and copy filesExperience with Oracle 10g and laterUnderstand Data Warehousing best practices and associated methodologiesWorking knowledge of the different types of data stores that make up a complete Data Warehousing environment (staging, ODS, etc.)Administration of the Portal, Users, Groups, Security, etc.Excellent interpersonal, verbal, and written communication skillsUnderstand financial terminology and experienced working with the financial communityResponsibilitiesWorking with business users to model, design, develop and implement various forms of informational reporting, including the unit testing and migration of reports across environmentsSupport the business, testing and verification needs of both business user and IT users by writing SQL queriesSupport and troubleshoot the Cognos environmentQA cube and reporting deliverables for correctness and performanceEducate/mentor end users on the appropriate use of Cognos BI tool(s)Develop and maintain end user and technical documentationMeasures of PerformanceSuccessful implementation of reports and cubesBusiness users are using the published reports and cubesBusiness users are creating their own ad hoc queries and reports from the data sources providedSatisfying requirements and schedules within given resource constraintsIncreased Cognos knowledge among the organizationEducation and certificationsRelevant Bachelors Degree or equivalent experienceCognos Certification is a plusPlease apply online through Consultis? application process. This will register you into our database allowing us to better qualify and present you with opportunities. Provide as much information as possible including telephone #s, email, local address, resume, skills, availability, relocation preferences, acceptable travel percentage, salary history, work history, references and job type categories.If you experience trouble contact one of our technical recruiters at 561-750-8745.At Consultis we value our potential candidates and strive to build a lasting relationship based on hard work, trust and ethics from both sides. Consultis has made a very good name in the marketplace and is very structured in our processes. As an example, we will never send a candidate's resume to any client without that candidate's permission. It is through these processes that we achieve success for our candidates and ensure continued success for ourselves. Benefits: As a Consultis contract employee, you will enjoy fair market weekly pay, direct deposit, company-subsidized health insurance, 401k, and vacation pay. You will be part of an elite group of professionals who enjoy the most exciting contracts at the most desirable client sites.