Data Analytics Development Specialist (Technology Development & BI Data Analytics)

Job title: Data Analytics Development Specialist (Technology Development & BI Data Analytics)

Job description: Requisition ID: 134576

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

The team:
You will be part of the Resiliency Analytics team within the Global Technology Risk and Resiliency group. Our mandate is guiding technology teams within the bank to create and sustain resilient solutions for our customers and business partners. We gather, interpret and present data insights at all management levels including the board and external regulators to reduce risk and increase capability.

The role:
Reporting to the Sr Manager, the Data Analytics Development Specialist (DADS) will be a senior technical contributor to the overall success of the Global Technology Risk and Resiliency Team (GRRT) by ensuring goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. The DADS conducts all activities in compliance with governing regulations, internal policies, and procedures.

The DADS develops and maintains data analytics solutions for technology Risk and Resilience. They will also complete engineering and architecture deliverables and provide technical consultation and direction to team members. The scope includes windows/web-based applications, complex workflows, automation scripts, ETL solutions, executive dashboards and much more. All solutions will be expected to follow technology policies, processes, and procedures. The role will also provide use cases and requirements to feeder-systems so that they may capture data for use by the Global Technology Risk and Resiliency Team

Is this role right for you?

• You have a passion for data, technology, and agile development.
• You create processes and documentation to support stable and resilient solutions
• You are a strong problem solver and able to work independently and drive solutions from the ideation phase to implementation.
• You pick up new technologies quickly and have good insight into tools used within the industry and would be excited to help a team mature on their data analytics engineering journey.
• You are skilled at many of the tools we currently use (Power BI, SQL, SSIS, C#, Excel VBA) and may introduce (python, SharePoint …).
• You have an advanced understanding of ETL and a track record in designing solid solutions using SSIS, Python.
• You have a strong analytical skillset to quickly determine, identify root cause and fix issues.
• You have good understanding of scripting languages.
• You are curious and have a business mindset when developing technology solutions
• You are enthusiastic and open to learn new technologies.

Do you have the skills that will enable you to succeed in this role?

• You have a post secondary education in a technology related discipline.
• You have 3+ years experience as a senior data engineer / designer / architect that involves performance tuning of both online queries and data driven ETL (extract, transform and load) processes.
• You have 2+ years experience and are proficient in creating meaningful reports on MS Excel, PowerBI, DAX, Power Query.
• You have 3+ years of development and maintenance experience in data driven solutions including Data modelling, Database design, Business Intelligence, ETL and Data visualization.
• Your technology stack includes strong experience with most of the following: C#, SQL / SQL Server, SSIS, SSAS (SQL Server Analysis Services), SSRS, SSMS (SQL Server Management Studio), Visual Basic, Power BI, XL Macros, and other scripting languages. Python, Hadoop, Hive and R are assets.
• You can lead through the SDLC and have 2+ years experience with Agile methods and tools.
• You have experience with code repository, version control and code promotion tools such as Git/bitbucket and Jenkins
• You have 3+ years of working experience in writing requirements, architecture documents, or other governance documents associated with application management.
• Your written and spoken English is above average and includes the ability to synthesize complex ideas from various sources.
• You have 1-2 years of predictive analysis and machine learning.
• You can troubleshoot business intelligence modeling issues and develop solutions.
• The following skills would be an asset to your success in the role

o Experience with open-source data integration platforms like Airflow, NiFi
o Experience in storing, manipulating and integrating NoSQL data to BI reporting.
o Experience with Azure cloud platform.
o Experience with Dash/Plotly.
o Experience with ServiceNow or other ITSM solutions.
o Proficiency in Spanish.

What’s in it for you?

• You will be part of the team transforming the way we do and measure Technology services to build reliable and resilient systems for our customers and business partners.
• We foster an environment of innovation and continuous learning. Access to thousands of online and in person courses so you can brush up on skills or learn new ones
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• You’ll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
• We care about our people, allowing them to design how they work to deliver amazing results.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation; health/medical/wellness benefits; employee banking privileges.
• We hire you for your talent and not just for the job. We want to see you succeed not just in your role but in your career as a whole
• Dress codes don’t apply here, being comfortable does
• We are currently working remote with team members in several geographies. Our return-to-work strategy will revolve around activity-based work arrangements where you will partner with your team lead to determine the most effective working arrangement for you given the group’s goals.

The Workplace

• 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!
• You’ll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
• We foster an environment of innovation and continuous learning
• We care about our people, allowing them to design how they work to deliver amazing results
• We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation

Scotiabank
As Canada’s International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. 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.
Is this Role not the Exact fit?
Sign up to stay in touch; we’ll let you know when we have new positions on the team.

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

Company: Scotiabank

Expected salary:

Location: Toronto, ON

Job date: Thu, 16 Dec 2021 01:49:28 GMT

Job Source: Careerjet.ca

Click Here to Apply