Job Details
back

 

Job Title:
BI Analyst
Skill Set:
Cognos and/or Business Objects, SQL, BRIO, Hyperion, MS Suite of products
Date Posted:
09-12-2011
Job id:
ESPI000089

 

Job Description

The purpose of this position is to fill the need of liaison between the databases and the needs and requirements of the business unit. The liaison function is performed by interrogating various databases through the use of various queries and reporting tools. This position also provides training and support to business users performing data queries and using the reporting tools. This position will function as an integral part of the Business Intelligence Competency Center, predominantly in a content generation (report authoring) capacity.

MAJOR JOB FUNCTIONS1. Develops, codes, and tests queries and reports based on user specified criteria against various databases. Creates and performs queries and reports on both an ad hoc basis and according to predetermined schedules using the BI suite of products to design accurate and appropriate reports that are sustainable and useful. 2. Develops the scope and design of reports by working closely with the business unit and project managers. Applies comprehensive business knowledge and thorough understanding of database structure and BI capabilities to filter and guide business users requests.3. Works with IT application developers, database analyst, and other Business Intelligence Competency Center resources to ensure report design meshes with the companys business intelligence capacity and needs. Determines whether requested data resides in the databases and recommends additions of data or new categorical variables to meet user needs. Works with the Application delivery team to facilitate updates to data extract programs to accommodate the population of data into the respective databases. Assists the Database Analysts in defining, creating, and maintaining the data dictionary, and in providing end users access to the data dictionary.4. Partners with business users to implement business/functional design and to ensure quality report development that meet business/functional requirements.5. Provides training to internal and external users on the BI applications and provides help desk functionality in support of the BI application. Works with business users to help them understand the data types and structures contained within various databases. Assists users in designs that maximize optimum query performance.6. Researches and resolves variances and inconsistencies in information by conducting initial investigation of source system and developing appropriate resolutions. 7. Provide backup as needed to other members of the division.WORKING CONDITIONSMinimal local and overnight travel may be required. Overtime may be required to fulfill the objectives of the position.

Previous business requirements gathering and experience at estimating projects is strongly preferred. Ability to document detailed and specific information is highly preferred.Experience with Cognos and/or Business Objects, SQL, BRIO, Hyperion, MS Suite of products. Must be knowledgeable about relational database concepts. CORE COMPETENCIESAnalytical Thinking Conceptual ThinkingDrive to Excel Flexibility and ChangeHolds Self and Others Accountable Mature Self-ConfidenceUnderstands and Influences Others Customer Service OrientationCommunicates Effectively Teamwork and CollaborationAttention to Detail Pattern Recognition.

 

 

EQUAL OPPORTUNITY EMPLOYMENT

Evolution Solutions is an Equal Opportunity Employer. As an Equal Opportunity Employer, we do not discriminate on the basis of race, color, religion, national origin, sex, age, marital status, disability or veteran status. It is our goal to make employment decisions that further the principle of equal employment opportunity by utilizing objective standards based upon an individual's qualifications for a specific job opening.