Database Analyst Advisory

4 days ago

Toronto, Canada Scotiabank Full time

Requisition ID: 208841

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

CB Data Services manages the collective data asset for the Canadian Bank. DS team members help design and implement the most appropriate data storage, data movement and data integration solutions to meet immediate project requirements while supporting the long-term direction of the enterprise. We are seeking a highly skilled Data Analyst & Data Modeler to join our dynamic team focused on the development of enterprise data models and data provisioning to target data platforms. Data analysis and architecture skills are needed to design the use and flow of data between systems; through service calls, data federation, replication, data access, evaluation of performance to align with the appropriate technology and infrastructure to ensure solution optimizes technical and business requirements.

**Is this role right for you? In this role, you will**:

- Work with business users to obtain data requirements and analyze source systems data.
- Design and develop conceptual, logical and physical data models for the operational and analytical data models
- Communicate physical database designs to, and work with, database administrator to implement databases
- Document data flows, identify appropriate data sources, entities, relationships and redundancies.
- Manage data integrity and data quality.
- Maintain technical & business metadata. Generate metadata for Hadoop ingestion for different ingestion frameworks.
- Design data structures and document data meanings, definitions and intended use, work with various departments/leaders and data stewards to make the “metadata” available.
- Define and document the data architecture for operational databases, reporting and provisioning platforms, including the physical components and their functionality
- Support data strategies, standards, guidelines data quality process and governance across the enterprise
- Provide leadership in researching and architecting emerging technology solutions to meet business strategies and objectives.

**Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have**:

- Relational and dimensional data modeling and database design, Erwin (Data modeling) skills.
- Strong SQL, Python and some spark knowledge. Hands on Hive (Hadoop) experience.
- Knowledge of data architectural approaches, patterns and emerging technologies (RDBMS, Hadoop and Cloud)
- Exposure and knowledge of Cloud platforms, cloud architecture, capabilities and processes like GCP, Azure is great asset.
- Ability to translate business needs into technical solutions. Strong Analytical skills.
- Experience creating architecture and strategy artifacts
- Experience of XML, JSON, Copybook, CSV files ingestion
- Experience working in Agile environment
- Knowledge of Data Governance process for metadata and lineage management is strong asset. Exposure to any Data Governance tools like IGC, Collibra is an asset.
- Domain Knowledge in financial Services and enterprise functions is strong asset.
- Knowledge of database administration, database performance tuning, source & target data structures, ETL processes & products

**What's in it for you?**
- Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
- Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
- Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
- Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more

Work arrangements: Hybrid

LI-Hybrid

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management

  • Database Analyst Advisory

    1 month ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 208841 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. CB Data Services manages the collective data asset for the Canadian Bank. DS team members help design and implement the most appropriate data storage, data movement and data integration solutions to meet immediate project...

  • Database Analyst Advisory

    2 months ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 208841Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. CB Data Services manages the collective data asset for the Canadian Bank.  DS team members help design and implement the most appropriate data storage, data movement and data integration solutions to meet immediate project...

  • Database Analyst

    7 months ago

    Toronto, Canada Prophecy Technologies Corp Full time

    **Role**: Database Analyst **Location**: Toronto, Ontario - Design, implement, and maintain database systems to ensure high performance, security, and availability. - Conduct data analysis and develop data models to support project requirements and business goals. - Optimize database performance through tuning and query optimization. - Ensure data integrity...

  • Database Analyst Advisory, Scotiabank

    6 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 196092 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. Scotiabank’s Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiabank is present. Physical & logical...

  • Database Analyst

    4 months ago

    Toronto, Canada Total Systems Solutions Consulting Inc. Full time

    **EXPERT DATABASE ANALYST** **THE OPPORTUNITY** The **consultant is expected to start ASAP and the contract length is 2 years.** **Project Context** The BCCDC, an agency of the Provincial Health Services Authority has the mandate to collect and test wastewater and other specimen sources for COVID virus variants. This testing is performed using...

  • Analyst, Real Estate Advisory Group

    3 months ago

    Toronto, Canada Kroll Full time

    Real Estate Advisory Group Analyst - Join Kroll's Global Real Estate Advisory Group Team and gain hands-on experience in the dynamic field of real estate advisory. We are seeking motivated and detail-oriented individuals to contribute as new joiners in our Real Estate practice._ - At Kroll, _Our Real Estate Advisory Group provides comprehensive real estate...

  • Analyst, Investment

    7 months ago

    Toronto, Canada Canaccord Genuity Corp. Full time

    Analyst, Investment & Advisory Solutions Toronto, ON Summary: Canaccord Genuity (CG) is a leading independent full-service financial services firm, with operations in two principal segments of the securities industry: wealth management and capital markets. CG is driven by an unwavering commitment to building lasting client relationships - we achieve this...

  • Consulting Analyst

    6 months ago

    Toronto, Canada Watson Advisors Full time

    Salary: THE OPPORTUNITY WATSON is seeking an Analyst in either its Vancouver or Toronto office to support clients through all aspects of projects as part of WATSON's Advisory Consulting Practice. A key member of the team, the Analyst will work closely with all members of the WATSON team including Partners, Consultants, and Associates to deliver high-quality...

  • Security Analyst

    3 weeks ago

    Toronto, Canada GoSecure Full time

    Summary The Security Analyst in the Advisory Team is responsible for the service delivery in alignment with the cybersecurity assessment (CSA) methodology and processes. The Security Analyst will assist in the delivery process of mandates within a defined timeframe and respecting the allocated budget. Duties and responsibilities ...

  • Analyst, M&a Advisory

    8 months ago

    Toronto, Canada FirePower Capital Full time

    **About FirePower Capital**: Rapid growth in our M&A advisory division requires the addition multiple Analysts to our team. This role is an opportunity for someone with one to three years of experience, who wants to make a real impact on the most entrepreneurial segment of deal-making in Canada. We pride ourselves in being the first name entrepreneurs think...

  • Database Analyst

    6 months ago

    Toronto, Canada SickKids Centre for Community Mental Health (CCMH) Full time

    **POSITION: Database Analyst** **PROGRAM: Information and Communication Technology** **POSITION DETAILS: Full-time, 1 year contract F.T.E 1.0** **COMPETITION: 23-039** SickKids Centre for Community Mental Health (SickKids CCMH) is a community-based children’s mental health centre providing prevention, in-home support, day treatment, outpatient...

  • Analyst, Trade Advisory Group

    6 months ago

    Toronto, Canada MNP Full time

    Inspirational, innovative and entrepreneurial - this is how we describe our empowered teams. Combine your passion with purpose and join a culture that is thriving in the face of change. Make an impact with our Trade Advisory Group as an Analyst. This team of professionals offers expanded scope of fiscal and regulatory advisory services for clients engaged...

  • Technical Analyst Advisory

    7 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 186162 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **The Team** Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank’s Corporate, Investment Banking, and Capital Markets businesses. **The Role** GBME’s...

  • Database Analyst

    7 months ago

    Toronto, Canada Secure Digital Markets Full time

    Salary: **What We Offer** At Secure Digital Markets (SDM), you can build a career out of making things happen! Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada's largest and fastest growing digital assets brokerage, Secure Digital Markets has...

  • Data Analyst Advisory

    6 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 184018 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **Data Analyst** **Is this role right for you?** - Work with business users to obtain data requirements and analyze source systems data. - Design and develop conceptual, logical and physical data models for the operational and...

  • Database Administrator Analyst

    6 months ago

    Toronto, Canada Havergal College Full time

    We are seeking an individual who is inspired by our mission and whose beliefs align with our core values of integrity, compassion, inquiry and courage, and reflects our core competencies to join Havergal College as a **Database Administrator Analyst**. This is a full-time position. **Why Havergal is the Place to Be** Founded in 1894 and located on a...

  • Technical Analyst Advisory

    7 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 199291 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **The Team** The Global Capital Markets Engineering - Global Fixed Income team is a high performing team with the mandate to design, develop, support and execute global technology strategies for Scotiabank with a focus on Fixed...

  • Database Analyst

    7 months ago

    Toronto, Canada Flyinger Solutions Ltd. Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Database Analyst

    6 months ago

    Toronto, Canada Peak Power Inc. Full time

    Education: Secondary (high) school graduation certificate - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data...

  • Data Analyst

    7 months ago

    Toronto, Canada CB Canada Full time

    Data Analyst On behalf of our client in the Banking Sector, PROCOM is looking for a Data Analyst. Data Analyst – Job Description The main function of a Data Analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems A typical Data Analyst is responsible for planning,...