Data and Reporting Engineer (SAS Base, SAS EG Experience)

QBE Group Shared Services Centre; Philippines; Hybrid; PHP 900,000 - 1,300,000; Full time

Job summary

QBE Group Shared Services Centre is seeking a Data and Reporting Engineer in the Philippines to design, develop, and maintain data pipelines, warehouses, and reporting tools. You will deliver automated ETL processes, ensure data quality, and build dashboards for business stakeholders using Tableau or Power BI.

You will collaborate with onshore teams, implement data governance, and optimize data models for scalable analytics.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Experience with SAS Base/EG, SQL, Excel, Tableau or Power BI.
• Knowledge of data warehousing concepts and ETL tooling.
• Understanding of data governance and data security principles.
• Familiarity with Agile methodologies and cross-functional collaboration.

Responsibilities

• Collect, transform, and store data from multiple sources to ensure quality and consistency.
• Design and maintain data warehouses or data lakes for efficient data retrieval.
• Develop automated ETL processes and scalable data pipelines.
• Create interactive dashboards and reports for stakeholders using Tableau/Power BI.
• Collaborate with analysts to define reporting requirements and ensure data governance.

Skills

Data modeling

SQL

Tableau

Power BI

Python

Java/Scala

Analytical thinking

Data governance

Communication

Agile

Education

Bachelor's degree in CS/IT or related

Tools

Tableau

Power BI

SAS

Apache NiFi

Apache Spark

Snowflake/Redshift/BigQuery

SQL Server/Oracle/PostgreSQL

Job description

Role Highlights

• Time Type: Full time
• Worker Type: Employee
• Happy to talk Flexible Working Arrangement

The Opportunity

A Data and Reporting Engineer 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 be responsible for producing complex reporting and analytics, automation, dashboard creation and reports consolidation across the function. This role will involve the design and development of reporting tools that are project driven and will be direct contact of onshore stakeholders on certain projects that will be assigned.

Data Extraction and Transformation:

• Gather data from diverse sources, such as databases, APIs, and 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 to store and organize data efficiently.
• 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 and procedures 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 volumes of data.

Performance Monitoring:

• Monitor system performance, troubleshoot issues, and optimize query performance.
• Implement alerting mechanisms for system failures or anomalies.

Documentation and Knowledge Sharing:

• Maintain documentation for data pipelines, data models, and reporting processes.
• Collaborate with team members and stakeholders to share knowledge and best practices.

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:

• Leading and managing onshore reporting project requirements and direct contact of specific AO business units.
• Implement Agile methodology on different reporting projects

Quality Assurance:

• Implement data quality checks to ensure data integrity.
• Identify and address data quality issues as they arise.
• Audit reports produced by the team ensuring DTP is adhered to.

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
• Agile methodologies, such as Scrum, Kanban, and Lean.

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 languages such as 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 business stakeholders.
• Ability to adapt to evolving technologies and trends in data engineering and reporting.

Experience:

• Some relevant years of experience in SAS Base, SAS EG, SQL, Excel, Tableau, Power BI, Has been involved in multiple automation initiatives that delivered tangible benefits
• Some relevant years of experience in the financial services industry, preferably in insurance
• Working experience in a consulting or shared services environment preferred
• Bachelor's Degree in Computer Science, Information Technology, or any related field or equivalent work experience.

About QBE

At QBE, we get to the heart of what matters for our customers. And we do it all with a human touch.

We're an international insurer with more than 13,000 people working across 26 countries – which means we're big enough for your ambitions, yet small enough for you to make a real impact. It's an exciting time. We're building momentum towards our vision to become the most consistent and innovative risk partner.

What if you could have a positive impact – at work and in the world As part of the QBE team, you'll get to spend every day working with people who are passionate, talented and kind.

Your career. At the heart of it.