SQL Programmer/Data Analyst

On behalf of our client in the Banking Sector, PROCOM is looking for a SQL Programmer/Data Analyst.

SQL Programmer/Data Analyst – Job Description

  • Retail reporting responsible for high priority and complex Performance Management Reporting initiatives to support performance management strategic and tactical priorities, including Sales & Service Effectiveness, Performance Enablement and Performance Reporting
  • Which involve the facilitation and gathering of requirements, the development, production implementation, delivery and documentation of those requirements to achieve high quality Performance Management Reporting solutions
  • This role supports business partners and stakeholders by successfully transforming data into useful, relevant information, and by leveraging sound business knowledge, additional sources of information, and resources to deliver insight to our internal clients
  • To take end to end responsibility in the development of performance metrics and reporting on multiple reporting platforms
  • Excellent communication skills (verbal and written), Strong written and verbal communication skills, especially in explanation of complex concepts to a non-technical audience, Detail oriented, Ability to support ongoing communication across work streams
  • Excellent time management capabilities – Strong time-management and organizational skills, Ability to break large problems into well-defined and manageable tasks, Ability to work well under pressure, Ability to work on multiple tasks at the same time, Works with minimal degree of supervision
  • Analytical Thinking – Ability to apply superior data knowledge & discovery skills into building effective performance metrics, Strong problem-solving and Analytical skills with ability to innovate
  • Information Seeking Ability to research and gather relevant information to provide accurate performance measures
  • Achievement Motivation – Self-motivated, Good team player and customer-focused, maintains a positive ‘can-do’ attitude and inspires others
  • Responsible for the design, development, maintenance, delivery, testing and documentation of performance metrics and reporting on various platforms
  • Prepare detailed documents in accordance with PMR’s standards and guidelines. e.g., Business Metric Design, Reporting Design, UAT Test Plans and Process Flows
  • Demonstrate Subject Matter Expertise in data and reporting infrastructure design, configuration and optimization, providing recommendations on approach and execution
  • Develop reasonable estimates for completion of all of the above and provides updates on any changes that would result in delays
  • Anticipates logical outcomes and impacts of proposed solutions mitigating need for change management
  • Review and respond to business requirements and convert to technical requirements and/or design
  • Data mining across all data sources
  • Provide analytical and QA support during development and testing phases
  • Adhere to PMR’s testing standards and works closely with QA/UAT team; develops and executes test cases when required
  • Support feasibility request, conduct impact analysis and complete ADHOC request for analysis and/or reporting
  • Support Regional Banking initiatives by providing insights and/or recommendations Individual Project scope typically includes 3-7 moderate and high complexity new report, metrics and/or analytical dataset builds per quarter

SQL Programmer/Data Analyst – Mandatory Skills

  • Advanced SQL skills and knowledge of relational database concepts and design
  • Extensive experience with data mining and integration across platforms
  • Proficient in SAS, Python, Korn Shell scripting
  • Experience working with Unix command line
  • Experience working with Data Lake
  • Thorough working knowledge of DWE – data warehouse (RBDM, IDM, EDW etc.)

SQL Programmer/Data Analyst – Nice to Have Skills

  • Experience with Oracle BI, Tableau
  • Previous banking and/or financial institution an asset

SQL Programmer/Data Analyst – Assignment Start Date

ASAP – 12 months to start

SQL Programmer/Data Analyst – Assignment Location

Toronto, ON – Work Remotely

Tagged as: AGI