SSIS Developer

Job Description

Job Purpose As a member of the Business Intelligence team, the SSIS developer will be responsible for the integration of multiple heterogeneous systems into a SQL Data Warehouse. Main Tasks & Responsibilities Translate business rules into clear and systematic technical/functional requirements. Identify the correct Metrics and KPIs that match business needs. Identify the relevant data sources to produce the correct calculations of all necessary Metrics / KPIs. Design and develop Data Warehouse data models according to the best standards. Design and develop performant and scalable ETL processes considering every relevant stage (staging, cleansing, etc.). Develop reports and dashboards based on business requirements. Perform quality assurance checks over the entire Data Warehouse and Reporting infrastructures and implement/manage its security. Skills & Technical Competences & Behaviors 4+ years of experience in the design and development of Data Warehouse solutions in a MS SQL Server environment. Extensive experience in the development of SSIS packages and T-SQL scripts. Good to have knowledge regarding SSRS and SSAS. Good to have knowledge regarding cloud solutions (Azure SQL, Azure Data Factory, etc.). Exposure to the Power BI framework will be an added advantage. Exposure to other database management systems like MySQL or PostgreSQL will be a plus. Good analytical and problem-solving skills. Effective communication with business stakeholders and team members. Ability to work independently and as part of a team. Ability to handle multiple tasks simultaneously. Open to learn new BI skills. English proficiency (written and spoken).