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.
