Analytics Engineer, Cera Care
May, 2021 - Present
Cera Care is a digital platform that empowers carers to deliver care services those who require care. I initially started out owning the finance data products and now I'm involved in designing higher level solutions to make sure the business is getting the most value of our data.
Utilised dbt to build a centralised reporting layer for data analytics.
Developed and shared various data models/products for analyst consumption, helping them unlock insights to the business.
Designed and implemented high level data model used to consolidate disparate systems from within the business.
Converted data from upstream systems including MongoDB (NoSQL), MySQL and various APIs into a useable format.
Utilised dbt tests to ensure high quality data models/products.
Implemented dashboards in Looker allowing observability of data platform jobs, as well as identifying cost optimisations to data pipelines.
Worked closely with product team and data analysts at design and development stages.
Held dbt training sessions to help upskill data team allowing them to adopt a software engineering approach to development, providing transparency to data analytics.
Maintained airflow DAGs and troubleshooted these when errors occurred, reducing data downtime for business users.