Enterprise Data Architect With Integrations BackgroundLocation: Washington DC (100% onsite – no flexibility)Duration: Contract/FulltimeJob Description:ResponsibilitiesMinimum 12+ years overall IT experience.Five (5) to ten (10) years of experience developing complex data integrations. Three (3) or more years of experience with integrationsFive (5) to ten (10) years of experience designing complex data architectures for analytics and reporting.Advanced analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.Integrates new systems with existing warehouse structure and refines system performance and functionality; develops strategies for enterprise data management and data governance.Provide architecture and technology leadership across the data lifecycle tools and services - ingest, prepare, analyze, archive, retire - utilizing AWS services and other COTS and open-source tools5+ years’ experience with relational and non-relational databases5+ years’ experience building enterprise-wide transactional applicationsExperience with AWS Redshift, and Pentaho Data Integrator/ETL toolsDeep understanding of industry patterns for application architecture and integration and experience managing data qualityAbility to come up with a detailed architecture that includes infra, security, disaster recovery/BCP plansDemonstrated significant experience migrating data from legacy applications to new system solutions and keeping the data accessed by both and in sync throughout a phased migrationExperience in data transformations, migration, statistical analysis, and troubleshooting across PlatformsGood written and verbal communication skills with the ability to present technical detailsTranslate business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.Write clear, detailed, concise documentation - architecture diagrams, reference architecture, data flows, data models (Conceptual, logical and physical), design, and implementation plan.RequiredAbility to represent relevant information in abstract models.Critical thinking skills and attention to detail.Familiarity with highly complex data quality and governance issues and requirements.Advanced knowledge of data management systems, practices and standards.Familiarity with Systems Development Life Cycle and data quality assurance.Experience applying modern data management frameworks and methods.Experience in data integration and the specification of data services.Familiarity with highly complex logical data design and data mapping or data conversion.In depth experience with SQL programming in relational and/or non-relational database management systems such as Oracle, SQL Server, AWS Redshift, HP Vertica and MySQL.