15 days old
2018-01-052018-02-02
  • Job Code
    594399
  • Payrate
    $35 To $40

Data Analyst


Description:


This role will be part of the larger Financial Crimes Intelligence Unit Program. Specifically, this role will require developing in depth knowledge of auto finance data that is processed to find suspect activity relating to Money Laundering, as well as enhance, transform, and perform load procedures on data output from multiple upstream application source systems. This resource will develop and maintain data management procedures in Oracle for the project. They will create and support system change requests in relation to the project efforts. In addition, they will also participate in technical oversight, decision making, and the delivery of the data flow through the Oracle repository into the Alert Generation Process application.


Required skillsets include:



  • Strong SQL/ PL/SQL skills
  • Experience in writing PL/SQL procedures, functions, packages
  • Ability to look at the existing tables/views and understand the relationships between them given the data models associated to it
  • Expert in writing simple/medium/complex queries using different types of joins, sub-queries, analytical functions
  • Analyze large amounts of data and arrive at conclusions
  • Present the analysis and conclusions to larger audience with facts and figures and get their consensus
  • Create logical and physical data models based on requirements
  • Look at existing queries and propose tuning methods like adding different types of indexes, partitions etc
  • Look at different sources and targets and create Source to target mappings that can be used by the ETL developers
  • Manage Oracle DBA change documentation and support project deployments Experience in Agile Methodology


Basic Qualifications:



  • Knowledge of financial and banking products, policies, operations and applicable procedures
  • Bachelor's degree in related field
  • 3 years overall performing analytical work
  • Solid analytical and research skills, and use of good judgment in decision making and sense of urgency for high priority issues
  • Strong communication and partnering skills
  • Experience authoring professional documentation and incorporating feedback
  • Ability to handle multiple priorities and deadlines effectively and efficiently
  • Strong computer skills including proven experience with Microsoft Office suite, Visio, Oracle
  • Customer Focus ? proven track record of customer satisfaction and delivery success and ability to establish and maintain appropriate relationships with business and IT stakeholders
  • Consulting/Problem Solving ? ability to work in an advisory capacity to identify key technical business problems, develop and evaluate alternative solutions and make recommendations


Preferred Skills/Experience:



  • Knowledge of IBM Information Server Suite tools like DataStage, Information Analyzer is a plus
  • Experience supporting AML/BSA, Customer Due Diligence, economic sanctions/OFAC or other compliance related initiatives in a large, complex, highly-regulated financial institution
  • Experience with Bank Anti-Money Laundering (AML) and/or Customer Due Diligence (CDD) related systems.
  • Strong planning, implementation and negotiation skills
  • Effective interpersonal, verbal and written communication skills

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Analyst

Randstad Technologies
Charlotte, NC 28277

Share this job

Data Analyst

Randstad Technologies
Charlotte, NC
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast