Data Developer - Toronto, Canada - Scotiabank

Description

Requisition ID: 199915

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

The Team

Automotive Finance IT support team is responsible for supporting the technology solutions implementations to drive the bank's automotive business. By joining us, you will be emersed in multiple ecosystems and you will be entraining on a journey of professional and personal development

The Role

As a member of Automotive team, the Data Developer is responsible for operational data support and development for Automotive Finance System applications. The incumbent is responsible for providing specialized development and support work in data integration to and from Enterprise Data Lake and Data Warehouse and development work within our agile lab based on business requirements.

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.
• Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs.
• Demonstrates an informed knowledge of business functions to resolve problems and capitalize on improvement opportunities.
• Exercise good judgment in selecting methods and techniques for obtaining solutions.
• Understand how the Bank's risk appetite and risk culture should be considered in day-to-day activities and decisions.

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

• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse.
• Design and develop physical data model structures in SQL Server
• Design and development of high-quality dashboards / reports using tools like Power BI, SSRS, Crystal Report, Excel/PowerPivot, and Tableau. Develop custom reports, analytics and KPI's for the Business
• Builds and maintain proper documentation, data lineage and extract-transform-load (ETL) processes.
• Collecting business requirements / user stories while working in a lab with a product owner, Business Analyst, Scrum Master, and application developers.
• Developing SQL views to enable data consumers to read data from data warehouse.
• Documenting databases, data process flows and maintain data dictionaries, support and onboarding procedures.
• Troubleshoot and resolve database and application defects in a timely manner with consultation with internal and external groups as needed.
• Train and assist users at all levels.
• Analyze root causes of operational malfunctions including but not limited to batch jobs and provide resolutions.
• Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications.
• Act as an expert technical resource in Data Warehouse/DBs and ETL
• Leverage industry best practices to design, test, implement and support a solution.
• Assure quality, security and compliance requirements are met for supported area.
• Be flexible and thrive in an evolving environment.
• Adapt to change quickly and adjust work accordingly in a positive manner.
• On-call responsibilities to operate as the L2 point of contact for monitoring TIDAL/EDL jobs requests may be required for weekends rotation.

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

• 3-5 years previous experience working within a technically focused environment as a database analyst / data developer.
• Experience with databases such as Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager, MySQL, Crystal Report, Tidal jobs etc.
• Experience working in an agile development team engaged in the SDLC process and SDLC methodologies (agile / waterfall).
• Experience with EDL / Hadoop / Hive / Tableau a plus. Hands-on programming experience and advanced knowledge of SQL.
• Expertise with data visualization / BI tools like e.g., Power BI.
• Clear communication and interpersonal skills required.
• Familiarity with JIRA/SharePoint
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly.
• Experience developing code to consume REST API services and integrating systems with sftp a plus.
• Experience with MS Azure / SQL Server MI / Machine Learning services a plus.
• Experience with databases, dimensional data modeling design.
• Experience with data warehouse, ETL, SSIS, SSAS/cubes a must.
• Experience with implementing DevOps / CIAD a plus.
• Experience with web development (in ASP.NET MVC / C#) a plus.

Technical Environment:

• Database: SQL Server / MS SQL Enterprise Manager / Oracle
• Platform: Microsoft.NET, IIS, SharePoint Online / Azure
• Development Environment: Visual Studio / SSMS
• Languages: T-SQL, C#, .NET, Python
• Source Control: MS Team Foundation Server / Git / Bitbucket / TFS
• Reporting: MS SQL Server Reporting Services, Crystal Reports, SSRS
• Data Visualizations: MS PowerBI / Tableau / Excel

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