Job description
Requisition ID: 178401
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team
GOCT – International CRM Data and Analytics Team provides data management and analytical solutions to support business intelligence and reporting (Financial Risk, Regulatory and Executive Management) on customer relationship management activities.
The Role
The Data Analytics Specialist contributes to the overall success of the IB CRM Support team by actively participating in the Development, Operations and Maintenance of the Data Marts, the Analytical solutions based on Power BI platform and the Infor Omni Channel Campaign Management application.
Some of the Key Accountabilities include:
- Develop and maintain complex reports and supporting data structures on Power BI and Web Browser based reports on Infor Omni Channel Campaign Management application.
- Manage user access to these reports.
- Provide hands-on operational support over the execution of the daily/weekly/monthly production cycles as well as on-demand data extractions from various data providers including certified data sources and BNS applications
- Deliver on International Banking Caribbean CRM data management strategy through the day-to-day support of relational data models with a focus on data delivery through managing data ingestion, transformation, exception identification, data investigations and troubleshooting.
- Maintain a strong working relationship with peers across the business lines including key stakeholders in International Retail Products and Marketing, Customer Insights, and Global Risk Management
- Support, maintain and enhance International Banking Infor Omni Channel campaign management solution (Epiphany) and Customer centric Caribbean data mart
- Provide advice in the form of day-to-day technical support to team members and user community. Contribute to the team Agile culture and leverage Scrum and Kanban in daily activities
What You Will Bring to Succeed
- 5+ years of experience in data warehousing, data analysis and Reporting based on Power BI/ Tableau or other reporting tools. Preference is for Power BI.
- Strong knowledge of Microsoft SQL Server ecosystem Data Tools including SSMS, SSIS, SSAS and Visual Studio is a must.
- Hands-on experience in ETL and query tools including SAS, T-SQL, SSIS, “dbVisualizer” will be a plus.
- Experience in Atlassian Jira/Confluence, GIT, TFS/Azure DevOps
- Proven interpersonal, analytical and problem resolution skills
- Effective communication and presentation skills (written/verbal)
- University degree in Software Engineering/Computer Science related field
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
#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. 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.
About Scotiabank
CEO: Scott Thomson
Revenue: $10+ billion (USD)
Size: 10000+ Employees
Type: Company - Public
Website: http://www.scotiabank.com
Year Founded: 1832