Data Analytics

Global Markets Operations - Business Intelligence Analyst in London. Operations is a dynamic, multi-faceted division that partners with all parts of the firm to provide banking, securities, and asset management services to clients around the world. In addition, Operations provides essential risk management and controls to preserve and enhance the firm's assets and its reputation.

OUR IMPACT: The team is seeking a skilled professional who will provide business insights for data driven decisions. In this role, you will apply your quantitative, problem solving and client service skills to support the various business units and clients. You will also play a key role in suggesting and implementing process improvements for the team to mitigate risks and enhance the overall client experience.

JOB SUMMARY AND RESPONSIBILITIES:

• Data Analysis and Process Improvement: Analyze trade lifecycle and operational workflows to identify areas for optimization and automation. Enable strategic decision making through data driven analytics. Develop detailed technical specifications for BI solutions based on business requirements, adhering to SDLC best practices.
• BI Solution Development: Design, develop, test, and deploy end-to-end Business Intelligence solutions using Alteryx for data preparation, SQL for data transformation and storage, Tableau for data visualization, and R/Python for advanced analytics. Design, implement, and maintain ETL pipelines using Alteryx to extract data from diverse source systems (e.g., relational databases, APIs, flat files), transform it according to defined business rules and data quality standards, and load it into target data warehouses or databases.
• Risk Mitigation and Data Governance: Implement data validation rules and monitoring mechanisms to ensure the accuracy and reliability of data used for reporting and analysis, adhering to data quality standards and regulatory requirements.
• Stakeholder Management and Prioritization: Work with stakeholders to define project scope, objectives, and deliverables, creating detailed project plans and timelines. Communicate technical concepts and solutions to both technical and non-technical audiences, tailoring communication style based on the audience.
• Data Modeling and Warehousing: Design and implement data models optimized for analytical workloads, using dimensional modeling techniques (e.g., star schema, snowflake schema). Participate in the design, implementation, and maintenance of data warehouses ensuring data integrity, performance, and scalability.

BASIC QUALIFICATIONS:

• Educational Background: Bachelor's or Master's degree in Computer Science, Statistics, Mathematics, Engineering, or a related quantitative field.
• Experience: 1+ years of hands-on experience in Business Intelligence and Digital Transformation projects.
• ETL Expertise: Proficiency in Alteryx Designer, including the ability to design and implement complex ETL workflows, and optimize performance.
• Data Visualization Proficiency: Proficiency in Tableau Desktop, including the ability to create interactive dashboards, complex calculations, custom visualizations, and performance optimization.
• SQL Development Skills: Mastery of SQL, including the ability to write complex queries, stored procedures, views and perform query optimization.
• Programming/Statistical Analysis Skills: Working knowledge of R or Python for analytics, data manipulation, and algorithm development.
• Data Warehousing Knowledge: In-depth knowledge of data warehousing principles, dimensional modeling techniques (e.g., star schema, snowflake schema), and data quality management.
• Communication and Collaboration Abilities: Excellent verbal and written communication skills, with the ability to effectively communicate technical concepts; experience gathering requirements, creating technical documentation, and collaborating with cross-functional teams.
• Problem-Solving Acumen: Strong analytical and problem-solving skills, with the ability to troubleshoot complex technical issues, identify root causes, and develop effective solutions.
• Project Management Skills: Proven ability to manage projects, prioritize tasks, and meet deadlines; familiarity with project management methodologies (e.g., Agile, Waterfall) and tools (e.g., JIRA, Confluence).

PREFERRED QUALIFICATIONS:

• Minimum 1+ years of experience supporting a Financial Operations function.
• Experience in advanced data analytics, statistical modeling, and predictive analytics using tools such as Alteryx, Python, or R; experience with machine learning algorithms and techniques is a plus.
• Experience in building and maintaining APIs for data integration and delivery.
• Experience with data warehouse platforms such as Snowflake a plus.

At Goldman Sachs, we commit our people, capital and ideas to help our clients, shareholders and the communities we serve to grow. Founded in 1869, we are a leading global investment banking, securities and investment management firm. We believe who you are makes you better at what you do. We're committed to fostering and advancing diversity and inclusion in our own workplace and beyond.