Data Designer I

The Toronto-Dominion Bank; Toronto; On-site; CAD 65,000 - 99,000; Full time

Job summary

A leading financial institution in Toronto is seeking a Data Analyst to develop data models, ensure data quality, and collaborate with various teams. The ideal candidate will have strong SQL skills and experience with data governance principles. This role offers a competitive salary range of CAD 65,600 - CAD 98,400 and the opportunity to grow within a dynamic work environment.

Benefits

Health and well-being benefits

Career development programs

Paid time off

Qualifications

• 2 years of relevant experience from a business administration, statistical, mathematical, scientific, or financial background.
• Experience working with very large datasets.
• Familiarity with data governance principles.

Responsibilities

• Develop data models using industry standard tools.
• Ensure data integrity and quality assurance.
• Collaborate with teams for data solution delivery.

Skills

SQL Database

Data analysis

Communication skills

Big Data technologies

Hadoop

Apache Spark

Education

Undergraduate degree or Technical Certificate

Tools

MS Access

Visualization tools

Job description

Work Location :

Toronto Ontario Canada

Hours : 37.5

Line of Business : Technology Solutions

Pay Details : 65600 - $98400 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 candidates 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 : 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 organizations 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 or Technical Certificate and / or

2 years of relevant experience from a business administration statistical mathematical scientific or financial background

Strong experience with SQL Database.

Experienced in working with MS Access.

Change Management experience.

Very good communication skills.

Who We Are :

TD is one of the worlds 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 95000 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 youve 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 were 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 :

Were delighted that youre considering building a career with TD. Through regular development conversations training programs and a competitive benefits plan were 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 youre interested in a specific career path or are looking to build certain skills we want to help you succeed. Youll 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 were committed to helping you identify opportunities that support your goals.

Training & Onboarding

We will provide training and onboarding sessions to ensure that youve got everything you need to succeed in your new role.

Interview Process

Well 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 youd 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

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 65600 - 98400