Data Analyst

Skills

Proficiency in understanding data and writing queries - In depth understanding of joins complex queries sub queries data analysis and data quality testing. Understanding of query optimization techniques Data profiling on popular databases ( Oracle MySQL Hive Impala etc.) Ability to capture requirements and communicate with users Strong Interpersonal communication Client interaction for problem solving and staff support related to BI tools Ability to capture big data requirements from stakeholders and proposed an approach to deliver solution Ability to debug Tableau issues in production system and propose an approach to fix those Ability to model data gather required data Understand optimization of data sources e.g. consolidation of multiple data sources into one scalable solution Understand Tableau security related limiting access to dashboards for users or groups of users Best practices for dashboard performance (not necessarily data related) Feedback on alignment of resume based on evaluation of resource

Description

You will be joining the Team within Regulatory and Cross Product IT delivering Trader and Counterparty surveillance across all business sections of the Bank. We are an engineering focused organization, striving for the highest quality architecture, design and code across our teams. You will help to build our surveillance systems, working in a fast-paced, agile environment. Our workload for new deliveries is high, with requirements to identify and document process flows, analyze and documents the linkage for client accounts and activities, and identify data sources and sourcing requirements using Oracle and Hadoop Big Data solutions.

Responsibilities

• Data and SQL Skills: Proficiency in understanding data and writing queries - In depth understanding of joins, complex queries, sub queries, data analysis and data quality testing.
• Data and SQL Skills: Understanding of query optimization techniques
• Data and SQL Skills: Data profiling on popular databases ( Oracle, MySQL, Hive, Impala, etc.)
• Soft Skills: Ability to capture requirements and communicate with users
• Soft Skills: Strong Interpersonal communication
• Soft Skills: Client interaction for problem solving and staff support related to BI tools
• Solution Skills: Ability to capture big data requirements from stakeholders and proposed an approach to deliver solution
• Solution Skills: Ability to debug Tableau issues in production system and propose an approach to fix those
• Tableau Skills: Ability to model data, gather required data
• Tableau Skills: Understand optimization of data sources e.g. consolidation of multiple data sources into one scalable solution
• Tableau Skills: Understand Tableau security related limiting access to dashboards for users or groups of users
• Tableau Skills: Best practices for dashboard performance (not necessarily data related)
• Resume: Feedback on alignment of resume based on evaluation of resource