programmers.io
Data Architect
programmers.io, Dallas, Texas, United States, 75215
One of our global food client is looking for Data Architect in Dallas TXThe Data Architect is responsible for ensuring standards are followed.Perform DesignPerform Data AnalysisReviewing requirements, workshops, or working directly with a business team memberReviewing/querying various systems - familiarity with Query language - SQL/T-SQLCreate 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 DocumentationCreate 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 AssessmentsFacilitate 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.
- 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 DocumentationCreate 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 AssessmentsFacilitate 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.