Data analyst - reporting specialist

International logistics centre in Prague.

Your new company
There is an international centre - afters sales in Prague. They are just about to establish new reporting team.

Your new role

  • Support and further development of KPI calculations via SQL queries
  • Setup of data flows from source system interfaces over data warehouse layers - including data harmonization and transformation - up to a final report
  • Interface setup and adjustments to ensure correct data flows
  • Data modelling in SQL server backend and using of ETL tools (i.e. Microsoft SSIS)
  • Close cooperation with the business interface inside and outside the team for the correct evaluation of KPIs
  • Global standardization of determination/extraction of data from different databases
  • Dealing with complex data structures and databases
  • Daily data load monitoring and if needed independent issue analysis and bug fixing

What you'll need to succeed

  • Experience with dealing with complex data structures and databases,
  • setting up data warehouse / business intelligence systems in an SQL environment,
  • setting up data loads with ETL tools (i.e. MS SSIS),
  • database administration (login/user setup, data compression etc.),
  • reports automation.
  • Fluent English
  • Microsoft SQL Server (SQL Server Management Studio, Visual Studio and SSIS)
  • Experience with reporting tools (i.e. MS Power BI or SAP Analytics Cloud)
  • SQL ETL processes and SQL queries
  • data modelling with SQL (creation of new tables or complex views, scripting of procedures, data manipulations with inserts, updates, etc.)
  • data warehouse / business intelligence layers (import, history, harmonization and transformation as well as reporting layer)
  • Big Data and advanced analytics

What you'll get in return

  • 1 day a week in office, if you prefer it
  • Open company culture
  • Benefits, bonusses
  • Trainings
  • International working environment

What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career. #1171859
Click here to access HAYS Privacy Policy, which provides detailed information on how we use and protect your personal information, and your rights in relation to this.


Job Type
Automobilový průmysl
Data & Advanced Analytics
Closing date
28 Feb 2023

Talk to a consultant

Talk to Klára Antošová, the specialist consultant managing this position, located in Praha
Hays Czech Republic, Olivova 4/2096

Telephone: +420 602564956


  • HR Specialist with Dutch

    HR Specialist with Dutch
  • Cyber Security specialist

  • Order Fulfillment Specialist

    Order, Order Management, Order Specialist, Manufacturing, Specialist