Data Engineer

Bowtie Life Insurance Company; Hong Kong; On-site; HKD 400,000 - 600,000; Full time

Job summary

Bowtie Life Insurance Company in Hong Kong is looking for a talented individual to join their newly created BI/data team. You will lay the foundation for the team, working closely with backend engineers and business users to develop a secure and efficient self-service BI solution.

The preferred candidate will have strong data modeling skills using SQL and a collaborative spirit to work cross-functionally. Knowledge of cloud infrastructure, especially AWS, is a plus. This is an exciting opportunity to make a significant impact in a growing organization.

Qualifications

• Proficient in data modeling techniques and SQL.
• Eager to work closely with engineering and business users.
• Good understanding of software engineering practices.
• Preference for knowledge in AWS.
• Experience with modern data transformation tools.
• Familiarity with BI and analytics platforms.

Responsibilities

• Collaborate with backend engineers and business users.
• Architect and maintain self-service BI solutions.
• Design technical strategies for data warehousing.
• Prepare automated and ad-hoc reports for users.
• Assist business users in insights and decision-making.

Skills

Data modelling techniques using SQL

Collaboration with engineering and business teams

Understanding of software engineering practices

Cloud-based infrastructure knowledge (preferably AWS)

Experience with data transformation tools (e.g., dbt)

Experience with BI platforms (e.g., Tableau, Power BI)

Tools

SQL

dbt

Airflow

Tableau

Power BI

Job description

Role Summary

Bowtie’s mission is to make insurance good again and our vision is to build a category-defining health insurance company. As a young and fast-growing company, grooming and learning from the next generation is always our priority. We are looking for great talents who share our values to help us unleash the power of data for informed decision-making, stay competitive, and achieve our strategic objectives. This is a newly created role, and you will be laying the foundation for (and possibly leading) our BI/data team moving forward!

About The Role

You will be working in a fast-paced organisation that promotes cross-functional collaboration. Daily, you will collaborate hands‑on with backend engineers and business users to architect and maintain a secure self-service BI solution, including data warehouses, dashboards, and various reporting systems, and produce analysis for internal business users. You will also help build the foundation for our emerging data‑science capabilities, supporting predictive workflows and personalised customer experiences.

Your Key Responsibilities Include:

Data Handling and Data Warehousing

• Understand user stories and insurance operation workflows and model raw ingested data into business-user-friendly entities
• Ingest and consolidate data from various sources, including multiple third-party sources and our application database, into a single source of truth using modern ELT (Extract, Load, Transform) and Reverse-ELT pipelines
• Design technical strategies and infrastructure to facilitate self-service business intelligence, including strategies to deploy data warehouse changes with CI/CD pipelines
• Design dashboards for business users to monitor trends and patterns

Data Innovation & Predictive Analytics (Good-to-Have)

• Collaborate on setting up the data infrastructure needed for machine learning models, predictive analytics, or forecasting (e.g., customer behaviour metrics, lifetime value estimation)
• Help design and orchestrate simple, production-ready pipelines that feed data into AI integrations or conversational search bots

Reporting

• Prepare automated reports for strategic projects and regulatory reporting
• Prepare ad‑hoc reports for business users and, if appropriate, turn ad‑hoc reports into BAU reports or include them as part of the dashboards
• Assist teams to scale existing reporting workflows with validations enforced

Data Analysis & Insights

• Assist business users to obtain insights and facilitate decision-making
• Provide user training and assist product managers and other business users to perform ad‑hoc analysis

Roughly, the composition of your task will be as follows

• Discussion with business users
• Generating and streamlining reports for business users
• Data modeling
• Maintaining our data warehouse and pipeline

The success of this role will be measured by:

• Creating dashboards and reports that enable business users to make informed decisions
• Self-service-ability of the dashboards and reports produced
• Accuracy and efficiency in the data handling process

About you

We are looking for a smart, curious, and problem-solver with the following skills and qualifications

• Proficient: Data modelling techniques using SQL
• Proficient: Eager to work closely with both the engineering team and business users, listen to user stories, and consolidate business requirements
• Proficient: Good understanding of software engineering practices
• Preferable: High-level knowledge in cloud-based infrastructure and services (preferably in AWS)
• Fair: Experience with modern data transformation tools (e.g., dbt) and data workflow orchestrators (e.g., Airflow, Dagster, Prefect)
• Fair: Experience using modern BI and analytics platforms (e.g., Metabase, Looker, Tableau, Power BI) and familiarity with metadata catalogs or data lineage tools (e.g., OpenMetadata, DataHub)
• Preferable: Exposure to (or curiosity about) basic statistics, predictive modeling, or setting up data layers for ML/AI applications