Data Engineer

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/ 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 modelling

• 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

Fresh graduate would not be considered for this position.

Information collected will be treated in strict confidence and used solely for recruitment purposes.

The company will retain all applications no longer than 24 months of which will be destroyed thereafter.

We are an equal-opportunity employer. We do not discriminate on the basis of race, sex, disability, or family status in the employment process.