washingtondc | Enterprise Architecture/ETL in Washington, DC

Enterprise Architecture/ETL

  • Ampcus
  • $97,030.00 - 148,420.00 / Year *
  • 432 Q St NW
  • Washington, DC 20001
  • Full-Time
save job button



Needed Local Candidate Only. ESSENTIAL DUTIES The positionrsquos essential duties include the following Serve as technical team lead in the development of logicalphysical models for relational and dimensional schema Establish Master Data Management guidelines, procedures and definitions for Clientrsquos Master Data Domains Design develop, and implement Master Data Domain models Populate initial Master Data models with data from existing source data systems Ensure that data definitions and management principles are standardized and harmonized across master data domains. Ensure high data quality and limit risk of business process interruptions, while improving process and system effectiveness. Establish MDM KPIrsquos to establish transparency and performance objectives in quality, productivity and integration readiness, based on industry standards. Creates and leverages relationship with business process owners and data stewards to enable system integration and data driven planning capability Manage Clientrsquos Master Data infrastructure and components Hands on Experience with Microsoft Master Data Services. TECHNICAL EXPERIENCE Type of Experience Years of Experience Knowledge of Relational Databases 7 years Knowledge of Dimensional Databases 7 years Requirements Gathering 7 years SQL Programming 7 years Microsoft SQL Server 2005 or above 5 years Data modelling using Erwin 5 years MDM Modelling 5 years Master Data Services 4 years NOTE In addition, please list any desired experience. Development of Web servicesAPIrsquos Knowledge of ESB. Knowledge of Microsoft Biztalk Server Direct experience with Data Dictionaries and Business Glossaries SQL Server Business Intelligence Studio Visual Studio 2010 Team Foundation Server TOAD for Oracle Creating visual displays for data analysis and presentation
Associated topics: data administrator, data analyst, data center, data integration, data scientist, database, database administrator, hbase, sybase, teradata


* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.