Data Engineer

Role Summary

Bowties 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