BI Reporting Analyst

QBE Insurance; Taguig; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

QBE Insurance in Manila is seeking a Reporting Analyst to collect, analyze, and present data to support decision-making across departments. You will design reports, dashboards, and visualizations that reveal KPIs, trends, and insights, while maintaining data quality and governance.

The role requires 6+ years in SAS Base/EG, SQL, Excel, Tableau, and Power BI, with experience in financial services or insurance preferred.

Qualifications

• 6+ years of experience using SAS Base, SAS EG, SQL, Excel, Tableau, and Power BI.
• At least 1 year of experience in financial services, preferably insurance.
• Bachelor's Degree or an equivalent combination of education and work experience.

Responsibilities

• Data Collection: Gather data from multiple sources, ensuring accuracy and completeness.
• Data Analysis: Identify trends, patterns, and anomalies using statistical methods and visualization tools.
• Report Creation: Design dashboards and reports that communicate insights to stakeholders clearly.
• Data Integrity: Clean and validate data to resolve inconsistencies and ensure quality.
• Performance Tracking: Monitor product-line performance and provide analyses on findings.
• Automation: Implement automated reporting to streamline processes and reduce manual effort.
• Data Governance: Adhere to governance and security standards to protect sensitive information.
• Continuous Improvement: Stay updated on trends to enhance reporting capabilities.
• BAU Support: Provide timely support for Tableau and Oracle OBIEE requests.
• Stakeholder Collaboration: Work with business analysts to tailor reports to needs.

Skills

Data analysis

Data visualization

Communication

Attention to detail

Problem solving

Time management

Technical curiosity

Education

Bachelor's degree or equivalent

Tools

Tableau

Power BI

Oracle

SAS Base

SAS EG

SQL

Excel

Job description

Primary Details

Time Type: Full timeWorker Type: EmployeeReporting Analyst is responsible for collecting, analyzing, and presenting data to support decision-making within an organization. This role involves working with various departments to understand their data needs and designing reports that provide insights into key performance indicators, trends, and other relevant metrics. Produce analytics and reporting, map key reporting processes, document reporting requirements, manage stakeholders in the collection of requirements, identify insurance portfolio trends and data interpretation. Build, manage and maintain both adhoc and BAU reporting requirements.

Responsibilities

• Data Collection:
• Gather data from various sources, such as databases, spreadsheets, and software systems, ensuring its accuracy and completeness.
• Data Analysis:
• Analyze the collected data to identify trends, patterns, and anomalies. Use statistical methods and data visualization tools to transform raw data into meaningful insights.
• Report Creation:
• Design and develop reports, dashboards, and visualizations that effectively communicate data-driven insights to stakeholders. These reports should be user-friendly and cater to the specific needs of different departments or teams.
• Data Integrity:
• Ensure data quality and integrity by cleaning and validating data, resolving inconsistencies, and addressing any discrepancies.
• Performance Tracking:
• Monitor performance of all relevant product lines, identify trends, provide input and analyses on design and reports, and ensure line management is informed of findings. Collaboration: Work closely with various departments and teams to understand their reporting requirements and tailor reports to meet their needs.
• Automation:
• Implement automated reporting solutions to streamline the reporting process and reduce manual efforts where possible.
• Data Governance:
• Adhere to data governance and security standards to protect sensitive information and ensure compliance with relevant regulations.
• Continuous Improvement:
• Stay updated with industry trends and emerging technologies to enhance reporting processes and capabilities.
• BAU Support:
• Provide timely support to Tableau and Oracle OBIEE requests like data reconciliation, server reset requirements, access administration, technical support and monthly/quarterly refresh.
• Stakeholder Collaboration:
• Work closely with business analysts and stakeholders to understand reporting requirements.
• Communicate findings and insights effectively to both technical and non-technical audiences

Qualifications

Knowledge

• General knowledge of insurance business and related market conditions preferred
• Fundamental knowledge of data analysis, extraction and management techniques for insurance portfolios
• Strong mathematical and statistical knowledge
• Fundamental knowledge in Report template creation and design

Skills

• Data Analysis: Proficiency in data analysis techniques, including data cleaning, manipulation, and statistical analysis. Tools like R, Python and similar
• Data Visualization: Skill in using data visualization tools like Tableau, Power BI to create compelling visual representations of data.
• Technical Skills: Familiarity with programming languages such as Oracle, SAS Base, SAS EG, SQL, Excel to extract, transform, and analyze data.
• Attention to Detail: Accuracy is crucial in data analysis and reporting to ensure the insights are reliable.
• Communication: Strong written and verbal communication skills to effectively convey insights to non-technical stakeholders.
• Problem-Solving: Ability to identify issues, propose solutions, and make data-driven recommendations.
• Time Management: Efficiently manage multiple projects, prioritize tasks, and meet deadlines.

Experience

• 6 years minimum experience (SAS Base, SAS EG, SQL, Excel, Tableau, Power BI) Has been involved in multiple automation initiatives that delivered tangible benefits
• At least 1 year experience in the financial services industry, preferably in insurance
• Working experience in a consulting or shared services environment preferred
• Bachelor's Degree or equivalent combination of education and work experience

Skills:

Business Intelligence Applications, Business Management, Communication, Critical Thinking, Customer Service, Detail-Oriented, Financial Products, Intentional collaboration, Managing performance, QlikView, Regulatory Compliance, Reporting and Analysis, Risk Management, Sound Judgment, Stakeholder Management

Equal Employment Opportunity

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