Senior Data Analyst

ICONMA Published: June 11, 2019
Richmond, VA
Job Type


Location: Richmond, VA

Duration: 6 months with possible extension  / CTH


Call Notes :


Team info:

Enterprise operational risk management

Responsible for Risk Data Warehouse/ internal loss data (ILD)

Migrated to Redshift recently

Receive daily and monthly feeds for operational losses and data is used for regulatory reporting

These reports go out to ORX and ADA and Federal regulators

User interface they are using is SQL Workbench



Need Expert in SQL/ knows all OLAP functions

- Writing code, transferring files, manipulating (over 11k lines of SQL in a single job)

- May be splitting that particular project to help reduce daintiness of that one in particular

True analyst- Make sure all ETL is correct, pinpoint anomalies, initiate investigation when needed, able to offer solutions to correct data

Can trace lineage of data across platforms and numerous reference tables

Strong work ethic, will do whatever it takes to get it done (there may be long hours, weekends, to meet deadlines)

Python and scripting experience (Python is highly preferred but can be basic knowledge here)

4-5 years several years exp with complex SQL/ more senior person

Great communication skills

Prefers AWS experience, especially S3, but this can be picked up quickly if they don’t have it



Our ideal candidate will have:

Degree specialized in a Science, Technology, Engineering, Mathematics discipline

Scripting experience in (Python, Perl, JavaScript, Shell)

Strong desire and experience with data in various forms (data warehouses/SQL, unstructured data environments/PIG,HIVE, Impala)

Experience leading projects to deliver complex data management solutions; working with internal and external partners

Only registered members can apply for jobs.

Related Jobs

Internal Audit Senior Analyst II   Mountain View, CA
June 8, 2019
May 29, 2019