Data Designer I

Work Location: Toronto, Ontario, Canada

Hours: 37.5

Line of Business: Technology Solutions

Pay Details: $69,700 - $98,400 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

• Develop and promote data models using industry standard modeling tools

• Assess business requirements by researching / analyzing and documenting business data requirements

• Define, build and manage data dictionary / catalog for respective data platforms, systems / servers /applications

• Ensure metadata and data lineage is captured and compatible with enterprise metadata and data management tools and processes

• Run quality assurance reports and resolve data integrity issues to ensure accurate reporting and data records

• Gather, review, analyze, profile, validate, and map system data into the prototyping solution for further integration within data warehouse. Ensure reporting and analytical business needs are met

• Develop solutions and recommendations for improving data quality and data integrity issues.

• Analyze data issues and work with development teams to resolve issues

• Understand data initiatives and capabilities, data governance principles and how they apply to the business segment

• Ensure business data and information is retained and disposed in compliance with enterprise data standards, policies and guidelines

• Contribute to various data activities and processes as assigned

• Be knowledgeable of practices and procedures within own area of responsibility and keep updated on emerging trends for own functional area

• Protect the interests of the organization – identify and manage risks, and escalate non-standard, high risk activities as necessary

• Participate in and help implement continuous process / improvements

• Identify, recommend and effectively execute standard practices applicable to the discipline

• Adhere to internal policies/procedures and applicable regulatory guidelines

• Keep updated on emerging issues, trends, and evolving regulatory requirements and assess potential impacts; Maintain 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 successful delivery of data solutions.

• Facilitate data analysis and investigations for business users and QA teams, assisting with data issues and validating business cases during development and testing phases

• Provide support 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 a goal of ensuring smooth integration of data into source code repositories and promoting effective source code management practices.

• Be an active participant of 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.

• Understand data governance and data management initiatives to ensure 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 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 across teams.

• Help safeguarding the organization's interests by identifying business risks, while ensuring compliance with internal policies and regulatory guidelines.

• Stay current on industry trends, growing knowledge of business processes, data tools, and best practices to improve collaboration between business and technology teams.

• Adhere to internal policies/procedures and applicable regulatory guidelines

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

• Support the team by continuously enhancing knowledge / 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 the success of the team by willingly assisting others in the completion and performance of work activities; provide training, coaching and/or guidance as appropriate.

• 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:

• Experienced working professional role providing specialized business support, within their own area of specialty

• Requires experienced, conceptual and practical knowledge within their own specialty

• Strong analytical and problem-solving skills and fluent in at least one programming language

• Lead projects or work streams within broader projects with moderate risk and may be accountable for managing ongoing activities processes and functional programs

• Accountable for own work and sometimes others; acts as an escalation point or knowledge resource for others in their own area

• Experience working with very large datasets and familiarity with big data technologies

• Able to work with minimal direction on multiple projects and priorities

• 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 in Computer Science, Information Technology, Data Management, Engineering, Mathematics, Analytics or a related field

• 3+ years of relevant experience in data engineering, data management, data analysis, business systems analysis, data modeling, or a related technical discipline

• Strong SQL skills with experience performing data profiling, reconciliation, analysis, and troubleshooting across large datasets.

• Hands-on experience with cloud-based data platforms, including Azure Data Factory, Azure Databricks, Synapse Analytics, Data Lake Storage, and related Azure services.

• Strong proficiency in Python and PySpark, with hands-on experience developing, validating, and troubleshooting data pipelines, transformations, and scalable data solutions.

• Experience working with ETL/ELT frameworks, data pipelines, and cloud-based data processing solutions.

• Experience validating data solutions through data profiling, reconciliation, quality assurance, and root cause analysis to ensure alignment with business requirements and data quality standards.

• Strong analytical mindset, critical thinking, and problem-solving skills.

• Ability to solve complex problems involving multiple upstream and downstream data sources.

• Experience leveraging AI-enabled tools (e.g., GitHub Copilot) to improve productivity, code quality, data analysis, and solution delivery.

• Experience working within Agile delivery environments, utilizing Agile tools and ceremonies, and collaborating with business stakeholders, engineers, and quality engineering teams.

• Insurance industry experience is considered an asset.

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.

We look forward to hearing from you!

Language Requirement (Quebec only): Maîtrise d’une langue autre que le français pour offrir du soutien ou traiter avec des employés ou des collègues qui ont besoin de services et de soutien dans une langue autre que le français.