Data and Reporting Analyst

Overview

A Data and Reporting Analyst is responsible for collecting, transforming, and storing data from various sources, ensuring data quality and integrity, and creating meaningful reports and dashboards for stakeholders. They bridge the gap between data sources and end-users, enabling data-driven decision-making within QBE. This role will also produce complex reporting and analytics, automation, dashboard creation, and reports consolidation across the function. The design and development of reporting tools will be project-driven, with direct contact with onshore stakeholders on assigned projects.

Primary Responsibilities

• Data Extraction and Transformation: Gather data from diverse sources (databases, APIs, flat files); clean, transform, and preprocess data to ensure accuracy and consistency; develop and maintain ETL (Extract, Transform, Load) processes.
• Data Warehousing: Design and maintain data warehouses or data lakes; implement data modeling and schema design to optimize data retrieval; big data management.
• Database Management: Administer and optimize databases for performance and scalability; ensure data security and access control measures are in place.
• Reporting and Visualization: Create interactive dashboards and reports using tools like Tableau, Power BI, or custom-built solutions; collaborate with business analysts and stakeholders to define reporting requirements.
• Data Quality and Governance: Implement data quality checks and validation processes; establish data governance policies to maintain data integrity; perform root cause analysis on data queries from stakeholders.
• Automation and Scalability: Develop automated solutions for data processing and reporting tasks; scale data pipelines and reporting systems to handle growing data volumes.
• Performance Monitoring: Monitor system performance, troubleshoot issues, optimize query performance, and implement alerting for failures or anomalies.
• Documentation and Knowledge Sharing: Maintain documentation for data pipelines, data models, and reporting processes; share knowledge and best practices with the team.
• Technical Expertise: Stay up-to-date with emerging technologies and best practices in data engineering and reporting; continuously enhance skills in SQL, data modeling, and reporting tools.
• Project Management: Lead onshore reporting project requirements and maintain direct contact with specific business units; implement Agile methodology on different reporting projects.
• Quality Assurance: Implement and monitor data quality checks to ensure data integrity; address quality issues as they arise; audit reports to ensure compliance with standards.

Qualifications

• Bachelor\'s Degree or equivalent combination of education and work experience

Required Experience

• 7 years relevant experience

Preferred Competencies/Skills

• Proficiency in data modeling, SQL, and database management systems (e.g., SQL Server, Oracle, PostgreSQL)
• Experience with ETL tools and processes (e.g., SAS Base, SAS EG, Apache NiFi, Apache Spark, Talend)
• Knowledge of data warehousing concepts and technologies (e.g., Snowflake, Redshift, BigQuery)
• Familiarity with reporting and visualization tools (e.g., Tableau, Power BI, QlikView)
• Programming skills in Python, Java, or Scala for data processing and automation
• Strong analytical and problem-solving skills
• Understanding of data governance and data security principles
• Excellent communication skills to work effectively with cross-functional teams and stakeholders
• Ability to adapt to evolving technologies and trends in data engineering and reporting

Preferred Education

• Bachelor\'s Degree or equivalent combination of education and work experience

Preferred Education Specifics

• Degree in Actuarial, Computer Science, IT, Accountancy, Mathematics, Statistics, Economics, or related discipline

Preferred Experience

• 7+ years minimum experience in SAS Base, SAS EG, SQL, Excel, Tableau, Power BI; involvement in multiple automation initiatives with tangible benefits
• At least 1 year experience in the financial services industry, preferably in insurance
• Experience in a consulting or shared services environment preferred
• Bachelor\'s Degree in Computer Science, Information Technology, or related field or equivalent work experience

Preferred Licenses/Certifications

• Power BI Certification
• SAS Certification
• Tableau Certification
• Alteryx Certification

Preferred Knowledge

• General knowledge of the insurance business and related market conditions
• 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
• Agile methodologies (Scrum, Kanban, Lean)

QBE Cultural DNA

• We are customer-focused
• We are technical experts
• We are inclusive
• 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 risk management practices

Equal Employment Opportunity

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

Other

• Job Type: Individual Contributor

Disclaimer

• The duties listed do not limit assignment of work and are not a complete list of duties performed in the position. Our Code of Ethics and Conduct provides guidance to help make good judgement calls.

How to Apply

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

#J-18808-Ljbffr

---