Database Analyst​/SQL DBA

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Description:

• This position is within our Enterprise Data & Analytics/Credit Risk Management Production Support Data Quality and Metrics team and provides support of critical month-end data loads data quality initiatives that support to the data mart, which is used by the Credit Risk Management business unit for CAR, CCAR (Comprehensive Capital Analysis Review) and BASEL regulatory reporting, as well as other business critical reporting needs.
• This position will play a senior lead role ensuring proper implementation of data quality during the creation and modification of data, according to data quality standards, guidelines, metrics and quality-expectations.
• Defines rules to evaluate data quality and creates effective test plans.
• Ensures accuracy, completeness, integrity, consistency, uniqueness and timeliness of data.
• Executes Data Quality and Metrics team tests/assessments and data cleansing activities.
• Serves as a liaison between the business and internal clients in managing the data loads for one or many portfolios, including execution of data load steps and active troubleshooting as needed to keep data loads on-schedule.
• Leads proposal, design and implementation of data load process improvements to reduce speed to market and improve data quality for our customers.

Responsibilities include but are not limited to the following tasks:

• Reviews data loaded into the data mart for accuracy.
• Recommends maintenance enhancements and data quality metric requirements for data processes to improve the accuracy of the data mart data.
• Reviews referential integrity and historical integrity of data mart data.
• Assist in determining root cause of data quality issues and recommending short term and long term solutions.
• Perform in depth testing and validation of key data quality issues identified by business partners and other users of the data mart.
• Investigate, troubleshoot and document source-to-target and other data issues from internal and external customers.
• Leads planning, analysis, design, implementation, and maintenance of process to support and improve the CLRTY database platform.
• Leads consultation with and provides guidance to database users and client groups, often recommending tactical and strategic solutions.
• Actively communicate data quality issues with multiple internal and external customers.
• Performs complex server-class database testing activities across various platforms and environments including one or more of the following:
• Business requirement identification and analysis.
• Conceptual, logical, and/or physical database design.
• Perform and create SQL queries to identify data issues.
• Data modeling and/or mapping, mapping analysis.
• Moderate to complex programming and coding to automate and/or support the database environment, SQL query creation and testing.
• Analyze, query and manipulate data according to defined business rules and procedures.
• Performance monitoring and tuning.
• Evaluate large datasets for quality and accuracy.
• Work with programmers to correct data quality errors.
• Determine root cause for data quality errors and make recommendations for long-term solutions.
• Research and determine scope and complexity of issue so as to identify steps to fix issue.
• Analyzing database data quality metrics and assisting with capacity planning data quality dashboard output and review.
• Ensure adherence to data quality standards, Identify areas of improvement.
• Planning, testing, configuration and execution of installations, upgrades and migrations, SQL queries associated with key data issues found by customers.
• Implementing security controls.
• Implementing an indexing strategy to support both effective data loads, and well as user extraction of data.
• Leads mentors…