Sr. IT Data Analyst

TD Bank; Old Toronto; On-site; CAD 76,000 - 116,000; Full time

Job summary

Une entreprise innovante recherche un Analyste des données principal pour diriger des fonctions d'analyse de données critiques. Ce rôle dynamique nécessite des compétences avancées en SQL et en Ab Initio, ainsi qu'une expérience en modélisation de données et en ETL. Vous aurez l'opportunité de travailler sur des projets complexes, en collaborant avec des équipes interfonctionnelles pour concevoir des solutions de gestion de données qui répondent aux exigences commerciales. Si vous êtes passionné par l'innovation et que vous souhaitez jouer un rôle clé dans la transformation des données, cette position est faite pour vous.

Qualifications

• 5-7 ans d'expérience pertinente dans l'analyse de données.
• Connaissance avancée des processus et procédures d'entreprise.

Responsibilities

• Fournir un leadership technique dans les fonctions d'analyse de données.
• Collaborer avec les équipes pour comprendre les exigences commerciales.

Skills

Ab Initio

Unix Shell Scripting

SQL

DB2

Host Mainframe

CA7

Autosys

Education

Diplôme de premier cycle

Certificat technique

Tools

Hadoop

Job description

Analyste des données princ., TI

Lieu de travail : Toronto, Ontario, Canada

Horaire : 37.5

Secteur d’activité : Solutions technologiques

Détails de la rémunération : $76,800 - $115,200 CAD

En tant que candidat, nous vous encourageons à poser des questions sur la rémunération et à avoir une conversation franche avec votre recruteur, qui pourra vous fournir des détails plus précis sur ce poste.

Description du poste :

Provide technical leadership across a broad range of data analysis functions including data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. Works independently as a senior lead and may manage and direct activities related to analysis, design and support of technical data management solutions on various projects ranging in larger projects.

KEY ACCOUNTABILITIES

CUSTOMER

• Elicit, analyze and understand business and data requirements to develop complete business solutions, including data models (entity relationship diagrams, dimensional data models), ETL and business rules, data life-cycle management, governance, lineage, metadata and reporting elements.
• Apply automation and innovation on new data platforms and on-going on any new development projects / initiatives aligned to business or organizational strategies
• Design and implement reporting platforms, including modeling, ETL, BI framework and be able to deliver complete BI solution that meets business requirements
• Design and implement complex ETL frameworks to provide a solution that meets business requirements
• Collaborate and build effective working relationships with colleagues across technology and the business to achieve business and IT objectives
• Work closely with various technology/project teams to understand the business meaning of data, and provide analysis and requirements to ensure the data design is fully understood and the development initiatives are in line with the intended design and standards

SHAREHOLDER

• Coordinate with other technology work teams such as, ITS, Architecture, TRMIS etc. to ensure project success
• Deliver Business or Enterprise Data deliverables for the various related platforms/servers/applications/systems and ensure adherence to Enterprise frameworks
• Provide the data analysis and requirements within the enterprise platform (e.g. Hadoop)
• Implement processes aligned to data management standards and ensure data quality and data requirements are embedded in and adhered to within the system development deliverables
• Develop and maintain knowledge of data available from upstream sources and data within various platforms
• Collaborate with business and technology partners to elicit information/data requirement and articulate those requirements in a manner that can be easily understood by team members
• May be responsible for the Information Excellence data deliverables including contribution to the overall project business and data requirements documents
• Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis
• Provide support to the development and testing teams to resolve data issues
• Support the user community by helping users interpret the data
• Implement, maintain and enhance Data Governance, Data Quality and related policies, in alignment with TD's Enterprise standards and frameworks in collaboration with the Data Managers/Stewards/Owners
• Ensure requirements are captured regarding privacy and security of data, data governance and access controls
• Comply with well-defined enterprise technology delivery practices and standards and project management disciplines

EMPLOYEE / TEAM

• Work effectively as a team, supporting other members of the team in resolving critical service issues
• Prioritize and manage own workload in order to deliver quality results and meet timelines
• Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest.
• Participate in knowledge transfer within the team and business units
• Continuously enhance knowledge / expertise in own area and keep current with leading-edge technologies trends
• Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team

BREADTH & DEPTH

• Advanced knowledge of the technical environment/tools for own area
• Advanced knowledge of business processes and procedures on a broad, organizational level
• Sound to advanced knowledge of business/organization, Bank standards, infrastructure, architecture and technology in related areas from a design/support/solutions perspective
• Subject matter expert in at least one area of discipline and consults with clients/or project teams with respect to all aspects of research, analysis, design, hardware/software support, development of technical solutions and/or testing
• Works independently in a senior/lead role on a diverse range of tasks and may be relied upon to coach/educate others
• Assignments are moderately to highly complex and multi-faceted
• May provide guidance/direction to others within own area of expertise
• Accountabilities are moderately complex and performed under management guidance
• Generally reports to a Manager or Senior Manager

EXPERIENCE & EDUCATION

• Undergraduate degree or Technical Certificate
• 5-7 years relevant experience
• Required: Ab Initio, Unix Shell Scripting, SQL
• Experience with DB2, Host Mainframe, CA7, and Autosys a plus