Data & Reporting Analyst - Good Sam

Primary Details
Time Type: Full time

Worker Type: Employee

At QBE, our purpose is to give people the confidence to achieve their ambitions inside and outside of work. From development opportunities, to flexible work options and highly competitive reward and benefits packages, we understand the importance of living our values when it comes to our people.

Everything we do at QBE is underpinned by our company's cultural elements - because we know it's not just what we do that matters, it's how we do it that makes the difference.

We are looking for a highly versatile data analyst to join our Automotive Protection department. We specialize in developing affinity insurance solutions to the global automotive sector. You will be helping to support us, leveraging the rich data on our US portfolios to enhance our analytics, forecasting and data science capability. You will be expected to get involved in the full end-to-end business data processes, along with a variety of projects that enhance our product offering.

Our small and growing analyst team based in London are looking for a highly motivated individual with excellent data mining abilities, analytical skills and very good knowledge of Microsoft applications, particularly MS Access, Excel and SQL Server.

Your More Than Your Work. QBE is More Than a Workplace. That's why QBE provides you with benefits and support so you can concentrate on living your best life. Employees scheduled over 30 hours a week will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution and a paid-time off program. In addition, our paid-family and care-giver leaves are available to support our employees and their families. Regular full-time and part-time employees will also eligible for QBE's annual discretionary bonus plan based on business and individual performance.

Compensation Range - $63,000 - $91,000

Primary Responsibilities:

• Monitoring data from various sources checking for accuracy and reporting exceptions
• Designing, developing and enhancing analytics reporting that generates valuable business insights and drives key business decisions
• Communicating and presenting data derived insights to business stakeholders
• Analyzing existing claims and projecting future claims using actuarial forecasting techniques
• Analyzing and reporting on quote conversions on our digital business
• Forecasting performance and supporting underwriters in pricing
• Building and documenting regular processes to be handed to the operations team
• Collaboratively working across the business functions. Liaising with clients, senior stakeholders, IT developers, underwriters, account managers, and claims.
• Due to the uniqueness of the Automotive Protection account, a definitive role cannot be scheduled. You will therefore need to be versatile, having the ability to adapt to any eventuality that might come about. You should have the ability to think for yourself and act when confronted with unique situations.

Required Qualifications:

• A minimum of a 3.5 GPA in Mathematics, Statistics, Economics or an analytical related degree
• Excellent knowledge of MS Excel
• Good knowledge of MS SQL Server and Access (strong understanding of relational databases and ability to write SQL queries, create reports, forms and macros is a must)
• Working knowledge of Word and PowerPoint
• Strong analytical skills - methodical, logical and rational approach to problem solving
• High attention to detail with the ability to work quickly and accurately
• Comfortable with interpreting and producing numerical data
• Excellent written and communication skills. Having the ability to present findings to key stakeholders and clients
• Ability to operate sensitively in multinational environment and build effective working relationships with clients and key stakeholders across the business
• Highly organised and efficient. Able to manage own work load, and to deliver high quality outputs within tight deadlines
• Experience in the insurance industry, particularly the automotive sector will be an advantage
• Experience with other programming languages and tools such as R, Python, Tableau and Power BI will be an advantage

Preferred Competencies/Skills:

• Assume a methodical approach to evaluate situations
• Understand the needs and goals of a customer and actively look for ways to meet them.
• Create and maintain current, accurate and readily accessible data in various formats.
• Utilize effective research and investigative techniques
• Keep logs, records, and files up-to-date and readily accessible
• Willingness to help and/or assist others
• Migrate and adapt data from one system to another
• Database manipulation techniques

Preferred Qualifications:

• Education: Bachelor's Degree or equivalent combination of education and work experience.

Preferred Experience:

• Systems/technical expertise and/or insurance industry experience
• Increasing levels of experience with systems/technology utilized in area of responsibility (i.e. SAS, SQL and Access)
• Property and Casualty insurance industry experience

QBE Cultural DNA

Everything we do at QBE is underpinned by our DNA (which interlinks seven cultural elements) - because we know it's not just what we do that matters, it's how we do it that makes the difference. We expect all employees to role model and inspire the right behaviors that link to our cultural elements:

-We are customer-centered

-We are technical experts

-We are diverse

-We are fast-paced

-We are courageous

-We are accountable

-We are a team

All employees are expected to adhere to QBE's Code of Ethics and Conduct and apply sound risk management practices

US Only - Travel Frequency
• NA

US Only - Physical Demands
• General office jobs: Work is generally performed in an office environment in which there is not substantial exposure to adverse environmental conditions. Must have the ability to remain in a stationary position for extended periods of time. Must be able to operate basic office equipment including telephone, headset and computer. Incumbent must be able to lift basic office equipment up to 20 lbs.

US Only - Disclaimer
• To successfully perform this job, the individual must be able to perform each essential job responsibility satisfactorily. Reasonable accommodations may be made to enable an individual with disabilities to perform the essential job responsibilities.

Job Type
• Individual Contributor

Global Disclaimer
• The duties listed in this job description do not limit the assignment of work. They are not to be construed as a complete list of the duties normally to be performed in the position or those occasionally assigned outside an employee's normal duties. Our Group Code of Ethics and Conduct addresses the responsibilities we all have at QBE to our company, to each other and to our customers, suppliers, communities and governments. It provides clear guidance to help us to make good judgement calls.

SALARY RANGE FOR ROLE * may vary based on geography:

$57,000 - $70,000 plus bonus and benefits

How to Apply:

To submit your application, click "Apply" and follow the step by step process.

Equal Employment Opportunity:

QBE is an equal opportunity employer and is required to comply with equal employment opportunity legislation in each jurisdiction it operates.