Senior Data Analyst/ETL Developer
TD Bank Group
Toronto, Canada
20d ago

TD Description

Tell us your story. Don't go unnoticed. Explain why you're a winning candidate. Think "TD" if you crave meaningful work and embrace change like we do.

We are a trusted North American leader that cares about people and inspires them to grow and move forward.

Stay current and competitive. Carve out a career for yourself. Grow with us. Here's our story :

Department Overview

Building a World-Class Technology Team at TD

We can't afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it a business imperative for us to be smart and open-

minded in the way we think about technology. TD's technology and business teams become more intertwined as new opportunities present themselves.

This new era in banking does not equal boring. Not at TD, anyway.

TD Data and Information Management covers building, developing, designing, and implementing involved with tech data management solutions.

  • Where do we begin? These experts analyze, design, develop and support TD's info management system; lead and support bank data curation;
  • develop data road map and info management strategies; focus on complex data integration, and drive use of our data reference model.

    This area doesn't work in isolation. We love data and we feel the same about integration and our assignments prove it.

    There's room to grow in all of it.

    Wealth Information Management Team

    Information Management is a data team. We support many different data needs of varying priority. We need to create data pipelines, establish master data management, perform data transformations, cleanse and validate data, scale our transactional data, perform batch processing, and run advanced reports and analytics.

    Our team requires to a build a next generation data warehouse platform utilizing enterprise Hadoop data lake (EDPP) and RDBMS to support advanced reporting and analytical needs of our LOB.

    Job Type Regular Job Status Full Time Hours Mon-Fri Business line Corporate Job Category - Primary Technology Solutions Job Category(s) Technology Solutions Job Description

    About This Role

    We need someone to provide technical leadership covering a range of data analysis functions. These include 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.

    You're a solid, independent, senior lead equipped to manage and direct activities related to analysis, design and support of technical data management solutions for larger projects.

    Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here's some of what you may be asked to perform :

  • Elicit, analyze, interpret business and data requirements to develop complete business solutions, includes 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 and on-going data platforms for those development projects aligned to business or organizational strategies.
  • Design, implement reporting platforms (e.g. modeling, ETL, BI framework) and complex ETL frameworks that meet business requirements.
  • Work with technology / project teams to understand the business meaning of data, provide analysis and requirements so that data design is fully understood and the development initiatives are in line with intended design and standards.
  • Deliver business or enterprise data deliverables (that adhere to enterprise frameworks) for various platforms / servers / applications / systems.
  • Provide data analysis and requirements within enterprise platform (e.g. Hadoop).
  • Implement processes aligned to data management standards, ensure data quality and requirements are embedded in / adhered to within system development deliverables.
  • Develop, maintain knowledge of data available from upstream sources and data within various platforms.
  • Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis.
  • Help development and testing teams resolve data issues.
  • Support the user community by helping them interpret data.
  • Engage with data managers, stewards and owners to implement, maintain, enhance data governance, quality and related policies, aligning with TD's standards and frameworks.
  • Ensure capture of requirements related to data privacy and security, governance and access controls.
  • Respect TD's technology delivery practices, standards, project management disciplines.
  • Job Requirements

    This position requires extensive understanding of Business Intelligence, Data Warehousing, Big Data Architecture and related work experience

    Must Haves :

  • Undergraduate Degree or Technical Certificate.
  • Graduate Degree preferred.
  • 5 -7 years relevant experience with specialty in big data integration, data warehouse, analytics, reporting and data-visualization.
  • Extensive knowledge of data architecture and modeling.
  • Prior experience with data modeling tools such as Power Designer, Erwin, ER Studio, Info-Sphere.
  • 5+ years' development experience with MSBI (SQL Server, SSIS, SSAS, MDX)
  • 3+ years' development experience with Tableau
  • 3+ year's of development experience in Hadoop stack (e.g. MapReduce, Spark, Sqoop, Pig, Hive, HBase, Flume, Kafka and emerging technologies)
  • 3+ years' experience with Agile delivery methodology, particularly Scrum and related tools (e.g., Confluence, JIRA).
  • Prior experience in a development area with hands on expertise in software development in various technology types (J2EE, .NET, etc.) an asset.
  • Prior experience with related / complementary open source software platforms and languages (e.g. Java, Unix, Linux, Apache, R / Python / Scala) an asset.
  • Expert knowledge of ETL processing and data-warehousing storage
  • Extensive knowledge of data testing with ETL applications (Testing automation experience is an asset)
  • 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, standards, infrastructure, architecture and technology from a design / support / solutions perspective.
  • Consulted as expert subject matter expert in at least one area of discipline to support clients / or project teams with research, analysis, design, hardware / software support, solutions development and testing.
  • History as a collaborative team player, strength in communicating clearly with partners to elicit information / data requirements.
  • Capacity and eagerness to work independently as a senior / lead role on multiple tasks, and also coach / educate / guide / direct others.
  • Ability to assume assignments that are moderate- to highly- complex and multi-faceted, to be performed under management guidance.
  • Nice to Have

  • Background knowledge on TD applications is an asset
  • Development experience with Talend Data Integration is an asset
  • Knowledgeable in many of followingsSeveral RDBMSes such as : Microsoft SQL Server 2012+, IBM Netezza, DB2, OracleETL, Data Quality and Data Profiling tools : SSIS, IBM Data Stage, Podium, Talend, Pentaho, InformaticaSAS , Cognos, or other BI, analytics, and reporting tools
  • Knowledge of Teradata Financial Services Data Model (FSDM)
  • Knowledge of general banking business model, technologies, operations, governance and regulatory environment is desirable.
  • Experience working in both a technical and business context
  • Additional Information

    Join in on what others in TD Technology Solutions are doing :

  • Inspire a positive work environment and help champion quality, innovation, teamwork and service to the business.
  • Learn voraciously, stretch your thinking, share your knowledge and educate others.
  • Communicate and collaborate with both technical and non-technical professionals.
  • Cultivate winning relationships by building trust with business and technology partners.
  • Share our commitment to productivity, effectiveness and operational efficiency.
  • Embrace change and witness amazing things happen from the inside.
  • Make your mark. Join a dynamic team. Explore new ideas. This is your opportunity to impact the future of banking technology in areas and ways you've never imagined (at a bank)! Visit to learn more.

    Inclusiveness

    At TD, we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported.

    We are dedicated to building a workforce that reflects the diversity of our customers and communities in which we live and serve.

    If you require an accommodation for the recruitment / interview process (including alternate formats of materials, or accessible meeting rooms or other accommodation), please let us know and we will work with you to meet your needs.

    Apply
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form