Work Location:
Toronto, Ontario, Canada
Hours:
37.5
Line of Business:
Technology Solutions
Pay Details:
We're committed to providing fair and equitable compensation to all our colleagues. As a candidate, we encourage you to have an open dialogue with a member of our HR Team and ask compensation related questions, including pay details for this role.
Job Description:
Manage and/or lead a team of technology Data Analysts / Data Modelers responsible for the design of the Enterprise Datawarehouse Data in Azure Databricks. The role will provide oversight and governance to the enterprise data model, enforcing data modeling best practices and efficient data model design. Role will be a technical expert in the field of data modeling with experience in cloud based data warehouses.
Want more jobs like this?
Get jobs delivered to your inbox every week.
Job Description:
KEY ACCOUNTABILITIES:
CUSTOMER
- Build, oversee and manage diverse team of data modelers and related operations and set team goals / objectives in alignment with overall Business strategies
- Work with our product owners, analysts, data architects, ETL developers, and other members of the Data modeling team to develop, maintain and enhance data models and objects associated with enterprise data warehouse(s).
- Provide guidance related to security, governance, and best practices as it relates to databases and data modeling.
- Expertise in relational, dimensional and data vault 2.0 data modeling techniques.
- Able to work independently with minimal direction to meet commitments.
- Establish and enforce enterprise data modeling principles and best practices.
- Prior exposure to and experience working in Agile methodology.
EMPLOYEE / TEAM
- Responsible for management of the overall data modeling team providing both leadership and technical guidance, setting targets and objectives for the team in delivering results
- Grow team expertise and organizational capabilities to align with enterprise demand and the Bank's business / technology direction, assess team skills and capabilities and continually look for ways to provide and enhance the value delivered
- Foster an environment / culture that encourages productivity, innovation, continuous process improvement, teamwork and a high level of professionalism
- Continuously enhance knowledge / expertise in own area and keep current with leading-edge technologies trends
- Prioritize and manage own workload in order to deliver quality results and meet timelines
- Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest
- Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team
- Establish effective relationships across multiple business and technology partners, program and project managers
- Participate in knowledge transfer within the team/ business units
BREADTH & DEPTH
- Deep understanding and hands-on experience implementing a data warehouse in the cloud.
- Complete understanding and expertise with various Data warehouse technologies including Database Management Systems, BI Tools and ETLs
- Strong knowledge of when to use traditional vs big data solutions in the cloud
- Extensive experience in leading and designing complex data-intensive applications.
- Generally reports to an Executive role with broader mandate
EXPERIENCE & EDUCATION
- Minimum 10 years of prior data modeling experience
- Experience with dimensional, relational and data vault 2.0 data modeling techniques experience implementing physical data models.
- Experience implementing database objects, deployment activities
- Experience with PowerDesigner modeling tool or other data modeling tools
- Strong knowledge of data modeling principles and best practices
- Strong communication skills; experience communicating with data engineers, data analysts, business users, and management to explain technical and functional concepts
- Understanding of enterprise data architecture principles
- Strong data analysis and SQL writing skills; including query performance tuning
- Experience writing and executing complex SQL
- Demonstrated success working in a team-based, agile environment
- Strong facilitation and negotiation skills
- Ability to multitask in a fast-paced environment
- Need to be team player, servant leader mindset
- Proficiency in SQL and other data querying languages.
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.
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.
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. 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 we're committed to helping you identify opportunities that support your goals.
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:
N/A.