Data - Business Systems Analyst (Etl) [Scotiabank]

Requisition ID: 178959

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

The Team

The Wealth Data team within the Global Wealth Engineering (GWE) team is key area in meeting the operational data needs of the various stake holders within Wealth Management.

The Data BSA will be a key resource in sourcing the data from the core wealth systems and transforming the data to meet the business objectives. Working on multiple projects; the candidate will be a key member to identify the data sources and apply business logic to meet consumers needs. Working on multiple projects, the candidate will work with POs, data engineers and architects and subject matter experts in the entire life cycle of data from sourcing to processing to distribution to consumers.

Is this role right for you?

• Analyzes & acquires data from primary and secondary data sources – creating mapping specifications for use by development resources
• Participate in detailed discovery of data from the source, mapping the data to the data model after thorough analysis.
• Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats
• Documents, plans for collection, data cleansing, and normalization of data
• Build expertise in various data domains and take ownership of assigned data domains and be a single point of contact
• Work with development team to design solutions for API, Batch etc. Participate in technical design sessions, working with technical resources, to provide insight during solution development
• Evaluation of data identified from multiple sources, reconcile conflicts and classification of data in logical categories
• Work with Product Owners and Business representatives to understand requirements, create stories and specs and groom developers and QAs accordingly.

Do you have the skills?

• Previous experience in Wealth management and/or banking systems highly desirable
• Experience working in Agile/ Lean delivery teams
• Excellent verbal, written and presentation skills
• Ability to effectively convey ideas to business and technical teams
• Should be a team player and work collaboratively
• Advanced skills using Excel spreadsheet and VBA.
• Highly analytical and good understanding of databases, technical architecture, and query tools
• Ideally some hands-on experience in ETL work and knowledge of ETL tools
• Ability to work with cross functional teams
• Ideally 7+ years' experience in technical system analysis within a development team.
• Knowledge of programming languages such as Java, Python, Scala etc much desirable
• Advance knowledge of writing complex SQL queries
• Experience in working with SQL and NoSQL tools
• Ability to adapt and quickly adjust to change
• Knowledge of data streaming and technologies such as Kafka, Spark-streaming etc. is an asset

What's in it for you?

• We care about our people, allowing them to design how they work to deliver amazing results
• We foster an environment of innovation and continuous learning
• You will get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
• We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation
• We are technology partners who help the business transform how our employees around the world work
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!

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 and private banking, corporate and investment banking, and capital markets.

At Scotiabank, 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. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here . Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.