College & Education: Urgent requirement : Data Modeler : Rochester, NY : Long term : Immediate interview

Hello,

Hope you are doing great,

Please let me know on darshan@riderconsultinginc.com if you have any good resources for the below position mentioned.

Role: Data Modeler (HEALTHCARE /PAYOR REQUIRED)

Location: Rochester, NY

Duration: 6 Months

Start: ASAP

Interview: Phone

MUST HAVE Healthcare Payer experience from one of the following companies: Aetna, Cigna, Humana, and United Healthcare, Anthem, BCBS, Horizon, Champus/Tricare, Wellpoint, HCSC, TUFTS, Harvard Pilgrim, CDPHP, Oxford HP, Healthfirst NY & NJ, Fallon, Americhoice, NHP.

Job description:

The Data Architecture/Modeler is responsible for the detailed design of a project’s data integration component. A typical data integration design effort usually involves working with the business users to determine the specific business, transformation and standard data handling rules, developing the detailed data mappings and assisting the ETL Developers and system owners to validate the results.

Requirements:

1. Must have exp 5-7 experience developing enterprise data architecture for operational data stores, MDM data stores, integration data stores, data warehouses, analytics hubs and data marts.

Ø Perform the detailed data analysis. Verify natural keys through SQL queries against the source databases.

Ø Develop data modeling standards.

Ø Develop the conceptual data model(s) & logical data model(s).

Ø Proficient with one or more leading data modeling tools such as Erwin, Enterprise

Ø Architect, PowerDesigner, etc.

Ø Proficient with SQL with emphasis on the SELECT statement.

2. Develop entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.

Ø Identify the key facts and dimensions necessary to support the business requirements.

Ø Conduct User Interviews and Data Analysis Review meetings.

Ø Conduct sessions to review and vet the data architecture and data models.

Ø Perform source data quality assessments.

Ø Identify the appropriate data sources with the assistance of the business analyst.

Ø Perform the activities necessary to support the standardization of facts and dimensions.

Ø Prepare prototype data models to support the development efforts.

3. Assist the Business Data Analyst in mapping the data from source to target & related issues such as: assessing data quality, data consolidation, evaluating existing data sources.

4. Perform re-engineering of source models when necessary.

5. Maintain data in the metadata repository associated with the data models.

6. Must be able to interface effectively with all levels of the organization.

7. Must have excellent interpersonal skills and be strong and effective communicator

8. Good writing skills and ability to multi task in the support of this project

Thanks,

Darshan Patel