Data Designer II

The Toronto-Dominion Bank (Canada); Toronto; On-site; CAD 82,000 - 115,000; Full time

Job summary

TD Bank Group in Toronto, ON is seeking a data-focused role within Technology Solutions to translate business data extraction needs into technical specifications and ensure robust data ingestion and governance. The role collaborates across stakeholders to design, document and validate data flow processes while supporting enterprise data standards.

Ideal candidates have an undergraduate degree or technical certificate with 3+ years in a business/analytics setting, and experience with data

Qualifications

• Undergraduate degree or technical certificate and/or 3+ years of relevant experience in business/analytics.
• Interest or experience in data management, governance or analytics is a plus.

Responsibilities

• Gather and translate business data extraction and consumption requirements into technical specifications.
• Ensure proper data ingestion, curation, and consumption.
• Clarify solution designs that support business strategies and analytical initiatives, especially when requirements are unclear.
• Document, prototype and validate current and future state data flow processes.
• Provide SME guidance to support data governance and data management initiatives.

Education

Undergraduate degree or Technical Certificate

Job description

Work Location: Toronto, Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details: $81,600 - $115,200 CAD This role is eligible for a discretionary variable compensation award that considers business and individual performance. 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:

• Gather and translate business data extraction and consumption requirements into technical specifications.
• Ensure proper data ingestion, curation, and consumption.
• Clarify solution designs that support business strategies and analytical initiatives, especially when requirements are unclear.
• Document, prototype and validate current and future state data flow processes.
• Provide subject matter expertise by identifying relevant business processes affecting data curation and explaining their impact on data.

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 5 + years experience working in Technology space preferred Hands-On Databricks Expertise: Strong experience building and optimizing pipelines using Databricks, including leveraging Databricks Genie for conversational AI/BI solutions. Fabric & Power BI Administration: Demonstrated experience managing Power BI/Fabric tenant settings, capacities, workspace governance, and security models. Enterprise Enablement: Proven ability to teach, mentor, and simplify complex technical concepts for diverse audiences across the business. Effective Communication: Exceptional written and verbal soft skills, with a collaborative, learning-focused mindset for cross-functional alignment. CoE Background (Asset): Prior experience working within an Enterprise Data & Analytics/BI Center of Excellence (CoE) preferred.

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 strive to make every interaction, product, and experience remarkably human and refreshingly simple for 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 foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, that is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues and communities.

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. If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact. We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals. Here at TD, we hire and develop the best.

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.

Language Requirement (Quebec only):

Sans Objet US Labor & Employment Posters | California Privacy | Accessibility | FAQ

Our Values

At TD we’re guided by our purpose to enrich the lives of our customers, communities and colleagues, and share a set of values that shape our culture and guide our behavior. In exchange for how our colleagues show up to help TD succeed, we are committed to delivering a colleague experience grounded in Impact, Growth and a Culture of Care. No matter where you work across TD, we empower you to make an impact at work and in your community, explore and grow your career and be part of our caring and inclusive culture.

Our Commitment to Diversity, Equity, and Inclusion

At TD, we’re committed to fostering an environment where all colleagues are encouraged to bring their authentic selves to work, experience equitable opportunities, and feel respected and supported. We’re dedicated to building an inclusive workforce that reflects the diversity of the customers and the communities in which we live and serve.

Helping to Make an Impact in Communities – TD Ready Commitment

TD has a long‑standing commitment to help drive progress towards a more inclusive and sustainable future. That’s why we launched the TD Ready Commitment in 2018, now a multi‑year North American initiative. Under the TD Ready Commitment, we are targeting a total of C$1 billion by 2030 in community giving across four key, interconnected drivers of change: Financial Security, Vibrant Planet, Connected Communities, and Better Health. It’s our goal to help support change, nurture progress, and contribute to making the world a better, more inclusive place for our customers, colleagues, and communities. Learn more: Canada | US | Europe & Asia Pacific