College & Education: Urgent requirement : Data Architect : ID : 6 month : Immediate interview

Hello,
Hope you are doing well,

Please go through the following requirement and let me know on Kevin@riderconsultinginc.com if you have any available resources

Job Title: Data Architect

Duration: 6+ months

Location: Boise, ID

Residency Status: US Citizen, Green Card,EAD,H1B.

Need someone to start ASAP.
PLEASE NOTE: they need to have normalized versus dimensional data modeling experience
Also, they want someone to have Healthcare Payer experience for this role (if they don’t have it they will be put on the back burner)

Ø Prior healthcare payer experience with depth in multiple subject areas including Member, Provider, Product, Claims, Premium and Clinical.

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

Ø Develop the enterprise data architecture for operational data stores, MDM data stores, integration data stores, data warehouses, analytics hubs and data marts.

Ø Develop data modeling standards.

Ø Proficient with one or more leading data modeling tools such as Erwin, Enterprise Architect, PowerDesigner, etc.

Ø Develop the conceptual data model(s).

Ø Develop the logical data model(s).

Ø Proficient with SQL with emphasis on the SELECT statement.

Ø 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.

Ø Assist the Business Data Analyst in mapping the data from source to target.

Ø Assist the Business Data Analyst and Data Integration team with data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.

Ø Perform re-engineering of source models when necessary.

Ø Assist the Data Integration Architect to ensure the Data Architecture is applied properly.

Ø Assist the DBA in converting the logical model(s) to the physical database. Provide indexing recommendations as appropriate balancing trade-offs associated with load time and queries. Develop aggregation and table partitioning recommendations to improve performance.

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

Thanks.

Kevin Patel

Ph No:- 980-819-0687