JOB DESCRIPTION:

The Data Designer II role 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.

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
• Technical skills must include :
• 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 must includes:
• 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.

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 deliver legendary customer experiences to 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 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 you’ve 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, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

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