SQL Data Modeling Tools Communication Skills IT Professional Niche Modeler (Job   Requirement id 55290 Job title Modeler Job location in Southlake, TX Skills required DDL And DML Via Command Line Tools (OSQL Etc., Data Warehouse, ETL Tools, SQL Data Modeling Tools Communication Sk Open Date 01-Aug-2016 Close Date Job type Contract Duration 11 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Modeler: DDL And DML Via Command Line Tools (OSQL Etc., Data Warehouse, ETL Tools, SQL Data Modeling Tools Communication Sk Start Date :08/10/2016 End Date :07/01/2017 Submission Deadline :08/01/2016 Description : Essential Duties and Responsibilities: Organize working sessions with business/dev teams to understand sources of data and expected output. Determine database structural requirements by analyzing operations, applications, review objectives with stake holders and evaluate current systems Develop database solutions by designing proposed system, defining database physical structure and functional capabilities and data security requirements. Develop flowcharts and documentation Apply optimum access techniques Coordinate DDL and DML actions Maintain database performance by identifying and resolving production and application development problems along with data integration Install new releases, complete maintenance; answer any user questions. Prepare users by conducting training. Accomplish information systems and organization mission by completing related results as needed. Lead the data migration team to capture the current state of source databases, define the architect for target state and design the target data model Lead the integration efforts with other work streams to realize the common goal of designing the target state architecture Develops and validates data modeling solution Responsible for analyzing and designing the process to capture the data lineage from source to target Advise the implementation teams on the interpretation of proposed and final rules and rule requirements Understand and drive resolution of complex issues Define standards for naming, describing, governing, managing, modeling, cleansing, and enriching Collaborate directly the with Data Warehouse Enterprise Architect to build conformed models across multiple Data Warehouses Experience, Skills and Knowledge: 8+ years proven data or integration architecture experience 10+ years overall IT experience Must have 5+ years of experience in database technologies, data design and performance optimization for large OLAP, Columnar DBs & Data Warehouse solutions. Must have very sound understanding of data access technologies, frameworks and patterns. Expert in relational and dimensional structures for large (multi-terabyte) operational, analytical, warehouse and BI systems Skilled in data profiling, business domain modeling, logical data modeling, physical relational data modeling and design Strong skills in Entity Relationship Modeling (ERWin modeling software preferred) Proven expertise in data analysis and facilitation; i.e. able to produce data designs using a variety of inputs such as requirements analysis, SME interviews, business process, data flow analysis, data profiling, etc. Excellent written and verbal communication skills with strong relationship building skills Ability to work in a large, complex business and technical environment Experience with enterprise integration patterns, master data management, schema development, ETL architecture and ETL tools is desirable Experience with Insurance and/or Claims Data preferable Experience with Erwin or similar data modeling tool Strong SQL expertise is a must   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 55290 while calling.   Other jobs in TX: Austin (21), Dallas (32), Fort Worth (30), Ft Worth (1), Grand Prairie (1), Houston (12), Hunstville (2), Huntsville (1), Irving (3), Plano (4), San Antonio (9), Woodlands (1),         (Modeler: DDL And DML Via Command Line Tools (OSQL Etc., Data Warehouse, ETL Tools, SQL Data Modeling Tools Communication Sk in Southlake, TX)

Featured Jobs Process Consultant (Jobs in Denver, Colorado) Agile Stakeholders Manager (Jobs in Glen Allen, Virginia) Data Warehousing Manager (Jobs in Madison, Wisconsin) Help Desk SCSM Manager (Jobs in Columbia, South Carolina) IT Project Management Risk Consultant (Jobs in Lansing, Michigan) Node.Js Engineer (Jobs in Durham, North Carolina) Spark Azure Engineer (Jobs in Richmond, Virginia) Strong Manager (Jobs in Raleigh, North Carolina) SQL Consultant (Jobs in Raleigh, North Carolina) SHARE Analyst (Jobs in PETERSBURG, Virginia)