Job Description :
Data Modeler
Sacramento, CA
6-12 months
Rate: $45-50 / hr On C2C
Required:
Revamp the data warehouse and transactional database models where proper modeling in needed. These DB and DW tables are specifically used for data extracts which are being sent to different external entities. This work includes proposing a better model/design, creating PK, FK, UK and normalization. Etc.
Create proper database level documentation for the Meta data which includes tables columns, triggers, procedure level comments etc.
Create Data flow visual maps for data extracts processes. There are around 40+ data extract processes where the data is shared with external government entities.
Develop business rules, data validation and quality assurance plan for each of the data extract.
This task will include communication with DW team, IS database developers, BI team and other senior reps from different WHA departments.
Excellent DB modeling skills including PL-SQL, Functions, Procedures
MS Visio, Oracle and SQL Server experience.