Reporting Analyst (POWER BI /SAS)

QBE GROUP SHARED SERVICES LIMITED - PHILIPPINE BRANCH

Metro Manila

On-site

PHP 600,000 - 1,200,000

Full time

7 days ago
Be an early applicant
Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

QBE GROUP SHARED SERVICES LIMITED - PHILIPPINE BRANCH is seeking a data engineering professional to gather, transform, and model data across sources, design data warehouses, and develop ETL processes. You will create dashboards and ensure data quality within insurance-focused datasets.

The role requires SAS Base, SAS EG, SQL, and BI tools experience, plus strong analytical and communication skills for cross-functional collaboration in a shared services environment in Metro Manila.

Qualifications

  • 3+ years minimum experience with SAS Base, SAS EG, SQL, Excel, Tableau, and Power BI in data analytics and automation.
  • At least 1 year experience in financial services, preferably insurance.
  • Bachelor's Degree in Computer Science, Information Technology, or related field; equivalent work experience considered.
  • Experience in consulting or shared services environment preferred.
  • Strong analytical and problem-solving skills with attention to data quality and governance.
  • Excellent communication for cross-functional collaboration.

Responsibilities

  • Gather data from databases, APIs, and flat files.
  • Clean, transform, and preprocess data for accuracy.
  • Develop and maintain ETL processes.
  • Design and maintain data warehouses or data lakes.
  • Implement data modeling and schema design.
  • Create dashboards with Tableau or Power BI.
  • Collaborate with analysts to define reporting requirements.
  • Implement data quality checks and governance policies.
  • Develop automated data processing solutions.
  • Monitor performance and optimize queries.
  • Maintain documentation for pipelines and data models.
  • Lead onshore reporting project requirements and Agile projects.
  • Audit reports for data quality and governance.

Skills

Data modeling
SQL
DBMS
ETL tools
SAS Base
SAS EG
Apache NiFi
Apache Spark
Talend
Tableau
Power BI
Python
Java
Scala
Data governance
Data security
Communication
Adaptability

Education

Bachelor's degree in Computer Science / IT / related field

Tools

SAS Base
SAS EG
Apache NiFi
Apache Spark
Talend
Tableau
Power BI
QlikView
Snowflake
Redshift
BigQuery
SQL Server
Oracle
PostgreSQL
Python
Java
Scala

Job description

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
  • 3+ years minimum experience in 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 in Computer Science, Information Technology, or any related field or equivalent work experience.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data and Reporting Engineer (PowerBI & SAS)
Data and Reporting Engineer (PowerBI & SAS)

QBE Group Shared Services Centre • Manila

On-site
PHP 700,000 - 1,000,000
Data and Reporting Engineer
Data and Reporting Engineer

PM Consulting • Taguig

On-site
PHP 900,000 - 1,500,000
Data and Reporting Engineer
Data and Reporting Engineer

Our Clients • Taguig

On-site
PHP 1,000,000 - 2,000,000
Data and Reporting Engineer (PowerBI & SAS)
Data and Reporting Engineer (PowerBI & SAS)

Hammerjack Pty Ltd • Philippines

On-site
PHP 800,000 - 1,400,000
Data and Reporting Engineer
Data and Reporting Engineer

QBE Group Shared Services Centre • Cebu City

On-site
PHP 1,200,000 - 2,400,000
Reporting Analyst
Reporting Analyst

QBE Group Shared Services Centre • Taguig

On-site
PHP 250,000 - 420,000
Reporting Analyst
Reporting Analyst

Hammerjack Pty Ltd • Taguig

On-site
PHP 279,000 - 446,000
SAS Reporting Analyst
SAS Reporting Analyst

QBE Group Shared Services Centre • Taguig

On-site
PHP 600,000 - 1,000,000
Flexible working options
Data Director
Data Director

ECLARO • Philippines

On-site
PHP 1,800,000 - 3,000,000
IT Director, Enterprise Data
IT Director, Enterprise Data

ECLARO • Quezon City

On-site
PHP 3,500,000 - 6,000,000