BI & Data Engineer

About the role

We'rehiring aBI & Data Engineerto 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 atVimachem, giving you a rare opportunity to define the company's analytics foundations from the ground up.You'llhavesignificant influenceover tooling,modelingstandards, reporting architecture, and how data isleveragedacross 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, performantMetabasedashboards. You will own the reporting experience the same way a product engineer owns a feature.

You willoperateacross three dimensions:

• Data layer ownership- Design andmaintainthe models and pipelines that feed every report on the platform. Get the data right, keep it fast.

• Report craft- Build dashboards inMetabasethat 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."

Whatyou'lldo 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 themodeling/ semantic layer inMetabaseso 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 whatdoesn't

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

Whatwe'relooking 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 inMetabase(or a direct equivalent: Looker, Superset, Power BI, Tableau, Mode)

• Experience designing data models for analytics (dimensionalmodeling, semantic layers, or similar)

• Experience with at least one modern data transformation stack (dbt,SQLMesh, or hand-rolled pipelines in Python/SQL)

• Track recordof 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

• DirectMetabaseexperience, including themodelinglayer or embedded analytics

• Experience with time-series data and tools likeTimescaleDB

• 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'llpersonally 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