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