Data Analyst (Rdbms & Big Data)

This role is with one our Banking client.

Daily Responsibilities:

1: Data Analysis

• Responsible for the rapid identification, prioritization and deployment of reporting and analytics to define new potential business opportunities and to make well informed decisions (short and long term) through the use of internal, industry and competitor data.
• Provide and support reporting requests, on Cards, Payments & Banking clients and for tracking the Moneris Transformational Program to appropriate groups (both internal and external), as required.
• Support the roll-out of key business projects and ensure data and analytics capabilities are developed on time and on budget.
• Become the data subject matter expert (SME) for Cards, Payments and Loyalty, Retail, Small business and Commercial credit card holders and in support of the Moneris Transformation Program (MTP) journey as part of the Commerce & Payment mega-journey.
• Help in data preparation for complex analytical projects

2: BI Tool & Analytic support

• Transform the way Cards, Loyalty, and Enterprise Payments use data by developing advanced reporting and analytics to serve external and internal clients.
• Develop new methodologies and business analytical tools to address complex business issues. Identify measure and monitor the impact and success of new and existing initiatives, including but not limited to pricing, acquisition and portfolio management.

Must Have Skills:

• Strong coding experience in programming languages like SQL, Python
• Strong proficiency with statistical software – SAS
• Demonstrated research and analytical capabilities.
• 4+ years of experience with Tableau
• Expert knowledge of working with data in relational databases and/or Hadoop
• 5+ years of experience with relational databases (Db2, MySQL, Teradata) as well as 2+ years of experience with big data environment / processing tools such as Hadoop (Hive, HDFS) and Apache Spark