Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Oracle SQL Server Experience SQL Dimensional Modeling ETL Administrator
(Jobs in
 
Requirement id 74793
Job title Administrator
Job location in Salt Lake City, UT
Skills required Cognos Reports Developers, Framework Manager, Oracle, SQL Server Experience SQL Dimensional Mo
Open Date 26-Oct-2018
Close Date
Job type Contract
Duration 10 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Administrator: Cognos Reports Developers, Framework Manager, Oracle, SQL Server Experience SQL Dimensional Mo

Start Date : 11/15/2018
End Date : 09/30/2019
Submission Deadline : November 1, 2018 @ 10:00 PM MDT (Utah Time)

Description :

1.1 Scope of Work

In support of the above, The Contractor will:
1. Download from DOPL to CHDI required data from DOPL CSD tables into flat files.
2. Create and upload flat files into CHDI SQL Server CSD database.
3. Apply calculations to – identify Veterinarians, MMEs, De-dupe patients, limit prescriptions to opioid painkillers as determined by staff, etc.
4. Run scripts to identify patients with – prescriptions greater than 90 MMEs, concurrent 90 MME prescriptions and a Benzo prescriptions, prescriptions with 5 or more providers and 5 or more pharmacies, etc.
5. Based on requirements, design and build a view to report provider specialties.
6. Based on requirements, design and populate a quarterly rolling six month Datamart to support a COGNOS BI Prescriber dashboard tool. Utilization and Community metrics to be defined.
7. Based on requirements, design and populate a monthly Datamart to support two COGNOS BI Community dashboard tools to provide UDOH community partners with timely access to aggregated data to determine opioid trends.

Scoring Criteria:
COGNOS Report Development and Framework Manager experience 30%
Oracle/SQL Server/Postgres experience / SQL 15%
Dimensional (Star Schema) Modeling Database experience 15%
ETL (Extract, Transform and Load) experience 10%
Cost 30%
TOTAL 100%
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 74793 while calling.
 
Other jobs in UT: Salt Lake City (2), Taylorsville (1), Unknown (5),
 
 Cognos Reports Developers job openings in other states
Jobs List

GTRI Project Manager (750699)
Create date: 01-Nov-2024
No of Submissions : 2

Start date : 12/09/2024

End Date : 06/30/2025

Submission deadline : 11/06/2024

Client Info : GTRI-Enterprise Systems Department

Note:

* Agency Interview Type :

* Web Cam Interview Only

Description :


The Senior Project Man.... (This job is for - AgileJira Jobs in GA Atlanta Manager - (in Atlanta, GA))

BI Developer - 32022
Create date: 16-Feb-2018
Client Info : Financial Industry Regulatory Authority, Inc. (FINRA)

Candidate must be our W2 Employee

Job Description :

ROLE: Business Intelligence (BI) Developer

LOCATION: Washington DC Metro

OVERVIEW: Apex Systems has an immediate need for a BI Developer to help support a variety of business .... (This job is for - SDLC Jobs in MD Rockville Developer - (in Rockville, MD))
 
 
(Administrator: Cognos Reports Developers, Framework Manager, Oracle, SQL Server Experience SQL Dimensional Mo in Salt Lake City, UT)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us