JuicyLemons logo

BI / Reporting Analyst

JuicyLemons

On-site๐Ÿ‡ฉ๐Ÿ‡ชMunich, BY, GermanymidPosted 2h ago

Visa & sponsorship

  • DE Blue Card: this role is on the national occupation list. The posting doesn't state a salary we could check against the threshold.

Job description

BI / Reporting Analyst (All Genders)

The company and business sits in a tightly regulated, high-stakes industry and is transitioning from small-batch production into full-volume manufacturing, this hire is central to making that jump work.

The Operations Excellence team reports into the COO's organization and acts as a strategic partner to managers, team leads, and colleagues throughout the company. They drive efficiency, scalability, and faster goal achievement by delivering data-backed insight, leading high-priority projects, and pushing continuous process improvement.

As an individual contributor on this team, you'll take full ownership of complex, high-impact initiatives. You'll work directly with stakeholders across the business, shape core operating processes, influence major decisions, and play a direct role in the growth of one of Europe's fastest-scaling company.

Your Mission

As BI/Reporting Analyst, you'll own the data infrastructure and visualization layer for our Operations Planning and Analytics team. That starts with mapping today's data landscape โ€” where information lives across our ERP, MES, and PLM systems, and how it currently flows between them โ€” then designing a structured way to store and move that data, replacing fragile, ad-hoc pipelines with systems that are maintainable and well-documented. Once that foundation is solid, you'll turn the data into reporting that operational teams and leadership can actually act on.

What You'll Do

  • Audit our current data flows across ERP, MES, and PLM systems โ€” understand what exists, where it's stored, and how it reaches reporting outputs

  • Design a structured data storage and pipeline architecture, defining sources of truth, data models, and refresh schedules

  • Build and maintain a reliable data warehouse and pipelines to replace manual CSV exports and one-off point-to-point connections

  • Take ownership of data quality โ€” define checks, document known issues, and make sure stakeholders can trust what they're looking at

  • Document data models, pipeline logic, and reporting definitions, so nothing depends on tribal knowledge

  • Partner with the Operations Planning and Analytics Lead to turn operational questions into well-structured data products

What You Bring

  • 3โ€“5 years of experience in data engineering, analytics engineering, or BI

  • Hands-on experience with a cloud data warehouse โ€” Snowflake, BigQuery, Redshift, or Fabric

  • Strong SQL skills โ€” complex queries, performance tuning, views, and data models

  • Experience designing and maintaining ETL/ELT pipelines

  • Solid grasp of data modeling โ€” both dimensional and relational approaches

  • Comfort working with ambiguity in a build-from-zero environment, without an existing clean data model to fall back on

  • A BSc in Computer Science, Data Science, Business Informatics, or a related field