Job offers

Business Intelligence Consultant


Maintenance of Forecast Tool (MS SQL database) and Forecast Report – Support in operation and for smaller extensions.

Job description:

  • governing and supporting the regular services forecasting process (Excel data collection on SharePoint, daily auto-mated import via SSIS to MSSQL database)
  • maintaining and governing the weekly and monthly reporting to departments (MSSQL based SSRS reporting environment)
  • deriving the forecasts for strategic suppliers on a monthly basis (SSRS based)
  • distributing new version of supplier list (Excel, VBA-based rollout)
  • supporting the regular forecast process (support in how to collect data, Excel support, bugfixing)
  • monitoring and maintaining the daily import process (SSIS)
  • continuously improving the forecasting (data collection) pro-cess (Excel)
  • implementing new reporting requirements on demand (SSRS)
  • integration of new Data/APIs into the existing data architecture on demand (SSIS, MSSQL database)

The successful candidate will demonstrate:

  • experienced SSIS skills, including Excel Sources (Query based) and Sharepoint ODATA Sources
  • experienced T-SQL skills
  • experienced SSRS Skills
  • basic Data Architecture skills (Star Schema)
  • advanced Excel skills, including Light VBA programming and Basics in PowerQuery
  • experienced Light Sharepoint skills (nice to have)
  • good communication skills in written and spoken in English

As a candidate you have:

  • understanding of data related business processes and performance management
  • experience in reporting and visualisation design
  • knowledge of business communication standards

Interested in this position?

Apply now

Why work with us?

Let&s be fit

We realize that most of us need assistance to stay in shape and good health. That's why we provide every employee with a medical package coverage and co-finance a sports card. Additionally, we support a number of sports sections, and, you can even join our yoga team in the summer to practice yoga on the roof!

Let&s be balanced

Work-life balance is essential for us. That's why we offer our employees flexible working hours, pet-friendly offices, and if you would like to stay with your pet at home, a remote work environment. However, it won't be easy to stay at home with our in-office gaming room.

Let&s be smart

Staying up-to-date with all the new systems and technologies is not an easy task. That's why we have an extensive training and workshops offer, both in-house and with external providers. We organize hackathons and meetups, which are an excellent opportunity for our specialists to showcase their expertise. On top of that, we offer digital learning platforms, language courses, and a library.

Let&s be responsible

We love to see the difference we make together with our CSR projects. That's why we are always open to new projects, and we would love to include you in our next charity event!

Let&s be fun

At ET&S we love not only to work but also relax together. Sports events like company-wide bike race, or maybe a film marathon in our cinema room? Don't worry; we got it covered! Maybe you have a passion and would love to make an event out of it? Sure! We will help you!

Let&s be diverse

At ET&S we create a working environment free of prejudice and exclusion. Each member of our team can experience being valued, regardless of his or her gender, nationality, religious beliefs, disabilities, age, and sexual orientation or identity. Your wide range of qualifications, experiences, and ways of thinking are of great benefit to us!

Get to know us better

Check how it is working at ERGO Technology & Services

link to facebook

link to linkedin