You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Data DevOps Manager

Toronto, ON
Full Time
2 days ago

Requisition ID: 107727

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Brief Description of Department:
The Enterprise Compliance and Regulatory Systems team is accountable for developing and supporting a number of compliance and risk management related data and reporting systems within the Bank.   The team is seeking a Data DevOps Manager to integrate data from source systems and to develop dashboards and reports for users.  The incumbent will be joining a team of solution developers and architects that focus on systems utilized in compliance and risk management.
Key Accountabilities :
Reporting to the Senior Manager - Development of Enterprise Compliance and Regulatory Systems, the incumbent will be responsible for the following:
  1. Manage and lead developers to complete data project initiatives / deliverables on time and within budget
  2. Design and develop technical data solutions to enable data ingestion and related processes in accordance with bank standards
  3. Develop and enhance Azure DevOps pipelines to automate deployment and continuous integration of solutions
  4. Manage and maintain data governance related artifacts and documentation for systems
  5. Plan, maintain, upgrade, scale out, execute data platform infrastructure deployment and services
  6. Design and develop physical data model structures and dimensional data models in SQL Server
  7. Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot
  8. Interact with development, architecture, business and technology services groups on a regular basis
  9. Investigate data quality issues and determine root cause, resolve any data issues and recommended process change to prevent reoccurrence
  10. Prepare database object deployment Data Definition Language(DDL) and Data Manipulation language(DML) scripts for IST, UAT and Prod environments
  11. Adopt standards and best practices around Data Management and deployment efforts
  12. Ensure data warehouse and data mart designs efficiently to support end users.
  13. Support enhancing the technical documentation to align with the most recent templates
  14. Integrate systems via REST API, database views, SharePoint lists, sFTP, direct database connections with other databases/data marts etc
  15. Document and maintain databases, data process flows, data dictionaries, support and onboarding procedures
  16. Operationalize processes with First Level Service Desk team as part of productionization of new data solutions
Skills Required / Functional Competencies:
  1. Experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc
  2. Experience in developing BI reports and completing ad hoc queries and data analysis required
  3. Experience with data visualization / BI tools eg. Power BI, SSRS required
  4. Experience with Azure DevOps pipelines / Artifactory required
  5. Clear communication and interpersonal skills required
  6. Attention to detail and feedback from clients on dashboards and reports must be completed rapidly
  7. Experience developing code to consume REST API services and integrating systems with sftp a plus
  8. Experience with MS Azure / SQL Server MI / Machine Learning services a plus
  9. Experience in data modeling and dimensional data modeling a plus
  10. Experience with SDLC methodologies required eg. Agile / Waterfall
  11. Experience with data warehouse, ETL, SSIS, SSAS/cubes a plus
  12. Experience integrating systems with COTS Commercial Off The Shelf software packages a plus
  13. Experience with EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus
Technical Environment:
  1. Database:  SQL Server / MS SQL Enterprise Manager / Oracle
  2. Platform: Microsoft.NET, IIS, SharePoint Online / Azure
  3. Development Environment:  Visual Studio / Jupyter Notebook
  4. Languages: T-SQL, C#, .NET, Python
  5. Source Control:  MS Team Foundation Server / Git / Bitbucket
  6. Reporting: MS SQL Server Reporting Services
  7. Data Visualizations:  MS PowerBI / Tableau / Excel
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.

Job Segment: Database, Bank, Banking, Developer, Oracle, Technology, Finance

Information Technology