Intermediate Data Analyst to Contribute to Campaign Analytics and Reports Migration for a Large Banking Client - 78466-1

S.i. Systems
Toronto
$89.4K-$120.9K a year (estimated)
Full-time

Position Title : Data Analyst

Line of Business : Frontline & Distribution Analytics

Duration : 6 Months

Remote / Hybrid : Hybrid in office on Wednesday's and 3rd Friday of each month, there is flexibility.

Office Location : 81 Bay St. 17th floor

What does the LOB do? : The frontline performance management and campaign analytics team support the frontline banking employees, measuring benchmarks and targets.

Developing reports through excel or through Salesforce.

What project will this contractor be working on? Standing up new campaign analytics as well as migration of reports to Salesforce.

How You’ll Succeed

Develop actionable insights : Monitor sales performance / activities and propose recommendations on appropriate action plans to close gaps to targets.

Design and implement reports suitable for an executive audience

Ad Hoc Analyses Develop ad hoc analyses to address key business issues as they arise. Complete complex client and product analyses utilizing a variety of structured and unstructured data sources.

Develop and share insights with a wide variety of audiences.

  • Data Visualization Lead the design and strategy on data visualization for new and existing dashboards
  • Project Support : Work with business partners to support key initiatives and projects
  • Work with Partners : You will develop change management strategies and maintain open, collaborative lines of communication to ensure awareness of requirements and impacts.

You will gather critical information on the various management techniques / client issues / concerns, strategic priorities, business challenges and specific project requirements to support the development of a winning value proposition

Business Intelligence & Reporting - Help define business and process requirements and manage deliverables against business partner expectations and time sensitive deadlines.

Develop, improve and maintain ongoing reporting related to frontline measurement, business sales initiatives, marketing leads, financial planning tool usage, product and channel trends

Must Have Requirement :

  • 3- 5 years experience
  • Comfortable with working with large datasets .
  • Experience in designing and delivering the user friendly production report for the multiple users using various BI Platform.
  • Advanced proficiency in SQL / SAS, Alteryx and Tablea u.
  • Advanced excel skills (Format, pivot tables)

Nice to have : Python experience

Python experience

  • Databricks experience
  • Banking experience
  • Salesforce CRMA experience building dashboards
  • 30+ days ago
Related jobs
S.i. Systems
Toronto, Ontario

IT Infrastructure Analyst to consult, deploy, and support technology vendor products and solutions for a large insurance client -. Develop and maintain design specifications that meet technical, functional and non functional requirements and conform to service definition, geographical requirements, ...

BMO
Canada, Canada

Works with other data and analytics professionals to optimize, refine, automate and scale analysis into repeatable analytics solutions and decision support tools. Designs dashboards and analyses to be performed, and appropriate visualization and analytics tools to use. Researches and applies continu...

S.i. Systems
Toronto, Ontario

Review application and program design or technical infrastructure design to ensure adherence to standards and to recommend performance improvements. Experience in building strategy and roadmaps for information, and security initiatives (IT and OT). Advises on the identification, analysis, and resolu...

Allstate Insurance Company
Markham, Ontario

Reporting to the Manager, Data & Analytics Digital Transformation, you will be providing key technical expertise to acquire, investigate, manipulate and analyze data to support Allstate Canada Group's business plans and results. Experience with analytics platforms and methodologies (data lake, d...

S.i. Systems
Toronto, Ontario

Act as a key liaison between our organization and the elite client, fostering strong relationships and ensuring client satisfaction throughout the project lifecycle. Collaborate with internal stakeholders to devise strategic plans that align with the client’s business objectives, offering innovative...

KPMG
Canada, Canada

Planning and executing day-to-day activities of advisory engagements for a variety of clients including data strategy and roadmap development, business process analysis, current state assessment and future state process design, data and business case analysis and tailoring recommendations specific t...

CPP Investments
Toronto, Ontario

As a crucial part of the team, the responsibilities include assisting in the implementation of enterprise-wide key performance and/or operating indicators for specific cost categories, supporting the execution of departmental and project financial plans and forecasts and independently executing mont...

Deloitte
Toronto, Ontario

This includes, but is not limited to, people with disabilities, candidates from Indigenous communities, and candidates from the Black community in support of living our values, creating a culture of Diversity Equity and Inclusion and our commitment to our AccessAbility Action Plan , Reconciliation A...

Scotiabank
Toronto, Ontario

Yes, you'll be helping create and delivering presentations on and off-campus, building and maintaining a pipeline of suitable candidates across various geographies through all stages of the recruiting pipeline, managing social media deliverables, planning, managing and executing events and large-sca...

Deloitte
Toronto, Ontario

Experience in delivering a broad range of data analytics engagements in areas such as, Data Strategy, Data Architecture, Data Migration, Data Analytics, Data Governance and Data Quality. As a Manager or Senior Manager, you will be leading engagement and client teams across data and analytics domains...