For more than 30 years, microtech GmbH has developed and distributed ERP software for business operations. Its büro+ and ERP-complete products support inventory management, payroll, and financial accounting. Based in Bad Kreuznach, microtech has 65 employees, including 30 working in application development and customer support. The company has been part of the Buhl Data Service group since 2004.
Analytics Engineer, Data Stack and Power BI
Join microtech to develop and operate its analytics stack using SQL, dbt, Power BI and data quality checks. The role spans data architecture, reporting, reliable production operations and collaboration with business teams.
Description
- Extend the data architecture from source system connections and transformations through orchestration to Power BI models.
- Translate business definitions into reliable data models in partnership with business teams.
- Document clearly how metrics are calculated.
- Create useful Power BI dashboards and reports.
- Protect data quality with automated tests and comparisons against source systems.
- Monitor the production analytics stack, investigate incidents and restart services when needed.
- Administer Power BI access permissions.
- Work with Internal IT on infrastructure matters.
- Apply and evaluate AI tools for models, scripts, tests and documentation from both functional and technical perspectives.
- Partner with Controlling and executive management.
Requirements
- Strong SQL skills, preferably with PostgreSQL.
- Hands-on experience with dbt or a similar data transformation framework.
- Strong Power BI capabilities, especially data modeling and DAX.
- Proficiency with Git and code review workflows.
- Experience with production systems and readiness to help keep them operating reliably.
- Sound understanding of commercial concepts such as revenue, recurring revenue, churn, receivables and budget-versus-actual reporting.
- Openness to AI-supported workflows and a consistent habit of validating their outputs.
- An analytical, organized and detail-focused working style.
- Business-fluent German.
- Experience with Claude Code or similar AI tools is welcome, but not essential.
- Experience with data replication tools or methods such as Airbyte or CDC is an advantage.
- Familiarity with workflow orchestration tools such as Kestra, Airflow or Dagster is an advantage.
- Knowledge of Terraform and Azure is an advantage.
- Experience with ERP data and subscription or contract-based business models is an advantage.
Benefits
- A secure role in a successful corporate group with long-term prospects.
- Flexible work arrangements, including remote work and regular on-site attendance in Hargesheim.
- 30 days of annual leave, plus special leave for personal occasions.
- JobRad bicycle leasing.
- A work café with table football and a relaxation room.
- Muesli and fresh fruit.
- Complimentary drinks.
- Attractive employee discounts.
- Tailored development opportunities in your field.
- Professional training and development opportunities.
- Flat hierarchies, quick decisions and room to shape your work.
- Modern technical equipment.
- A collaborative, motivated team environment.
- Company events.