Senior Business Systems Reporting Analyst

1 month ago


Toronto, Ontario, Canada Markel Canada Limited Full time
Job Title: Senior Business Systems Reporting Analyst

Markel Canada Limited is seeking a highly skilled Senior Business Systems Reporting Analyst to join its Data Analytics team. As a key member of the team, you will be responsible for supporting data requests, developing scripts, and creating dashboards in PowerBI.

Key Responsibilities:
  • Lead and facilitate research and assessment of new data-related solutions and integration approaches and technologies for potential use within the organization.
  • Lead, influence, and engage with business representatives to scope, define, and document insurance product reporting requirements.
  • Empower internal clients on the usage of current BI tools and work with technical teams to determine the best way to present data.
  • Participate in end-to-end requirements, design, implementation, testing, and production data request initiatives in integration projects and reporting tools enhancements.
  • Maintain and create new queries, SQL scripts, store procedures, SQL views, SSRS reports, and thorough understanding of current application DB structures and limitations.
  • Maintain and create Data Lake ETL rules, data models, data mining activities of current Data Lake application structures and limitations.
  • Hold vendors accountable for solution designs, analyzing design alignment, and integration to existing workflows and systems.
  • Work with IT, infrastructure teams, external technical teams/developers, and business colleagues to address queries on requirements, bugs, and resolutions.
  • Be a reliable point of contact for change management processes and initiatives assigned and highlight escalate risks to appropriate teams.
  • Break down business requirements to manageable pieces that can be delivered in increments through various artefacts such as BRD, FRD, and user stories for Agile framework projects.
  • Support and guide users through UAT preparation, execution, and coordination for new enhancements where appropriate.
  • Provide production user support, training, documentation, and troubleshooting, explaining highly technical concepts to non-technical stakeholders in a concise manner.
  • Provide secondary support to BAU team members on other initiatives that may require knowledge of application data.
Requirements:
  • Advanced knowledge of SQL and database concepts, including the ability to write and modify complex SQL queries and scripts in SSMS.
  • Experience with Azure Databricks, including developing and maintaining ETL and data quality processes, and developing and maintaining data models to support data analysis and reporting.
  • Advanced knowledge of MS Power BI, including the ability to build analysis services reporting models, develop visual reports, paginated reports, KPI scorecards, and dashboards using Power BI desktop.
  • Working knowledge of Python, Pandas, R, YAML, XML, AVRO, and JSON.
  • Experience with Azure DevOps Boards, including supporting change requests and documenting work items in epic, features, and user stories.
  • Analytical thinking for translating data into informative reports and visuals.
  • Competent IT skills with a good working knowledge of Microsoft Office applications, including expert-level skills in MS Excel.
  • 8+ years of experience in data analytics and reporting, SDLC/system implementation, and vendor relationship management.
  • Strong numeracy and logical analytical skills, with a structured approach to problem-solving.
  • Financial analysis skills in a financial setting will be considered an asset.
  • Proactive contribution to, lead, and influence business changes of varying complexities.
  • Excellent written and oral communication skills, with the ability to establish and maintain effective working relationships with various levels of management, staff, and external clients.
  • Ability to document complex concepts in a clear and concise manner, with expertise in conveying complex concepts to non-technical teams and speaking to technical audiences when needed.
  • Prior hands-on participation in production support chains, Tier-2 or 3-level triage experience.
  • Educated to degree level (Math, Business, Computer Science, or Information Systems), or equivalent analytical work experience.
  • Bilingualism and financial industry experience would be considered an asset.
What We Offer:
  • A great starting salary plus annual bonus potential and strong benefits package.
  • 20 vacation days plus additional floater days per year.
  • Fantastic company RRSP, extended health and dental coverage, life insurance, travel insurance, vision care, and wellness initiatives.
  • Countless opportunities to learn new skills and develop in your career, with the support needed to do so.
Join Our Team:

Markel Canada Limited is a Disability Confident Committed employer, committed to providing a positive experience for all applicants. If you require any accommodations during the application process, please let us know. We will ensure that individuals with disabilities are provided with all reasonable accommodations to be able to participate in the job application or interview process and to perform essential job functions if successful.



  • Toronto, Ontario, Canada Apex Systems Full time

    Job Title: Business Systems Analyst/Business AnalystJob Description:A senior Business Systems Analyst/Business Analyst is sought by Apex Systems to support highly visible Technology Initiatives at a Big 5 Bank. The ideal candidate will have experience working in highly matrixed environments and with multiple Technology and Business Teams from...


  • Toronto, Ontario, Canada Apex Systems Full time

    Job Title: Business Systems Analyst/Business AnalystJob Description:A senior Business Systems Analyst/Business Analyst is sought by Apex Systems to support highly visible Technology Initiatives at a Big 5 Bank. The ideal candidate will have experience working in highly matrixed environments and with multiple Technology and Business Teams from...


  • Greater Toronto Area, Canada, Ontario Apex Systems Full time

    Senior Business AnalystApex Systems is a staffing and consulting firm and we are looking for a Senior Business Analyst with 7+ years of experience supporting large regulatory projects in the financial industry, strong process mapping and requirement gathering skills, and some experience with Python to extract data to place at our client, a large North...


  • Toronto, Ontario, Canada Markel Canada Limited Full time

    Job Title: Senior Business Systems Reporting AnalystMarkel Canada Limited is seeking a highly skilled Senior Business Systems Reporting Analyst to join its Data Analytics team. As a key member of the team, you will be responsible for supporting data requests, developing scripts, and creating dashboards in PowerBI.Key Responsibilities:Lead and facilitate...


  • Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: Business Analyst/System AnalystAbout the Role:We are seeking a highly skilled Business Analyst/System Analyst to join our team at Nexus Systems Group Inc. As a key member of our Operational Risk technology solutions team, you will play a critical role in ensuring the effective and efficient operation of our systems.Key Responsibilities:Act as a...


  • Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: Business Analyst/System AnalystAbout the Role:We are seeking a highly skilled Business Analyst/System Analyst to join our team at Nexus Systems Group Inc. As a key member of our Operational Risk technology solutions team, you will play a critical role in ensuring the effective and efficient operation of our systems.Key Responsibilities:Act as a...


  • Toronto, Ontario, Canada Markel Canada Limited Full time

    Job Title: Senior Business Systems Reporting AnalystMarkel Canada Limited is seeking a highly skilled Senior Business Systems Reporting Analyst to join its Data Analytics team. As a key member of the team, you will be responsible for supporting data requests, developing scripts, and creating dashboards in PowerBI.Key Responsibilities:Lead and facilitate...


  • Toronto, Ontario, Canada Markel Canada Limited Full time

    Job Title: Senior Business Systems Reporting AnalystMarkel Canada Limited is seeking a highly skilled Senior Business Systems Reporting Analyst to join its Data Analytics team. As a key member of the team, you will be responsible for supporting data requests, developing scripts, and creating dashboards in PowerBI.Key Responsibilities:Lead and facilitate...


  • Toronto, Ontario, Canada Maarut Inc Full time

    Job Title: Senior Business Systems AnalystAbout the Role:We are seeking a highly skilled Senior Business Systems Analyst to join our team at Maarut Inc. As a Senior Business Systems Analyst, you will play a key role in analyzing business needs and developing solutions to drive business growth and improvement.Responsibilities:System Analysis and Design:...


  • Toronto, Ontario, Canada Maarut Inc Full time

    Job Title: Senior Business Systems AnalystAbout the Role:We are seeking a highly skilled Senior Business Systems Analyst to join our team at Maarut Inc. As a Senior Business Systems Analyst, you will play a key role in analyzing business needs and developing solutions to drive business growth and improvement.Responsibilities:System Analysis and Design:...


  • Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Business Systems AnalystScotiabank is seeking a Senior Business Systems Analyst to join our team. As a Senior Business Systems Analyst, you will be responsible for leading the analysis, design, and implementation of solutions to solve complex business problems for our lines of business.The ideal candidate will have 8+ years of experience in...


  • Toronto, Ontario, Canada S.i. Systems Full time

    Job DescriptionS.i. Systems is seeking a highly skilled Senior Business Intelligence Analyst to support their ePMO on 3 programs/projects in various stages. The ideal candidate will have experience in program management and be able to analyze data to inform business decisions.Key Responsibilities:Support the ePMO team in analyzing data to inform business...


  • Toronto, Ontario, Canada Apex Systems Full time

    Job Title: Senior Business Intelligence AnalystAbout the Role:Apex Systems is a leading staffing and consulting firm seeking a Senior Business Intelligence Analyst to support large regulatory projects in the financial industry. The ideal candidate will have 7+ years of experience in business analysis, strong process mapping skills, and proficiency in Python....


  • Toronto, Ontario, Canada Lorven Technologies Full time

    Job Title: Senior Business Systems AnalystLorven Technologies is seeking a highly skilled Senior Business Systems Analyst to join our team. As a Senior Business Systems Analyst, you will be responsible for leading analysis phases to identify, track, escalate, and resolve business systems issues in an Agile environment.Key Responsibilities:Lead analysis...


  • Toronto, Ontario, Canada Lorven Technologies Full time

    Job Title: Senior Business Systems AnalystLorven Technologies is seeking a highly skilled Senior Business Systems Analyst to join our team. As a Senior Business Systems Analyst, you will be responsible for leading analysis phases to identify, track, escalate, and resolve business systems issues in an Agile environment.Key Responsibilities:Lead analysis...


  • Toronto, Ontario, Canada Canadian Systems Inc. Full time

    Job SummaryWe are seeking a highly skilled Senior Information Systems Business Analyst to join our team at Canadian Systems Inc. The ideal candidate will have a strong background in information systems business solutions and be able to design, develop, and implement effective systems to meet business needs.Key ResponsibilitiesConfer with clients to identify...


  • Toronto, Ontario, Canada Investment Industry Regulatory Organization of Canada Full time

    Job Title: Senior Business Systems AnalystAt the Investment Industry Regulatory Organization of Canada, we are seeking a highly skilled Senior Business Systems Analyst to join our Information Technology team.About the RoleWe are looking for a Senior Business Systems Analyst to provide application solutions and support for our internal clients through...


  • Toronto, Ontario, Canada Investment Industry Regulatory Organization of Canada Full time

    Job Title: Senior Business Systems AnalystAt the Investment Industry Regulatory Organization of Canada, we are seeking a highly skilled Senior Business Systems Analyst to join our Information Technology team.About the RoleWe are looking for a Senior Business Systems Analyst to provide application solutions and support for our internal clients through...


  • Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Senior Business System AnalystRole Summary:Astra North Infoteck Inc. is seeking a Senior Business System Analyst to join our team. As a Senior Business System Analyst, you will be responsible for gathering requirements, creating Business Requirement Documents, and facilitating joint application sessions.Key Responsibilities:1. Gather requirements...


  • Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Title: Business Systems AnalystWe are seeking a highly skilled Business Systems Analyst to join our team at Nexus Systems Group Inc. The ideal candidate will have a strong background in IT operations and risk management, with excellent analytical and problem-solving skills.Key Responsibilities:Provide day-to-day operational and production support for...