Datawarehouse Analyst
ISSG, Inc. - Information Systems Services Group - St. Louis, MO

This job posting is no longer available on JobServe USA. Find similar jobs: Datawarehouse Analyst jobs - ISSG jobs

Identify business requirements of Datawarehouse. Plan, design, schedule and coordinate Datawarehouse analysis, design, development, and deployment. Design end user interface using available Business Intelligence tools. Develop best practices for data loading and extraction into and out of the Datawarehouse.
Responsibilities: Document source system Entity Relationship Diagrams (ERD)/Data Tables, their relationships, and their articulating processes. Support Corporate, Regional, and Health Ministry end user reporting. Application reporting to be supported would include eProcurement and Contracting. Specify changes to be made at source systems to accommodate requirements. Support system that can transform and normalize data across multiple dimensions. Use database programming languages to transform, schedule and automate transformation of the data. Use Business Intelligence Reporting Tools to create the proper roll-up and detail reports. Use of Object Oriented Programming and SQL is essential prior to use of the Business Intelligence Reporting Tool. Use variance analysis to look for usage anomalies by purchase classification. Develop alternate product classifications that can be used to analyze usage. Add categories, analyze, and create alternate scenarios that can be used by Value Analysts to negotiate. Leverage UNSPSC coding where available. Knowledge of multi-variant regression, statistics, and programming linear equations. Primary responsibilities include population of the databases with details of the purchase, invoicing, clinical, sales, savings, rebates and contract information. To accomplish the population of databases, the analyst will use the database products and reporting tools designated by the Supply Chain Technical Services Manager. Work with Group Purchasing Organization (GPO) to develop and maintain contract data download capability. This includes data synchronization in support of The Resource Group contract management system. Work with contracting management to develop data feeds required by third party vendors in support of ministry initiatives such as inventory management and audits.

Analyst should have Bachelor's Degree from an accredited college or university. A degree in Management Information Systems is with a concentration in database programming with a minor in Business. Liberal Arts graduates with advanced coursework in economics, mathematics and programming are encouraged.

Knowledge, Skills and Abilities: Data Analysis Multi-Dimensional and Variant Analysis translation to Linear Algebra Multi-variant regression analysis, time series analysis, Game and Probability Theory (contractual what-if scenario generation) Any Object Oriented language such as C++, Visual Basic, Java, SQL or PL/SQL, Database design and application, Oracle Business Intelligence reporting tools or an equivalent GUI reporting tool such as Cognos or Business Objects Ability to prioritize workload and communications Excellent interpersonal skills and ability to work with people in all disciplines and at all levels of an organization

JobServe USA - 19 months ago - save job - block
Recommended Jobs
Business Data Analyst
Ferguson Consulting, Inc - St. Louis, MO
Ferguson Consulting, Inc - 30+ days ago
Easily apply