Data Architect at Fargo

Job Description

Position: Data Architect
Locations: Fargo, ND
Type of Contract: Contract-8-10 Weeks
Salary: $90 - $100/hour
Job Description: Data Architect needed for MID-January

• 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, and analytics hubs and data marts.
• Develop data modeling standards.
• 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.
• 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 Client.
• 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.

Required Skills:

• Prior healthcare payer experience with depth in multiple subject areas including Member, Provider, Product, Claims, Premium and Clinical.
• Proficient with SQL with emphasis on the SELECT statement

Bonus Skills/Soft Skills:

• Teamwork
• Proven experience in a collaborative environment
• In the Fargo Area

Job Requirements

 
Country: USA, State: North Dakota, City: Fargo, Company: ConsultNet.