Responsibilities:
1. Write complex stored procedures and queries in SQL Server.
2. Design, implement, and deploy Data Vault solutions for large-scale data integration.
3. Develop data warehousing solutions using Kimball or Inmon methodologies.
4. Build and maintain ETL workflows using SSIS.
5. Configure SSAS (multidimensional and tabular models) and create data cubes.
6. Design and implement business intelligence dashboards using Tableau or Power BI.
Requirements:
1. Language Level: Proficiency in English, minimum C1 level or higher.
2. Education: Relevant education level for the role.
3. Professional Experience:
1. Minimum 9-10 years in Software Development.
2. Minimum 3 years in Database Design and Development with Data Vault Modelling.
3. Minimum 12 years of experience writing Microsoft T-SQL code.
4. Minimum 3 years with Flyway deployment.
5. Minimum 12 years with SSAS (multidimensional + tabular) development.
6. Desirable: Minimum 6 years with Microsoft SSIS.
7. Desirable: Minimum 12 years in database dimensional modelling (Kimball and Inmon).
8. Desirable: Minimum 6 years with reporting tools like Tableau or Power BI.
4. Professional Knowledge:
1. Excellent knowledge of writing complex SQL queries and stored procedures.
2. Extensive experience with Microsoft SQL Server.
3. Strong knowledge of Data Vault modelling.
4. Expertise in SSIS and SSAS development and deployment.
5. Thorough understanding of data warehousing and dimensional modelling.
6. Desirable: Good knowledge of SSIS and SSAS server configuration and Power BI on-premises development.
7. Desirable: Knowledge of CI/CD systems (e.g., TFS) and Agile methodologies.
Location: Off Site.
#J-18808-Ljbffr