Randstad Database Analyst in Charlotte, North Carolina
Thursday, September 29, 2016
Provides the highest technical expertise for the planning, analysis, design, implementation, maintenance, and control of the organization s server-class databases. Handles and leads the most complex or critical data/ database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling. As the recognized technical expert, consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies. Serves as a consultant on technological advancements. Provides oversight, mentoring and leadership to less experienced staff. May represent the organization as an external spokesperson.: 10+ years database design and administration experience.
This position is within our Data Services Group/Credit Risk Management Production Support team and provides support of critical month-end data loads 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 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.
-7+ years of business systems analysis experience, business systems design experience, or a combination of both
-5+ years of SQL experience
-5+ years of ETL (Extract, Transform, Load) Programming
-Excellent verbal, written, and interpersonal communication skills
-SQL Server 2008 / 2012
-PC SAS / Enterprise Guide
-Ability to analyze business requirements and transform those requirements into business rules
-Knowledge and understanding of Ab Initio
-Knowledge and understanding of technology testing: creation of BRDs, FSDs, and screen mock ups
-Strong relationship management skills
-Ability to translate business requirements into technical requirements