Senior Data Analyst - Wealth ManagementLocation: NY, NY (Hybrid) (Pref locals)Duration: Long TermClient: Wealth Mgt IndustryVisa: USC and GC onlyPrimary Skills: SQL, API, RDBMS, SOAPUI, MS Office, Informatica, Data Integration, design, Wealth Management, Modeling, Data Analyst, Warehouse, ETL Development, Market Traders, Data TradesPosition 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 gapCoordinate data sourcing with upstream data teamsPartner 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 migrationLiaise with the business analysis team to understand the data requirementsSupport the team with data analysis, such as data source discovery, data usage viability and data sourcingSkills Required:Bachelor's Degree in Computer Science or similarWealth management/ Trading experience preferredMinimum 9 years of experience in global organizations as a Data AnalystProficiency in Data Analysis, with working experience in SQL and relational databasesExperience using API and SoapUIMarket 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 sideETL data analytics side using Oracle/ PL/SQL for query purposeMainly Market Control in MS 8-12 years of experienceStrong 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 SQLExperience in data integration, conversion and migrationKnowledge 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 doKnowledge of domain specific data and enterprise dataKnowledge of Autosys, Unix commands and scriptingKnowledge of Data Quality controls & implementation of DQKnowledge and experience in Agile development methodology (scrum preferred)Extensive experience documenting processes, workflows and technical specificationGood customer service skills. Ability to deal with difficult situations gracefullySQL querying building, Word, Excel, and PowerPointStrong communication skillsConfidenceStrong communication skills, both verbal and written; as well as work in an international team settingHave strong reasoning skills, logical deduction and apply to data analysisCollaborate effectively across a variety of IT and Business groups, across regions and rolesPresent and be able to tell a story with the data analysis/reportingSelf-motivated individual and creative thinker who will take ownership of tasks assignedAbility to problem solve and have creative solutions in challenging environmentsAble to thrive in a fast-paced, high energy, demanding and team-oriented environmentSkills Desired:Big data is a bonus but not requiredExperience 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, FuturesUnderstanding of Risk/Compliance surveillance platforms (Actimize, MANTAS, Sungard) and their models, Wash trades, Marking the Open/Close, Spoofing, Insider Trading, etc.