| Data Analyst - Advanced(9+ years) || In person Interview-NYC || Local to NYC || No H1B & CPT at NYC, New York, USA |
| Email: [email protected] |
| In person Interview at NYC Data Analyst Advanced(9+ years) (LOCAL to NYC HYBRID) No H1B and CPT 12+ month contract Please note that all candidates must be available to come onsite for an interview, no exceptions will be made. Candidates will be joining in-person once selected- with a hybrid work schedule of 3 days onsite and 2 days remote. We offer: - To work with some of the best professionals in the business - for a firm that values individual intellect as much as teamwork - State-of-the-art offices that are designed to maximize collaboration - Flexible working arrangements - Enriching challenges that provide opportunity for constant learning and advancement - An environment which is leveraging technology to its highest potential Team Profile: Legal, Compliance & Corporate Governance (LCG) Technology provides operational controls and surveillance capabilities to enhance the firm's resilience to threats and fraudulent behavior. Our support of critical business functions extends to archival & records management, business continuity planning and due diligence investigations. Position Description: This role is part of the Financial Advisor Monitoring and Registration Department, within LCG. This team supports the Risk and Compliance divisions with tools and applications to assist them with their task of monitoring Financial Advisor's compliance with the Firm's policies and procedures. 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 individual 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 - 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 - Coordinate data sourcing with upstream data teams - Partner with team on testing with data verification, completeness, and data quality checks. - Participate in data driven initiatives, such as data linage, data quality checks, data migration Questions/Required Skills: -Strong communication skills -Confidence -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 specifications Qualifications - External Skills Required: - Bachelor's Degree in Computer Science or similar - Minimum 9 years of experience in global organizations as a Data Analyst. - Proficiency in Data Analysis, with working experience in SQL and relational databases - 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-orientated environment - Good customer service skills. Ability to deal with difficult situations gracefully. - SQL querying building, Word, Excel, and PowerPoint - Experience using API and SoupUI Skills Desired: - 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. MANAGERS NOTES the manager would like you all to kindly, thoroughly read the below guidelines prior to your search. If a candidate has at least 6 of the below mentioned skills, then you can submit. Otherwise, please do not submit, as the qualifications for a successful candidate in this role are quite niche. Please note that all candidates must be available to come onsite for an interview, no exceptions will be made. Candidates will be joining in-person once selected- with a hybrid work schedule of 3 days onsite and 2 days remote. Questions Communication Confidence 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 specifications Regards, Adarsh Sharma Senior Technical Recruiter A : 25 Oak Tavern Cir Branchburg, New Jersey - 08876 DISCLAIMER: Please respond as remove if you are not interested to receive any email with this email address. We sincerely apologize for any inconvenience caused to you. Keywords: information technology |
| [email protected] View all |
| Sat Aug 12 06:50:00 UTC 2023 |