Associate - TECH010219ADLT

  • Competitive
  • Jersey City, NJ, USA
  • Permanent, Full time
  • Goldman Sachs USA
  • 15 Feb 19

Associate - TECH010219ADLT

MORE ABOUT THIS JOB
Associate with Goldman Sachs Services LLC in Jersey City, NJ.

Work Schedule: 40 hours per week (9:00 a.m. to 6:00 p.m.)

RESPONSIBILITIES AND QUALIFICATIONS Duties: Associate with Goldman Sachs Services LLC in Jersey City, NJ. Perform data modeling and data warehouse designing, and build data sourcing solutions for the Firm's Financial Crime Compliance (FCC) applications. This entails working with and designing business process and data models for financial domain data and reference data, as well as performing data sourcing, transformation and ingestion processes using frameworks such as Kafka, HDFS, Parquet or Avro. Lead data control uplift across FCC applications by mapping systems to the data flow upstream, analyzing the completeness of controls, and driving development projects with global teams for any identified gaps. Build and deploy complex information systems involving data interchange and legacy services to a production environment across all phases of Software Development Life Cycle(SDLC) using Agile methodology and JIRA software, and engaging in user acceptance testing. Collaborate with Financial Crime Compliance stakeholders to elicit requirements, identify issues and business needs, design technology solutions, and plan, develop, and coordinate the production deployment of the solutions, while working with other team members. Working with business users and software development team across regions globally to analyze requirements and create Business Process Models (BPM), Business Requirements Document (BRD) and Requirement Traceability Matrix (RTM). Create User Manuals and deliver trainings to end users to acquaint them with application enhancements. Lead internal platform and application development to support Compliance division by contributing to the definition of new features and testing newly built features. Collaborate with the Compliance division to identify Anti-Money Laundering (AML) and Sanctions risk across different regions and business lines, and map it to technical systems and data sources to provide data. Collaborate closely with Regional Compliance Officers to translate local regulatory reporting requirements into technical reports and solutions using Alteryx and Tableau. Contribute to the New York State's Department of Financial Services (DFS) certification program for all in scope Compliance areas by collaborating with multiple Compliance and Technology teams to identify suitable platforms and applications, deliver customized applications, drive the attestation process, manage evidence for Technology stakeholders, and drive remediation projects as an outcome of any identified gaps. Analyze processes and workflows of cross-area projects and assist with identifying and automating manual processes in order to gain efficiency through migration of legacy applications to strategic platforms. Work closely with FCC stakeholders to manage internal and external audits as a technology representative and to understand audit requirements. Write or modify SQL queries and stored procedures and engage in query performance tuning and performance optimization on relational databases, including IBM DB2 and Sybase.

Job Requirements: Master's degree or Bachelor's degree (US or foreign equivalent) in Information Systems, Computer Science, Computer Engineering, or a related field. Two (2) years of experience with a Master's degree or five (5) years of experience with a Bachelor's degree in the job offered or a related role. Must have two (2) years of experience with a Master's degree or five (5) years of experience with a Bachelor's degree with: Creating risk assessment dashboards using statistical analysis and reporting tools including Tableau; Working with financial domain data, including trades, positions, and securities settlements, and reference data including clients, accounts, and products; Writing and modifying SQL queries and stored procedures, and executing query performance tuning and performance optimization on relational databases, including IBM DB2 and Sybase; Working with Kafka, HDFS (distributed file system), and either Parquet or Avro; Designing business process models and data models for client and account reference data; Performing data and system analysis for development or enhancements to applications supporting business processes using data analytics tools, such as Alteryx or similar; Working across all phases of Software Development Life Cycle(SDLC) using Agile methodology and JIRA software; Developing Business Process Models (BPM), Business Requirements Document (BRD) and Requirement Traceability Matrix (RTM); Engaging in project management including monitoring project status and highlighting risks across global team and stakeholders; Performing Test Driven development using test scripts to validate business requirements and drive User Acceptance Testing; and Using Unified Modeling Language (UML) Entity Relationship diagrams and Object Oriented Analysis and Design (OOAD) notations to design data models.

ABOUT GOLDMAN SACHS The Goldman Sachs Group, Inc. is a leading global investment banking, securities and investment management firm that provides a wide range of financial services to a substantial and diversified client base that includes corporations, financial institutions, governments and individuals. Founded in 1869, the firm is headquartered in New York and maintains offices in all major financial centers around the world.

© The Goldman Sachs Group, Inc., 2019. All rights reserved Goldman Sachs is an equal employment/affirmative action employer Female/Minority/Disability/Vet.