Join our dynamic team as a SQL BI Developer and play a crucial role in transforming data into actionable insights. Our project focuses on developing and maintaining a robust Business Intelligence (BI) platform that leverages the latest technologies in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and data analysis. You will be working on end-to-end data warehousing solutions, from designing dimensional models to creating efficient ETL processes. Our goal is to provide reliable and high-performance BI solutions that drive strategic business decisions. This work will be performed for one of our strategic external partners.
responsibilities :
ETL Development: Design, develop, and maintain ETL processes using SSIS to ensure seamless data integration and transformation.
Data Warehousing: Design and implement data warehouse solutions, ensuring data accuracy, integrity, and optimal performance.
Dimensional Modelling: Apply dimensional modelling concepts to create scalable and efficient database designs.
SQL Development: Write, optimize, and maintain complex T-SQL scripts and stored procedures to support data extraction, transformation, and loading activities.
Performance Tuning: Monitor and improve database performance through tuning techniques and best practices.
Business Intelligence: Develop and maintain SSAS cubes, ensuring data is easily accessible and performance is optimized for reporting and analysis.
Data Analysis: Conduct thorough data analysis to support business requirements and decision-making processes.
Collaboration: Work closely with business analysts, data scientists, and other stakeholders to gather requirements and deliver high-quality BI solutions.
Documentation: Maintain comprehensive documentation for ETL processes, data models, and database designs.
requirements-expected :
Experience in SSIS, SSAS and Data Analysis
Experience in TSQL, stored procedure, database performance tuning.
Experience in Data Warehousing and Business Intelligence and
Dimensional Modelling concepts with experience in Designing, developing & maintaining ETL, database
MS SQL Server
Good English language knowledge, written and spoken
offered :
Permanent contract from the very beginning (umowa o pracę)
Multisport/participation in cultural events
Lunch+ card which can be used in cafes and restaurants
On-site English classes
Training - professional certificates, webinars, classroom trainings
Online access to thousands of technical ebooks (Books 24x7, Safari Books Online) and trainings (SkillsSoft)
Fun rooms with a pool table, darts, football table, playstation and board games
benefits :
sharing the costs of sports activities
private medical care
sharing the costs of foreign language classes
sharing the costs of professional training & courses