Data & Analytics Engineer

**About the position**

We’re the team behind projects like BI tool Holistics, database diagram tool dbdiagram.io, and open-source project dbml.org. We are looking for another Analytics Engineer to help us evolve our data pipeline to support internal decisions, and to provide valuable insights into the mind of data professionals so we can improve our products.

This is a full-time position based in Ho Chi Minh City with flexible, hybrid WFH/WFO setup.

‍

**What is Holistics?**

First off, Holistics is not simply a data visualization tool.

The core of Holistics as a product lies in the “Semantic Layer” that sits on top of your physical database. This abstraction layer enables you to add more meanings to your tables, and let you create reusable data components like data models, metrics, dimensions These components can be combined into datasets - the interface for the end-users to query data with a familiar drag and drop interfaces.

Our vision for this semantic layer is to incorporate the best practices of software engineering into the data analytics workflow: version control, code review, deployment flow, CI/CD

Working at Holistics’s data team, aside from supporting internal teams with data for better decision, you will be one of the first that experience these innovations, and your input will help to shape the development of the product itself.

‍

**Our current data setup**

We wrote an entire book explaining the complex analytics landscape, so it’s fair to say that we know a thing or two about setting up data stack.

That said, our data setup is as follows:

- **Ingestion and Transformation**: Event tracking and ETLs from various data sources into our data lake (GCS) and data warehouse (BigQuery). The data is then transformed and moved to the data mart using dbt.
- **Serving**: Reporting is served on Holistics, and reverse-ETLs are handled to push data back into our CRMs for operational purposes.
- **Orchestration**: We use Prefect on top of the data stack to orchestrate and automate data pipelines and other operations.
- **GitOps**: We follow GitOps principles to ensure everything in the entire pipeline, from ingestion to the reporting layer, is version controlled.

On the business side, we practice what we preach. That means instead of building reports and dashboards, Data team works to maintain a common set of metric definitions and educate the business users on how to self-serve the platform effectively.

‍

**What you will work on here**

Below is a rough breakdown of how your job scope in Holistics will contain:
**Data Pipeline (50%)**: Be responsible for running and maintaining our data pipeline, ensuring it’s running well and robust.
- Build and maintain our data pipeline & orchestration solutions
- Implement ETL (Extract, Transform, Load) processes to pull and transform raw data into reusable data models.
- Ensure data quality and integrity through validation checks and automated testing.
- Document data pipeline processes and maintain comprehensive metadata for transparency and reproducibility.

**Data Modeling & Business Analytics (40%)**: Instead of spending most time building adhoc reports and dashboards, your job will revolve around building and maintaining data assets and educating the business stakeholders to self-serve them well. That includes but not limited to:

- Build & maintain our data modeling semantic layers.
- Work with business stakeholders to conceptualize their business processes and turn them into quantifiable metrics to track and measure.
- Conduct trainings and workshops to help business stakeholders self-serve data better.
- Adhoc customer requests: Support Holistics customers in extracting customized data (usage data, customized reports) upon requests.

**Help improve Holistics as a product (10%)**
- This is a unique job scope that only Holistics can offer. Aside from the above data work, you get to act as a valuable source of insights into how data people work to shape how Holistics build the platform.
- You get to research, evaluate the latest data tools in the market and document your findings as a source of inspiration to improve the product.

‍

**What we look for in you**

Here’s our idea of a good team member fit:

- You should have a **genuine interest in the data analytics / BI industry** as a whole.
- You should have a **continuous learning & growth mindset**. You find yourself excited to learn something new as part of the work every day.
- You should have solid **problem decomposition & problem solving** skills.
- You **think about the whole system**: Understand how business operations, human factors, data collection, data input, data usageinteract and affect one another in an organization
- **Communications**: Given we have a strong writing culture, you should be comfortable with communicating your ideas in English written forms.
- **Experience with our exact tools we use is not required -** we expect you to pick these up quickly on th