Senior Data Warehouse Developer
Liam Tran
HR Administrator
Efterfrågade kompetenser
Om tjänsten
Role Summary
An experienced Data Warehouse Developer is needed for a socially important development initiative focused on improving the ability to detect, analyse and prevent welfare-related crime. The assignment will support more data-driven monitoring, control and analysis by consolidating information from multiple operational systems and data sources into accessible, reliable data assets.
The consultant will establish new data models, information structures and data flows within an existing data warehouse platform. The solutions will enable analysis of patterns, deviations and risk indicators, while creating a foundation for future reporting and analytics needs.
Key Responsibilities
- Develop, enhance and maintain the existing data warehouse.
- Design and implement ETL and ELT processes for integrating data from multiple business systems and data sources.
- Create data models and information structures that support reporting, analysis and follow-up activities.
- Perform dimensional data modelling in accordance with the Kimball methodology.
- Develop and optimise tabular models in SQL Server Analysis Services (SSAS).
- Prepare and maintain technical documentation for data warehouse solutions, integrations and models.
- Support testing, quality assurance and production deployment of delivered solutions.
- Collaborate closely with data warehouse developers, business representatives, project resources, and specialists in data, analytics, AI and information management.
Technical Stack & Requirements
- Microsoft on-premises data warehouse platform.
- SQL Server and SQL Server Integration Services (SSIS).
- ETL and ELT development, data transformation and data integration.
- Dimensional data modelling based on the Kimball methodology.
- Power BI, including tabular models.
- SQL Server Analysis Services (SSAS) tabular models.
- Data analysis and optimisation of analytical data models.
Qualifications & Experience
The consultant must have advanced Level 4 competence in ETL development, data warehousing, SQL Server and SSIS. Advanced Level 4 competence in Kimball dimensional modelling, data transformation and data analysis is also required. At least two years of experience with Power BI, including tabular models and SSAS, is mandatory. The role further requires at least five years of experience with SQL Server and SSIS.
Work Logistics & Location
This is a consulting assignment. The work is performed in collaboration with the client organisation and project team. No specific location or remote-work arrangement has been stated.