Senior Data Analyst - Wealth Management

Senior Data Analyst - Wealth Management

Location: NY, NY (Hybrid) (Pref locals)

Duration: Long Term

Client: Wealth Mgt Industry

Visa: USC and GC only

Primary Skills: SQL, API, RDBMS, SOAPUI, MS Office, Informatica, Data Integration, design, Wealth Management, Modeling, Data Analyst, Warehouse, ETL Development, Market Traders, Data Trades

Position Description:

This role is part of the Financial Department, working with Risk and Compliance divisions with tools and applications to assist them with their task of monitoring Financial compliance.

As a Data Analyst, you will be responsible for various support activities around our groups data, including, but not limited to data verification, pattern discovery, data quality verification, data migration support and analytical insights. The ideal candidate should have the skills listed below and be a self-driven, dedicated individual who works well in a team and thinks and acts strategically. When faced with a problem, the candidate should be able to ask questions and leverage the skills and expertise of those around them. They would work well as individuals in an exploratory manner to learn and understand the data and its flows.

Key Responsibilities:

Analyze data sets to determine data gaps and work with cross functional teams to bridge the gap

Coordinate data sourcing with upstream data teams

Partner with a team on testing with data verification, completeness, and data quality checks.

Participate in data driven initiatives, such as data lineage, data quality checks, data migration

Liaise with the business analysis team to understand the data requirements

Support the team with data analysis, such as data source discovery, data usage viability and data sourcing

Skills Required:

Bachelor's Degree in Computer Science or similar

Wealth management/ Trading experience preferred

Minimum 9 years of experience in global organizations as a Data Analyst

Proficiency in Data Analysis, with working experience in SQL and relational databases

Experience using API and SoapUI

Market Data, Trades Data, Positions Data, Reference Data, Data Analytics with good exposure in data Query.

Works closely with Business Analyst team Inside trading.

Data integrating project SQL expertise is needed for analytical side

ETL data analytics side using Oracle/ PL/SQL for query purpose

Mainly Market Control in MS 8-12 years of experience

Strong understanding of data concepts (Modeling/Design, -Warehousing, ETL Development)

Sound knowledge in RDBMS, SQL Queries, Indexes, Keys and Tables considering platforms, such as Apache Hadoop, Oracle, MySQL, HiveQL, and Microsoft SQL

Experience in data integration, conversion and migration

Knowledge of Microsoft Office applications (Visio, PowerPoint, Excel, Word)

Experience with ETL tools (preferably Informatica) with the ability to develop ETL design specifications and understand from code what existing ETLs do

Knowledge of domain specific data and enterprise data

Knowledge of Autosys, Unix commands and scripting

Knowledge of Data Quality controls & implementation of DQ

Knowledge and experience in Agile development methodology (scrum preferred)

Extensive experience documenting processes, workflows and technical specification

Good customer service skills. Ability to deal with difficult situations gracefully

SQL querying building, Word, Excel, and PowerPoint

Strong communication skills

Confidence

Strong communication skills, both verbal and written; as well as work in an international team setting

Have strong reasoning skills, logical deduction and apply to data analysis

Collaborate effectively across a variety of IT and Business groups, across regions and roles

Present and be able to tell a story with the data analysis/reporting

Self-motivated individual and creative thinker who will take ownership of tasks assigned

Ability to problem solve and have creative solutions in challenging environments

Able to thrive in a fast-paced, high energy, demanding and team-oriented environment

Skills Desired:

Big data is a bonus but not required

Experience working in medium to large-scale development projects.

Knowledge of trades data, positions data, reference data.

Experience in trade lifecycles and asset classes, Equity, Fixed Income, Options, Futures

Understanding of Risk/Compliance surveillance platforms (Actimize, MANTAS, Sungard) and their models, Wash trades, Marking the Open/Close, Spoofing, Insider Trading, etc.