Data Designer I
TD Bank Group
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
TD Bank Group seeks a data engineer to translate requirements into robust data pipelines and governance. You will ensure ingestion, curation, and consumption of data, while clarifying designs that support analytics strategies.
The role requires building data models, managing metadata, and validating data flows across the data warehouse. Applicants should have strong SQL, cloud data platform experience (Azure), and exposure to PySpark, with Agile delivery experience.
Qualifications
- Strong SQL skills with data profiling and reconciliation across large datasets.
- Hands-on experience with cloud-based data platforms (Azure) and PySpark.
- Experience working in Agile delivery environments.
- Insurance industry experience is an asset.
Responsibilities
- 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.
- Document, prototype and validate current and future state data flow processes.
- Provide subject matter expertise by identifying relevant business processes affecting data.
Skills
Education
Tools
Job description
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.
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.
- 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 elevate 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
- 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
- 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
- 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
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
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.
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.
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
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.
We’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.
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.
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.
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.
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.
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.
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.
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
