01 Zakres zadań
- Write and optimise production T-SQL (stored procedures, views, functions, ODS/DWH transformations)
- Model and evolve the data warehouse (dimensions, facts, historisation)
- Build Azure Data Factory pipelines with parameterisation, error handling and monitoring
- Develop Power BI reports and semantic models (DAX, Power Query/M, RLS, paginated reports) and SSRS reports
- Reverse-engineer and migrate legacy SSIS packages and on-prem logic to Azure-native solutions
- Deliver schema changes via DACPAC and CI/CD (DEV → SIT → UAT → PROD)
- Develop Databricks notebooks and jobs (SQL / PySpark)
- 🔹une performance end to end: execution plans, indexing, partitioning, incremental loads
- Own data quality and reconciliation between the legacy and new platforms
- Work directly with Finance, Compliance and Business Analysts
