Reporting analyst Jobs in Woodbridge, ON

The individual will be working with the Markel Canada Data Analytics team to primarily support data requests, data queries, script development, analysis for reporting tools and development of dashboards in PowerBI.

The successful candidate will have the opportunity to work with cross functional teams across the whole of the business and to work with external system providers.

The Opportunity

Markel Canada Data Operations is looking for a fun and talented person to work with its expert and data smart team. Markel Canada is a leading liability insurance company with various specialty products. The Data Ops goal is to help the business make good choices with dashboards and other tools that show Markel’s business story and give insights to enhance the business results.

Markel values diversity in its company culture. We, the data team, think that diversity fosters innovation and offers various insights on how to use our data to help our business team enhance our products and thus benefit our end customers.

This is a new role in the data team, to help implement the Canadian Data Operations plan and to deliver innovative BI Products. This role offers a great chance to build an exciting career in data analytics for the insurance market.

What you'll be doing :

• 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 our internal clients on the usage of our current BI Tools. Work with technical teams to determine the best way to present data to our internal clients.
• Participate in end-to-end requirements, design, implementation, testing and production data request initiatives in integration projects and reporting tools enhancements.
• Contributes and reviews technical specifications ensuring requirements are accurately translated for new data solutions or changes to existing solutions. Hands-on data mapping and defining transformational logic is required.
• 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 Team, External Technical Teams / Developers, and business colleagues to address queries on requirements, bugs, and resolutions. Investigate and present gap analysis findings to audiences of various backgrounds (both technical, non-technical and managerial)
• Be a reliable point of contact for change management processes and initiatives assigned, and highlight escalate risks to appropriate team(s) (Local Senior Business Technology Members, Finance Team, IT infrastructure, Product / Project Manager, Vendor, Steering Committee)
• Breakdown 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, reporting to Product / Project Manager(s) as appropriate.
• 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 – e.g. data migration, testing and deployment of system solutions.

Our must haves :

Who we are :

Markel Group (NYSE – MKL) a Fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world.

We’re all about people | We win together | We strive for better | We enjoy the everyday | We think further

What’s in it for you :

Are you ready to play your part?

Choose ‘Apply Now’ to fill out our short application, so that we can find out more about you.

Markel celebrates the value of a diverse workforce that brings experience and expertise from a wide variety of backgrounds and life circumstances. Whatever your background, if you feel you meet the requirements of this role then we want to hear from you. We are also happy to consider candidates who are looking for flexible working patterns.

We are a Disability Confident Committed employer, which means you'll have a positive experience applying for a role at Markel and are able to perform at your best. If there are any adjustments we can reasonably make to ensure that the process is accessible for you at every stage 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. Please contact us to request any accommodations that may be needed.