Associate with Goldman Sachs Bank USA in Chicago, IL.
Work Schedule: 40 hours per week (9:00 a.m. to 6:00 p.m.)RESPONSIBILITIES AND QUALIFICATIONS
Duties: Associate with Goldman Sachs Bank USA in Chicago, IL. Serve as US Deposits Data Engineering technical lead for Marcus by Goldman Sachs. Work daily with the product owner and the development teams in an agile scrum setting to prioritize and deliver business requirements for US Deposits data warehouse and reporting systems. Responsible for end-to-end systems development cycle from requirements analysis, design, coding, testing, maintenance and User Acceptance Testing (UAT) of these analytics applications. Work closely with business analysts and functional leaders to understand the desired output of reports and dashboards and come up with the technical design to implement. Write and manage software primarily to support ETL (Extract Transform Load) functionality for loading data to a data warehouse allowing business analysts and functional leaders to action business decisions based on that data. Develop ETL leveraging technologies like Informatica, Python, Spark and PL/SQL. Work with PL/SQL and data visualization applications like Tableau and QlikView for dashboard reporting. Work with PL/SQL and the Business Objects application for tactical operational reporting. Provide code review feedback to team members’ software changes to maintain structural quality of software. Use engineering practices, like Continuous integration and deployment, to manage and deploy code to various environments. Convey technical details of software changes to the software quality assurance (QA) testing team, allowing the team to determine the set of test cases for execution for future software releases. Provide bug fixes and test in an integration testing environment for ongoing software releases. Work in a Linux environment and make proficient use of Splunk to provide support for production servers and systems. Must be willing to work with proprietary tools, systems and processes, but no prior knowledge required.
Job Requirements: Bachelor’s degree (U.S. or foreign equivalent) in Computer Science, Computer Engineering, Information Systems or a related field. Five (5) years of experience in the job offered or related position with ETL design and development. Prior work experience must include five (5) years with: Design, develop and manage data ingestion and transformation workflows leveraging the Informatica software; Design, develop and manage business metric dashboards leveraging the Tableau data visualization software; Design, develop and manage operational business reporting leveraging the SAP Business Objects software; Design, develop and manage Oracle Database software leveraging PL/SQL and data warehouse modelling; Design, develop and manage Unix shell scripting; and Software Development Life Cycle (SDLC) management leveraging agile methodology. Prior work experience must also include some experience with: Python programming language and Spark framework.