Forrester Research is hiring for a Data Warehouse Developer/Architect.

Job Title	Data Warehouse Developer/Architect
Primary Location	Cambridge, MA
Employment Type	Regular Full Time

Forrester Research, Inc. (Nasdaq: FORR) is an independent research company that provides pragmatic and forward-thinking advice to global leaders in business and technology. Forrester works with professionals in 19 key roles at major companies providing proprietary research, consumer insight, consulting, events, and peer-to-peer executive programs. For more than 25 years, Forrester has been making IT, marketing, and technology industry leaders successful every day. For more information, visit www.forrester.com. Data Warehouse Developer/Architect FLSA Status: Exempt Location: Cambridge, MA Job description: This position is part of the business applications group in the corporate information technology department and reports to the data warehouse manager. The Data Warehouse Architect’s role is to design and implement data warehouse solutions while ensuring high levels of data availability and accuracy. This individual is also responsible for defining data standards and models for warehouse architectures. The ideal candidate is a service-oriented team player who thrives in a fast paced, fluid environment. Responsibilities: - Design, implement, and deploy complex data models (relational and dimensional) to support business initiatives using Cognos Framework Manager. - Develop, publish, and deploy analysis cubes according to business requirements. - Develop and deploy reports according to user requirements. - Identify inefficiencies and gaps in current data warehouses, and leverage solutions. - Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity. - Diagnose and resolve Cognos application access and performance issues, including individual reports. - Develop and maintain relevant documentation to ensure consistent and up-to-date content. - Coordinate and work with other technical staff to develop and enforce quality assurance policies and procedures. - Contribute to the research and selection of data warehouse products, services, protocols, and standards in support of development efforts. - Provide second-tier user support for business authors and report consumers. - Assist with the scheduling, distribution, bursting, and refreshing of corporate reports. Requirements: - Bachelor's degree in computer science or related field required - At least six years experience in design and development using Cognos BI platform, Business Intelligence Series 8 tools, Framework Manager, Report Studio, Query studio, etc. - Four or more years experience in data architecture and modeling -- dimensional databases, normalized versus denormalized data, trending data capture techniques, etc. - Experience with Cognos Analysis Studio required - Experience with Metric Studio and Event Studio desirable. - Strong SQL/PLSQL knowledge required - Excellent technical support documentation skills - Ability to effectively prioritize and execute tasks in a high-pressure environment - Experience working in a team-oriented, collaborative environment - Excellent verbal and written communication skill Forrester Research is an equal opportunity/affirmative action employer; M/F/D/V are especially encouraged to apply. contact BI Centre for more information

Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...Be s...

Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...

Be s...: "Cognos 8 Diagnostic tools are coming soon... Be sure to visit: http://bicentre.blogspot.com/ http://bicentresdkguide.blogspot.com/ http:..."

BI Architect

No third party submittals
US citizen or permanent resident only.

Position Description:

Work as part of an agile Datawarehouse team. Responsible for the design and development of reporting and analytics capabilities utilizing the Cognos reporting suite.

Responsibilities:

• Ability to understand and articulate complex business BI requirements
• Experience building complex reports, dashboards, and scorecards
• Experience analyzing data and interpreting results
• Knowledge of OLAP analysis and cube development
• Ability to analyze and develop reporting systems architecture
• Logical data modeling experience
• General database knowledge and expertise in SQL

Required Skills, Knowledge and Experience:

• Expertise in developing Cognos 8 Framework Manager models
• Expertise in developing complex Cognos 8 reports and dashboards in Report Studio and Analysis Studio

Preferred Skills, Knowledge and Experience:

• Experience in ETL development and scripting.
• Experience with Teradata.
• Cognos Advanced or Master level certification preferred.

--
BI CENTRE
http://bicentre.blogspot.com

Cognos Lead

DESCRIPTION

A Cognos Lead is needed to join a Datawarehouse project team to for administration, support and enhancement of the Datawarehouse Cognos 7.3 environment. Duties will include administration, analysis, troubleshooting, and enhancing existing reports, cubes and catalogs or developing new ones on Cognos. The Systems Analyst will work with the rest of the technical team to understand the current Cognos 7 objects, administer and support them on a daily basis, and prepare and develop any required enhancements. An upgrade to Cognos 8 may happen during the course of the assignment and this Cognos Lead may become the support person for the Cognos 8 environment.

Qualifications:

• Experience on Impromptu, Powerplay, Access Manager and IWR and PPES server administration tools, are MUST
• Bachelor's degree and 6+ years of formal IT development/systems configuration experience
• Experience with Datawarehouse report definition and distribution, cube generation, bursting and security processes
• Experience with Cognos series 7 server configuration including Transformer, Powerplay Enterprise Server and Access Manager
• Experience with report development using Powerplay and Impromptu
• Experience with Cognos 7 Server Administration tools
• Experience on multi-server Cognos install preferred
• Knowledge of VBA scripting, Cognos script and C# preferred
• Experience writing complex queries on Oracle database
• Knowledge of Data warehouse interface tools including Informatica
• Knowledge of Access database preferred
• Ability to follow the documented instructions and work/resolve independently
• Change management experience required - IT control practices, organizational change, technology adoption

SKILLS

Cognos Series 7 Server, Transformer, Impromptu, Powerplay, Access Manager, IWR, PPES, Oracle Database, VBA Script, Cognos Script, C#, MS Access

--
BI CENTRE
http://bicentre.blogspot.com