Business Analyst, Capital Markets – Data Mapping (Python, Sql, Powerbi)

Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI) On behalf of our client in the Banking Sector, PROCOM is looking for a Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI).
Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI)–

• Defines a common data schema for storage and normalization of multiple market order feeds across our various vendor platforms
• Develops and maintains the end-to-end mapping of data and connectivity for market order data between Order and Execution, across all relevant platforms
• Lead the development and build of data governance metrics, including:
• Strengthening and developing the control environment by promoting an understanding and adherence to the existing governance framework and policies, procedures, and regulations
• Works with Global Governance stakeholders to identify and design data governance controls and processes across Internal Controls processes
• Partners with technology groups, internal controls and Legal/Compliance to drive the retainment and governance of multiple market order data feeds across GBMs order platforms
• Acts as data and business SME for GBMs market order data, assisting with Regulatory, internal and external requests regarding pre-trade order data
• Actively creating efficiencies in the way controls are applied while still operating under a strong control's framework
• Leverage/Identify enhanced tools and processes through innovative use of the available technologies
• Develop Key Risk Indicators and Key Performance Indicators tools to facilitate an understanding of Internal Controls data quality and completeness
• Integrate market order data from multiple sources and create and contribute requirements to develop a robust storage solution to satisfy GBM’s regulatory recordkeeping requirements
• Developing relationships with business, technology and vendor stakeholders to understand requirements to manage operational risk and support business activity
• Acts as business lead for data storage solution and is responsible for development of BAU quality and completeness control processes

Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI)– Mandatory Skills

• The ability to prioritize amongst many competing deliverables at any given time
• University Degree or College Diploma in Computer Science, Engineering or a related technical discipline
• 2+ years of Capital Markets experience required
• Ability to successfully work in a fast paced and dynamic environment with constantly changing conditions
• High proficiency in data analytics tools (Python, SQL), data visualization tools (PowerBI) and Office 365 products (Excel VBA, SharePoint, Power Automate)
• CFA or relevant Finance degree
• Product knowledge across Capital Markets
• Experience working cross functionally with Technology, Compliance, Legal stakeholders across both junior and senior levels
• 8+ years' experience as a BA
• Team player with strong written, communication and presentation skills
• Experience creating and implementing data models, schemas and databases

Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI) - Preferred Skills

• Proven experience understanding and consolidating data feeds into enterprise grade data pipelines
• Good understanding of REST APIs and other connectivity methods between data sources and vendor platforms
• Knowledge of data lake platforms

Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI)- Assignment Start Date ASAP – 6 months to start
Business Analyst - Capital Markets - Data Mapping (Python, SQL, PowerBI)- Assignment Location Toronto, ON – Work Hybrid