Data Architect

One of our global food client is looking for Data Architect in Dallas TX

The Data Architect is responsible for ensuring standards are followed.

• Perform Design
• Perform Data Analysis
• Reviewing requirements, workshops, or working directly with a business team member
• Reviewing/querying various systems – familiarity with Query language – SQL/T-SQL
• Create Data Models (Logical & Physical) – (ERD – Entity Relationship Diagrams)
• Data Warehouse – Must be able to create data models with well-defined dimensions, conformed dimensions, facts, and aggregated facts. Must be able to use the Kimball methodology.
• Applications – Can create data models for new applications, and reverse engineer data models in modeling tools for existing applications.
• You will be using ER/Studio as the tool to perform this.
• Create DDL for database objects utilizing ER/Studio.
• Use Visual Studio for source control and generate scripts for deployment into database environments.
• Create Design Documents & Other Documentation
• Create Data Mappings (source, target, and transformations needed) for source to Data Warehouse.
• Create Data Mappings for Source to target systems (example: system to system integrations).
• Must understand ETL / integration development concepts and tools to make sure your designs are usable for developers.
• Create Data Dictionaries and Functional Data explanations (example: describe how data can be used to perform a function).
• Perform Assessments
• Facilitate discussions around data in new business processes/projects and identify if a new standard/pattern is required for data processes and data integrations.
• Collaborate with Enterprise Architecture, other IT teams, and the business to coordinate the analysis/assessment to gather requirements, perform analysis, present the options, and make recommendations.
• Ability to look at existing data processes within the data warehouse load or system to system integrations and suggest design improvements.
• Review Present and/or participate in design review with other Architects to confirm the design aligns with the solution requirements.
• Participate in code review with developers to confirm what is developed aligns with the design.