BI & Data Engineer

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 

• Partner with engineering on schema and event design so the data needed for reporting exists at the source 

• Build reusable report templates that help our implementation team deliver faster on customer-specific requests 

• Track usage and feedback on reports; double down on what matters, retire what doesn't 

• Support AI and ML initiatives by preparing and maintaining high-quality datasets the AI features on our platform can build on 

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 

• Hands-on by default - You enjoy building, not just specifying. You'll personally write the SQL and build the dashboard. 

• Cares about craft - You notice the wrong axis label, the unhelpful default filter, the 8-second load time, and you fix them. 

• Product mindset - You think of reports as a user-facing product. You ask who the user is and what decision the report supports. 

• Pragmatic - You pick the simplest data architecture that solves the problem. 

• Ownership mindset - You treat reporting quality across the whole platform as your problem. 

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 

• Modern work environment with an open culture towards improvements and new ideas, supported by modern tools and equipment to do your job properly 

• A buddy system during onboarding and on-the-job learning with senior experts 

• Personal training budget 

• Participation in conferences, seminars, or industry events 

• Team-building activities, wellbeing initiatives, and company events 

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.