The Cognos BI Developer will work as part of a small, agile team to design and implement new features and technologies in a variety of different products throughout Quest Diagnostics. This professional will deliver high quality, high performance code in an Agile environment.
This is an on-site role, based at our new state-of-the-art corporate location in Secaucus, NJ. After-hours support and weekend on-callsupport may be required, based on business needs.
Report and dashboard development using Cognos
Create and publish Cubes.
Create Oracle SQL scripts and/or develop ETL against Oracle database (Big data) for data extraction, report development and report maintenance.
Develop , deploy and maintain frame work packages, Cognos reports ( Report Studio, Analysis Studio, Event Studio, Query Studio) and dashboards.
Maintain COGNOS servers including version upgrade, patches, bug fixes, stop and restart services on Development, Test and Production environments.
Perform migrations of reports, dashboards and packages (data models) between environments in windows Operating Systems
Develop key product features within existing large-scale enterprise applications and new strategic initiatives that will drive system and operational efficiencies, measure system performance, and provide “glue” for complex solutions.
Participate in the full SDLC involving design, implementation, testing, & launching.
Assist with the generation and analysis of business and functional requirements for proposed software solutions.
Participate in architectural and database design discussions as they relate to product direction.
Develop features completely including the front-end components and the backend systems.
Design and implement changes to systems that yield higher performance and resiliency while achieving lower operations overhead.
Own the delivery of an entire piece of a system or application, and serve as a technical lead on small to midsize complex projects.
Work closely with other engineers to develop the best technical design and approach for new product development.
Build software solutions where the problem is not well defined. Design and define the interaction between the other component pieces.
Consistently define and apply technologies, standards and software engineering practices, mentoring other team members.
Contribute to the focus and effectiveness of the development team; tracking issues to resolution, monitoring the effectiveness of tasks, and providing status to the team lead.
Raise long-term architecture issues within project.
Conduct design and code reviews of multiple projects.
Generate data for project planning, including task breakdown & estimation of work for a project. Competent in developing accurate estimates & risk assessments. Track status within the project as necessary.
Communicate team and project status to project manager and director.
May occasionally act in the Team Lead role
Act as the designated expert for owned application area(s).
Contribute to the continued improvement of the organization’s development procedures by looking for opportunities for improvement and implementing solutions.
Gather Functional and technical requirements for Reporting and Analytics.
To qualify the ideal candidate will have the following skills and experience:
5+ years professional experience in software development.
Computer Science fundamentals in object-oriented (OO) design patterns, distributed databases, and data modeling techniques.
4+ years in Cognos BI and Analytics Platform along with Cognos Administration skills (preferably in Cognos version 10.2 or above).
Experience in ETL ( IBM data stage preferred)
SQL (Oracle)and data warehousing concepts.
1+ year in Windows and Unix scripting
Excellent communication skills. Ability to work well with people and be both highly motivated and motivating.
Bachelor’s degree in Computer Science or equivalent.
Knowledge of healthcare diagnostics business.
Experience building data models for reporting and dashboarding
Working knowledge in Oracle 11g (or above), plus SQL and PL/SQL experience.
SQL performance tuning experience
ETL ( IBM Info sphere ,Data Stage preferred)