Senior Database Analyst
Global Publicly Held Financial Services Firm based in Arlington VA  sees a full time direct hire Senior Database Analyst.  Thisindividual will participate in the development of the architecture, design, software development and implementation of data warehouseinitiatives for the company. Responsibilities:Understand the core data concepts behind IT initiatives Evaluate and understand how the data is used across all of Carlyle in different functional areas Develop, review, and provide design oversight on all data movement efforts at Carlyle to ensure data standard compliance and dataquality Understand Data Warehouse design principles and best practices to support enterprise reporting concepts and initiatives Understand Master Data Management principles and its role in managing and defining enterprise data elements and how it interacts with the Enterprise Data Warehouse Work closely with report developers to review and provide design oversight on key report data structures to ensure consistent representation of data across the enterprise Ensure best practices for: Database and code change managementAutomated database deployment and structured code deployment Agile solution development methodology Develop and execute test strategies for data validation of complex warehouse data loading, transformation and extraction processes Write and execute queries in data warehouse and traditional online transactional processing databases to retrieve data needed for testing and validation Develop, implement, publish, and support quality assurance standards and test plansWork with Data Architects to securely collect, cleanse, standardize, transform, and store data elements from source systems per program scope Define and implement security and data collection standard Create and execute data analysis programs involving cleansing, standardization, and structural transformation Recommend data management techniques Document all data files received and all transformations executed. Data analysis in support of business data requirements definition, user acceptance testing and training activities Gather, validate and document data requirements down to the column level, in direct support of business requirements and priorities for defined subject areas Identification of data sources for the required data attributes Creating data mappings to document data movement from data sources to data targets, including identification and documentation of datatransformation algorithms as necessary Identify and document data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes Help drive enforcement of Data Steward data entity definitions Maintain current knowledge of data relationships and system interfaces Assist in knowledge transfer to other technical staff members on business data processes Assist in on-going evaluation of current and new business data requirements to achieve higher operational efficiencies and projectportfolio alignment Evaluate potential expansion projects, provide data requirements and design for new releases, as necessary Contribute to the Information Delivery Center of Excellence (COE) by developing and documenting best practices 
Title: Senior Database Analyst
Salary: 120000-125000
Description: Global Publicly Held Financial Services Firm based in Arlington VA  sees a full time direct hire Senior Database Analyst.  Thisindividual will participate in the development of the architecture, design, software development and implementation of data warehouseinitiatives for the company. Responsibilities:Understand the core data concepts behind IT initiatives Evaluate and understand how the data is used across all of Carlyle in different functional areas Develop, review, and provide design oversight on all data movement efforts at Carlyle to ensure data standard compliance and dataquality Understand Data Warehouse design principles and best practices to support enterprise reporting concepts and initiatives Understand Master Data Management principles and its role in managing and defining enterprise data elements and how it interacts with the Enterprise Data Warehouse Work closely with report developers to review and provide design oversight on key report data structures to ensure consistent representation of data across the enterprise Ensure best practices for: Database and code change managementAutomated database deployment and structured code deployment Agile solution development methodology Develop and execute test strategies for data validation of complex warehouse data loading, transformation and extraction processes Write and execute queries in data warehouse and traditional online transactional processing databases to retrieve data needed for testing and validation Develop, implement, publish, and support quality assurance standards and test plansWork with Data Architects to securely collect, cleanse, standardize, transform, and store data elements from source systems per program scope Define and implement security and data collection standard Create and execute data analysis programs involving cleansing, standardization, and structural transformation Recommend data management techniques Document all data files received and all transformations executed. Data analysis in support of business data requirements definition, user acceptance testing and training activities Gather, validate and document data requirements down to the column level, in direct support of business requirements and priorities for defined subject areas Identification of data sources for the required data attributes Creating data mappings to document data movement from data sources to data targets, including identification and documentation of datatransformation algorithms as necessary Identify and document data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes Help drive enforcement of Data Steward data entity definitions Maintain current knowledge of data relationships and system interfaces Assist in knowledge transfer to other technical staff members on business data processes Assist in on-going evaluation of current and new business data requirements to achieve higher operational efficiencies and projectportfolio alignment Evaluate potential expansion projects, provide data requirements and design for new releases, as necessary Contribute to the Information Delivery Center of Excellence (COE) by developing and documenting best practices 
Requirements: Mid-Senior level experience, Bachelor's Degree education
Fraudulent: No