Data and Reporting Engineer (PowerBI & SAS)

Hammerjack Pty Ltd

Philippines

On-site

PHP 800,000 - 1,400,000

Full time

4 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Hammerjack Pty Ltd in the Philippines is seeking a Data and Reporting Engineer to collect, transform, and store data from diverse sources, ensuring quality and enabling data-driven decisions for stakeholders.

You will design and maintain data pipelines, build dashboards with Tableau/Power BI, and support governance, automation, and reporting needs across the function.

Qualifications

Experience with SAS Base and SAS EG preferred.
Strong SQL and data modeling skills.
Familiarity with data warehousing concepts and technologies.
Experience with reporting tools like Tableau or Power BI.

Responsibilities

Gather data from diverse sources including databases and APIs.
Design, develop, and maintain ETL processes.
Create interactive dashboards and reports.
Ensure data quality and governance across datasets.
Collaborate with stakeholders to define reporting requirements.

Skills

SQL

Data modeling

Database management

Tableau

Power BI

Python

Java/Scala

Data governance

Communication skills

Education

Bachelor's degree in Computer Science/Information Technology

Tools

SAS Base

SAS EG

Apache NiFi

Apache Spark

Talend

Snowflake

Redshift

BigQuery

Tableau

Power BI

QlikView

Job description

Time Type: Full time

Worker Type: Employee

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.

Skills