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 usage… interact 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 the job.
- Independence and Collaboration: Ability to work independently while also being a team-player
The following technical skillsets are needed:
- Data modeling: Proficient in data modeling techniques (Dimensional Modeling, Activity Schema) to transform source data into user-friendly formats.
- SQL: Capable of writing SQL queries with a focus on readability and optimizing performance (speed and cost)
- Coding: Proficiency in Python or equivalent languages to maintain data pipelines and perform scripting tasks
- Version control (Git): Familiarity with basic version control practices
Interview Process
- Round 1: Technical Interview with Data team
- Round 2: Take-home assignment (offline - deadline 3 days, will be sent after Round 2)
- Round 3: Behavior & Culture fit
Why You'll Love Working
👨🏼💼 Training & career developments
- Weekly TED talks to expand skills and knowledge.
- Yearly budget to support personal and professional growth, well-beings and interest cultivations.
🌏 Competitive salary and benefits
- 24/7 Healthcare Insurance, Periodic Medical Checkup.
- Salary regular reviews, 13-month Bonus.
- Stock Options for high-contributing individuals.
💕 Awesome company policies
- A flexible work culture, Regular reviews, Remote policy.
- 14 Annual leaves/year, 14 Sick leaves/year, Children care leave policy.
- Weekly happy hours and company-organized events.
🏢 Workstations provided for maximum productivity
- MacBook (or Laptop) Grant
- Mechanical Keyboard + Razer Mouse
- Big-screen monitor(s)
🌐 Working time: From Monday – Friday, from 9.00 a.m. to 6.00 p.m.
🌐 Work location:457 Nguyen Dinh Chieu, Ward 5, District 3, Ho Chi Minh City, Viet Nam