Global Markets Operations - Business Intelligence Associate

OPERATIONS

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. For every new product launched and every trade executed, it is Operations that develops and manages the processes and controls that enable business flow.

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.

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.

• 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:
  
  Pro…