Hi,Trust you are doing great. Currently, we have an opening for Sr. Cognos BI Developer in Location: Salt Lake city, UTAH for our direct. Position details are below. If you are interested you can email me.Title: Sr. Cognos BI DeveloperDuration: 9+Month (extension up to 5 year)Location: Salt Lake city, UTAHDuties:Download from DOPL to CHDI required data from DOPL CSD tables into flat files.Create and upload flat files into CHDI SQL Server CSD database.Apply calculations to ? identify Veterinarians, MME?s, De-dupe patients, limit prescriptions to opioid painkillers as determined by staff, etc.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.Based on requirements, design and build a view to report provider specialties.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.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 aggregateddata 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%
Thanks & Regards
Adam
[CONTACT]
