Help us get medicines to market faster
At Vimachem, we build the software that powers pharmaceutical and biotech manufacturing. Since 2015, we've developed the industry's only AI-enabled MES platform purpose-built for Life Sciences, combining MES, IIoT, and Pharma 4.0 capabilities into a single, modern system used across pharma sites globally.
We're growing rapidly and expanding our product team. We've been recognized as a "Great Place to Work" for multiple consecutive years, and our culture is fast-paced, entrepreneurial, and mission-driven.
About the role
We're hiring a
BI & Data Engineer
to own the reporting and analytics layer across our entire MES platform. Every module our customers use produces operational reports - on batches, OEE, deviations, dispensing, serialization, and more. Today that reporting is fragmented. Your job is to make it great, end-to-end.
You will be the first dedicated BI & Data hire at Vimachem, giving you a rare opportunity to define the company's analytics foundations from the ground up. You'll have significant influence over tooling, modeling standards, reporting architecture, and how data is leveraged across both our product and internal operations.
This is a hands-on, individual-contributor role. You will personally design the data models, build the pipelines, write the SQL, and craft pixel-perfect, performant Metabase dashboards. You will own the reporting experience the same way a product engineer owns a feature.
You will operate across three dimensions:
- Data layer ownership
- Design and maintain the models and pipelines that feed every report on the platform. Get the data right, keep it fast.
- Report craft
- Build dashboards in Metabase that are pixel-perfect, fast, and genuinely useful. Treat analytics as a product surface, not a side artifact.
- Cross-functional partnership
- Work daily with product (on what each module should report on) and engineering (on how the source data should look). Connect "what the user needs to see" with "what the database can deliver."
What you'll do day-to-day
- Build new reports for module releases, working with PMs on the brief and engineering on the source data
- Refactor existing reports to a common standard for layout, performance, and UX
- Tune slow queries and dashboards; fix bottlenecks at the SQL, schema, or aggregation layer
- Maintain the modeling / semantic layer in Metabase so non-technical users can self-serve where appropriate
- Define and apply naming, formatting, and visual standards for reports across the platform
What we're looking for
- 5+ years of experience in a BI, analytics engineering, or data engineering role at a B2B SaaS company
- Strong SQL - you can write, read, and tune complex queries against large operational datasets
- Hands-on experience building production dashboards in Metabase (or a direct equivalent: Looker, Superset, Power BI, Tableau, Mode)
- Experience designing data models for analytics (dimensional modeling, semantic layers, or similar)
- Experience with at least one modern data transformation stack (dbt, SQLMesh, or hand-rolled pipelines in Python/SQL)
- Track record of making slow reports fast - query tuning, indexing, materialized views, pre-aggregations
- Comfortable working directly with product managers and engineers, not behind a ticketing wall
Nice to have
- Direct Metabase experience, including the modeling layer or embedded analytics
- Experience with time-series data and tools like TimescaleDB
- Familiarity with Azure SQL or similar cloud OLTP databases as analytics sources
- Background in manufacturing, IoT, MES, or other industrial / operational software
- Exposure to embedded analytics inside a SaaS product (vs. internal-only BI)
- Experience preparing datasets for AI / ML use cases
Who thrives in this role
What’s in It for You
Our team is a strong, diverse, hard-working team that values families, personal well-being, and meritocracy. We believe amazing results require amazing effort and commitment, and we perform bi-annual performance reviews and continuous feedback to ensure we reward our top performers.
Benefits of working with us include:
- Performance-based bonus
- Employee Stock Option Plan (ESOP)
- Health & Life insurance
- Meal vouchers
- Transportation and commuting support
- Flexible working hours
- Extra birthday leave
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Help us build an inclusive community that will transform Life Sciences manufacturing.
