TECHNICAL LEAD - SSIS

Job Description MS SQL BI Developer (SSIS, SSRS, SSAS) Role Overview Key Responsibilities

• Design, develop, and maintain ETL solutions using SQL Server Integration Services (SSIS) .
• Build and optimize data warehouse and data mart solutions.
• Develop, deploy, and maintain reports and dashboards using SQL Server Reporting Services (SSRS) .
• Design and manage multidimensional and tabular models using SQL Server Analysis Services (SSAS) .
• Create complex SQL queries, stored procedures, functions, and views.
• Perform data extraction, transformation, cleansing, and loading activities.
• Work closely with business stakeholders to understand reporting and analytical requirements.
• Monitor and optimize ETL jobs, database performance, and data quality.
• Troubleshoot production issues and provide ongoing support.
• Participate in Agile/Scrum delivery processes.

Required Skills

• Strong experience with:
  • SSIS (SQL Server Integration Services)
  • SSRS (SQL Server Reporting Services)
  • SSAS (SQL Server Analysis Services)
• Microsoft SQL Server (2016/2019/2022)
• T-SQL Programming
• Stored Procedures, Triggers, Views, Functions
• Data Warehousing Concepts
• ETL Development
• Performance Tuning & Query Optimization
• Data Modeling (Star/Snowflake Schema)
• SQL Server Management Studio (SSMS)

Preferred Skills

• Power BI
• Azure Data Factory (ADF)
• Azure Synapse Analytics
• ETL Modernization Projects
• Data Migration Experience
• CI/CD for Database Deployments

Qualifications

• Bachelors degree in Computer Science, Information Technology, Engineering, or related field.
• Microsoft SQL certifications preferred.

Key Competencies

• Data Integration
• Data Warehousing
• Business Intelligence
• Reporting & Analytics
• Problem Solving
• Stakeholder Management
• Performance Optimization
• Agile Delivery

Short Job Posting Version

• SSIS ETL Development
• SSRS Reports & Dashboard Development
• SSAS Cubes/Tabular Models
• MS SQL Server & T-SQL
• Data Warehousing & Data Modeling
• Performance Tuning and Query Optimization
• Agile/Scrum

• Power BI
• Azure Data Factory (ADF)
• Azure Synapse

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.