Data Designer II

Work Location:

Toronto Ontario Canada

Hours:

37.5

Line of Business:

Technology Solutions

Pay Details:

$81600 - $115200 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:

Job Description

The Data Designer-II (aka Sr. BSA) 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.

Technical Skills:

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

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

#litech

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 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 95000 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:
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.

If youre 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.

Were 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 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

Required Experience:

IC

Employment Type : Full-Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 81600 - 115200