Work Location:

Toronto, Ontario, Canada

Hours:

37.5

Line of Business:

Technology Solutions

Pay Details:

$76,800 - $115,200 CAD

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.

As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

Job Description:

The Data Designer II role is a pivotal role that combines extensive data design expertise with business analysis skills. This role focuses on translating business needs into technical data solutions, ensuring data quality, and facilitating data-driven decision-making. The individual will leverage their in-depth experience in data warehousing, particularly within the Microsoft Azure stack, to drive data analysis, requirements gathering, and solution design.

Key Responsibilities:

• Data Design and Analysis: Utilize extensive data design expertise to analyze and interpret complex data sets, ensuring data quality and integrity. Develop and maintain data models, schemas, and data dictionaries to support business requirements.
• Technical Solutions: Translate business needs into technical data solutions, leveraging the Microsoft Azure stack. Design and implement data warehousing solutions, ETL processes, and data pipelines to support data-driven decision-making.
• Stakeholder Collaboration: Work closely with Scrum Masters (SMs), Product Owners (POs), and Team Leads (TLs) in an Agile methodology. Facilitate communication between technical and non-technical stakeholders to ensure alignment of project goals and deliverables.
• Documentation and Artifacts: Maintain necessary artifacts, including requirements documentation, data flow diagrams, and technical specifications. Ensure all documentation is up-to-date and accessible to relevant stakeholders.
• Agile Methodology: Participate in Agile ceremonies, including sprint planning, daily stand-ups, and retrospectives. Contribute to continuous improvement initiatives to enhance team performance and project outcomes.

CUSTOMER

• Provide expert guidance within projects and other various change initiatives to support data impact assessments and data risk mitigation
• Implement processes aligned to data information management standards and ensure data quality (e.g., rules / thresholds / assessments, etc.) and requirements are developed
• Develop and maintain knowledge of available data from upstream sources and various platforms
• Identify critical data / critical data elements to support Business Segment data governance and/or data management frameworks / programs
• Ensure business data and information is retained and disposed in compliance with enterprise data standards, policies and guidelines
• Perform data profiling using TD tooling and ad hoc system query languages to validate data prototyping solutions
• Provide support throughout data lifecycle to resolve data issues and support user community by helping users interpret the data
• Lead the investigation of root causes for data issues and ensure data issues are resolved while developing the prototyping solution
• Identify and/or define knowledge transfer and data expertise activities to support business teams using the information management solutions.
• Adhere to enterprise frameworks or methodologies that relate to data activities for business area
• Ensure business operations follow applicable internal and external requirements (e.g. financial controls, segregation of duties, transaction approvals and physical control of assets)
• Collaborate with business partners/ stakeholders to ensure project success
• Collaborate on business requirements by researching / analyzing and documenting business data requirements
• Participate in cross-functional / enterprise / initiatives as a subject matter expert helping to identify risk / provide guidance for complex situations
• Conduct meaningful analysis at the functional or enterprise level using results to draw conclusions, make recommendations, assess the effectiveness of programs/ policies/ practices
• Keep updated on emerging issues, trends, and evolving regulatory requirements and assess potential impacts
• Promote a culture of risk management and control, supported by effective processes in alignment with risk appetite

SHAREHOLDER

• Collaborate with technology and business teams to ensure alignment and guide successful delivery of data solutions.
• Facilitate data analysis and investigations for business users and QA teams, assisting with complex issues and validating business cases during development and testing phases
• Provide oversight on business impact post-implementation, ensuring the data solution meets the intended business outcomes during the warranty period.
• Coordinate business requirements with technical teams with an oversight of ensuring smooth integration of data into source code repositories and promoting effective source code management practices.
• Lead or participate in business and technical design reviews, ensuring that data architectures meet both operational and business objectives.
• Raise and manage change requests in collaboration with business stakeholders, supporting release management processes and ensuring timely delivery.
• Lead initiatives on data governance and data management by ensuring business requirements align with enterprise data governance policies.
• Ensure business metadata and data lineage are well-documented and integrated with enterprise metadata management tools, facilitating better business understanding.
• Adhere to and promote best practices for data security, ensuring both technical and business aspects are protected from common vulnerabilities.
• Document business requirements and technical decisions, ensuring risks, lessons learned, and enhancement opportunities are communicated effectively across teams.
• Safeguard the organization's interests, identifying and managing business risks, while ensuring compliance with internal policies and regulatory guidelines.
• Stay current on industry trends, expanding knowledge of business processes, data tools, and best practices to improve collaboration between business and technology teams.
• Enable cross-functional collaboration, sharing knowledge and best practices between business users and technology teams to enhance overall project success.

EMPLOYEE / TEAM

• Participate fully as a member of the team, support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest
• Provide thought leadership and/ or industry knowledge for own area of expertise in own area and participate in knowledge transfer within the team and business unit
• Keep current on emerging trends/ developments and grow knowledge of the business, related tools and techniques
• Participate in personal performance management and development activities, including cross training within own team
• Keep others informed and up-to-date about the status / progress of projects and / or all relevant or useful information related to day-to-day activities
• Contribute to team development of skills and capabilities through mentorship of others, by sharing knowledge and experiences and leveraging best practices.
• Lead, motivate and develop relationships with internal and external business partners / stakeholders to develop productive working relationships.
• Contribute to a fair, positive and equitable environment that supports a diverse workforce
• Act as a brand ambassador for your business area/function and the bank, both internally and/or externally

BREADTH & DEPTH:

• Expert level professional role, considered subject matter expert with in-depth knowledge / expertise in own domain / field of specialty and working knowledge of broader related areas
• Requires expert level conceptual and practical knowledge for own area of specialty and knowledge of broader related areas
• Advanced analytical and problem-solving skills and fluent in one or two programming language
• Works autonomously on a range of tasks and may be relied upon to coach / educate others
• Lead projects of moderately to complex risk and resource requirements; may lead end-to-end processes or functional programs
• In-depth experience working with very large datasets and familiarity with big data technologies
• Keep abreast of rapid business and technology innovation within business information management field
• Familiar with visualization tools
• Generally reports to a Senior / Manager role

EXPERIENCE AND / OR EDUCATION

• Undergraduate degree or Technical Certificate and/or
• 3+ years of relevant experience from a business administration, statistical, mathematical, scientific or financial background
• Technical skills must include:
• Data Warehousing: Proficient in data warehousing concepts and technologies, with a focus on the Microsoft Azure stack. Experience with Azure SQL Data Warehouse, Azure Data Factory, and other Azure data services.
• ETL Processes: Expertise in designing and implementing ETL processes to extract, transform, and load data from various sources. Familiarity with tools such as SSIS, Azure Data Factory, and other ETL technologies.
• Data Models: Familiarity with data models, including snow flake and star schema Datawarehouse models, schemas, and data dictionaries. Experience with both relational and dimensional data modeling techniques.
• SQL: Advanced SQL skills, including the ability to write complex queries, optimize query performance, and troubleshoot SQL-related issues.
• Business Analysis: Strong business analysis skills, including the ability to gather and document requirements, conduct gap analysis, and develop functional specifications. Experience with tools such as JIRA, Confluence, and other business analysis tools.
• Soft skills must includes:
• Communication: Excellent communication skills, both written and verbal. Ability to effectively communicate complex technical concepts to non-technical stakeholders.
• Problem-Solving: Strong problem-solving skills, with the ability to identify and resolve issues quickly and efficiently.
• Collaboration: Proven ability to work collaboratively in a team environment, with a focus on achieving project goals and delivering high-quality results.
• Adaptability: Ability to adapt to changing project requirements and priorities, with a flexible and proactive approach to work.

Who We Are:

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.

TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

Our Total Rewards Package
Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more

Additional Information:
We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

Colleague Development
If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.

Training & Onboarding
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process
We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation
Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Language Requirement (Quebec only):

Sans Objet