- Communication with internal and external partners to shape the data infrastructure
- Proactive management of stakeholders’ and internal clients’ analytics needs
- Designing DWH architecture and Data Marts
- Maintenance, scheduling and troubleshooting of ETL jobs
- Adding new data sources (flat files, SQL Server, SFTP, AWS S3)
- Writing batch scripts to move/ archive/ merge source flat files.
- Developing SSIS packages; stored procedures, functions, views, tables in SQL Server.
- Performing data quality checks
- SQL Server (Scheduling SQL Agent Tasks, Indexing, Performance tuning )
- strong T-SQL - writing skills View, Stored Procedures, Analytical Functions, Triggers, etc.
- designing DWH and DB solutions (Star Schema, Snowflake)
- ETL development
Stručna spremaSrednja stručna sprema
Digitalne vještineExcel, Microsoft SQL Server Integration Services (SSIS), SQL, MSSQL
JezikEngleski (A1), Njemački (A1)
Minimalne godine radnog iskustva3-5