Financial Data Warehouse Analyst Job Posting



Job Title: Financial Data Warehouse Analyst
Job ID: 9476
Company: InfoGroup Northwest Inc.
Position Type: Permanent
Pay Rate: DOE
Skills: Financial, Datawarehouse, Analyst, Cognos, Oracle EBS, PL/SQL, PMP
Date Posted: Feb-05-10

Title: Financial Data Warehouse Analyst
Job ID: 9476
Location: Portland, OR
Contract: Direct Hire

Infogroup Northwest is a premier IT Staffing Firm for some of Portland's top Mid Sized and Fortune 500 companies. We have been voted by the Business Journal as one of Portland's Top Staffing Firms for 2009. Infogroup Northwest specializes in placing top IT talent in direct hire, contract and contract to hire employment opportunities. Infogroup Northwest is proud to offer Medical, Dental, and Vision Benefits where we cover 100% of the monthly premium for working consultants.

This position is responsible for developing, implementing and maintaining a variety of methods for reporting on and accessing information in the financials data warehouse. This work ensures that the information assets of the enterprise are leveraged to enhance financial and operational decision-making, therefore ensuring competitive business advantages. This position is responsible for implementing information technology solutions that allow users to appropriately generate timely, accurate and comprehensive information for managing our business.

This position will be responsible for ensuring that information in both vendor-supplied data warehouse systems (Cognos, Discoverer) and our proprietary systems (notably data warehouses from departmental systems) are available to line-of-business and users.

The Incumbent will observe due care, objectivity and respect for confidentiality. All employees must keep confidential what they hear and what they see when handling, reviewing, or observing: communications and records thereof (calls, email, pages, fax, etc.), data transmission, databases, or other forms of information. Confidentiality extends to the identities of the parties of the communications, and even to the fact that the communication took place. When sharing information, consider whether the recipient has a true “business need to know.”

ITG employees are responsible for the security of our technology. In exercising their duties, ITG employees must follow security directives, incorporating security measures in the delivery of their everyday tasks, and are required to report security concerns to the ITG Security Engineering team.

Key Responsibilities & Performance Standards
• Work with data warehouse architects, line of-business analysts and users to gather requirements for and design Cognos meta-data and/or reports. Provide complete and consistent documentation of the Oracle EBS Financial modules in terms of module functionality; associated business processes and potential process improvements; and data availability, structures and relationships.
• Work with data warehouse architects, line of-business analysts and users to gather requirements for and provide input into the design of Cognos meta-data and/or reports. Provide complete and consistent documentation of the financial and budgeting data warehouse and ensure that users can determine what data is available in the warehouse, how this data is defined, how to access reports and information, how key metrics are defined and analysis is performed, and standards for the presentation and use of information.
• Recommend changes to the data warehouse to accommodate business needs. Work with data warehouse developers, line-of-business analysts and users to define data structures that support and enhance information access.
• Report Creation: Create reports using the Cognos reporting tools as needed. Use the knowledge gained by working with the customers and through prior experience to analyze data in Oracle EBS database and, potentially, Kbace and SRC databases in order to meet reporting requirements.
• Validate Data in the Data Warehouse: Provide support to data warehouse developers, line-of-business analysts and users to validate data in the data warehouse. Investigate and report on problems and work to ensure the validity of the data warehouse.
• Attend classes, seminars and other training forums as appropriate and as directed by supervisor.

Qualifications Required
Education:

Bachelor's degree in business or computer science or related field and six years work related experience in the information technology field;
OR
Associate's degree in business or computer science or related field and seven years work related experience in the information technology field;
OR
Eight years work related experience in the information technology field;
OR
Equivalent combination of education and experience where one year of experience will be substituted for an Associate's degree and two years of experience will be substituted for a Bachelor's degree.

Experience:
• Minimum three years of business analyst experience with Oracle EBS financial modules.
• Experience leading requirements gathering sessions and documenting associated business requirements for large-scale IT projects.
• Experience planning and managing projects.
• Minimum three years working in relational databases.
• Experience developing at an academic medical center or healthcare related organization.
• Two or more years experience with Cognos products.


Job Related Knowledge, Skills and Abilities (Competencies):
• Knowledge of Oracle EBS financial data and related databases and processes.
• Ability to read, write and maintain basic SQL code.
• Two years experience with Oracle PL/SQL coding and tuning.
• Knowledge of data warehousing architecture.

Registrations, Certifications and/or Licenses:
Prefer Project Management Professional (PMP) certification from the Project Management Institute.

• Must be able to pass a drug screen and/or background check.


TO APPLY, please send a word version resume to, shannonj@infogroupnw.com
_________________________________________________________________

InfoGroup Northwest Awards:

* Portland Business Journal - Top 25 Staffing Firms, 2008 & 2009
* Oregon's Top 100 Best Companies to Work For - 3 years running
* Oregon's Top 100 Fastest-Growing Private Companies, 2003 & 2004
* Oregon Business Journal - Top 10 Tech Companies, 2004

Refer a Consultant -- Receive a $1000
Visit: http://www.infogroupnw.com/referrals.php

To view other InfoGroup Northwest opportunities
Visit:
http://www.infogroupnw.com/career.php

Location: US-OR-Portland
Telecommute: No (Onsite Position)
Contact Name: Shannon Jones
Contact Phone:
Contact Email: shannonj@infogroupnw.com