Cognos BI Analyst / Developer

This job is no longer active. View similar jobs.

POST DATE 9/8/2016
END DATE 10/8/2016

Confidential Company San Francisco, CA

Company
Confidential Company
Job Classification
Full Time
Company Ref #
29679672
AJE Ref #
576121442
Location
San Francisco, CA
Experience
Entry Level (0 - 2 years)
Job Type
Regular
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
In this role, the selected candidate will help plan and maintain the physical technical infrastructure, its configuration, performance, and storage requirements. Also responsible for administering BI tool and designing a scalable infrastructure for the BI solutions. Position: Cognos BI Analyst / Developer Position type: months, (CTH position )Start date: ASAP Location: San Francisco Preference: Local candidates Description:Responsible for the overall architecture, design and development of Cubes and Business Intelligence analytics/reporting framework and solutions. Apply and help institute best practices, methodology and standards in BI design and development to meet project requirements. Help plan and maintain the physical technical infrastructure, its configuration, performance, and storage requirements. Also responsible for administering BI tool and designing a scalable infrastructure for the BI solutions.Develop design & development specifications, metadata and documentation. Translate business requirements into BI Technical Design and coordinate with ETL developers, DBA and System Administrators, Project Managers in the development, automation and maintenance of BI Applications (including metadata framework, standard reports, dashboards, portal, documentation) and Cubes and related jobs, batch scripts, etc.,Demonstrate expertise in data modeling tools such as ERWIN, ERSTUDIO, databases such as Oracle, SQL*Server etc., dimensional databases such as TM1, Essbase, SSAS etc., BI Tools such as COGNOS (Report, Query, Analysis studios, Business Insight, TM1, Portal) , Customize COGNOS solutions (prompt page, landing page and reports) using Javascript, Ajax and SDK etc., and serve as technical expert on in-house BI solutions. Develop end user tool training materials and provide training to the users.Enhancements and Production Support: Maintain the scheduling, distribution, and refresh for reports, views, and OLAP. Provide production support for the reporting and analytic environment including: troubleshooting, new user setup, security, training, performance monitoring and documentation. Develop SQL using Databases such as Oracle/SQL*Server, BI reports/dash boards in BI tools such as COGNOS etc.to meet established service level requirements for bug fixes and enhancements. Also serve as subject matter expert and provide training for operation/BI production process.Work with application developers and computer operations to support development, test and production reporting environments including daily administration, batch processing, configuration management, environment migration, and tool automation. Knowledge, Skills and Abilities:Hands-on and proven leadership experience with aspects of the Business Intelligence development lifecycle including data profiling and analysis, data & metadata modeling & design (preferably using STAR schema approach).Solid understanding of transaction and information systems, data warehouses, data marts, ODS, MDM, BI and ETL methodologies. Technical assessment of current infrastructure, design and implementation of scalable platform to support growing demand of users and processes.Proficient in Agile/Scrum development methodology.Hands-on experience and expertise in designing and building enterprise portal, reports, dash boards and analytics with professional report building software packages such as Cognos., Also proficient with report terminology and concepts such as drill-down, roll-up, aggregation, etc. and Cognos 10 (Framework Manager, Transformer, Metrics Server, Analysis Studio, Report Studio, Query Studio, TM1, Business Insight, COGNOS Mobile). Hands on experience in writing SQL/PLSQL/TSQL code using relational databases such as Oracle, SQL*Server etc., and dimensional databases such as TM1, Essbase, SSAS etc.,Design and develop data models. Proficient in Data Modeling tools like ERWin or ER Studio.Familiarity in ETL architecture, development, process and tools such as Data Manager, Informatica etc.,.Write Technical specifications, presentations, training materials, user documentation, and technical documentation. Provide effort estimates to develop proposal for projects.Excellent verbal and written communication skills especially interacting with end users. Ability to solve problems quickly and completely.Self driven and excellent planning and execution skills with a proven ability to establish and meet impactful goals and objectives.Education/Training/ExperienceA minimum of a bachelor of science in Computer Science, CIS/MIS or equivalent degree from an accredited four year institution.Minimum 15years Business Intelligence infrastructure and applications architecture/design/build/maintain experience and developing reports, dashboards, portal using standard tools such as IBM COGNOS and heterogeneous databases such as Oracle, SQL*Server etc.,1-3years of experience working in a healthcare/education environment.Experience managing data in accordance with HIPAA compliance regulations