DATA ARCHITECT - SSIS

Happiest Minds Technologies · IT Services & Consulting

Bengaluru
On-site
Posted today
Data & AI

Apply on Happiest Minds Technologies Create resume for this job

About the job

Job Description ? MS SQL BI Developer (SSIS, SSRS, SSAS)

Job Title: MS SQL BI Developer

Experience: 9-12 Years

Location: Bangalore / Hyderabad / PAN India

Employment Type: Full-Time

Role Overview

We are seeking an experienced MS SQL BI Developer with strong expertise in SSIS, SSRS, and SSAS to design, develop, and support enterprise data integration, data warehousing, reporting, and analytics solutions. The ideal candidate should possess hands-on experience in SQL Server Business Intelligence technologies and be capable of building scalable ETL processes, analytical models, and business reports.

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

Bachelor's 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

Hiring: MS SQL BI Developer (SSIS, SSRS, SSAS)

Experience: 5-8 Years | Location: Bangalore/Hyderabad/Remote

We are looking for an experienced MS SQL BI Developer with strong expertise in SSIS, SSRS, and SSAS .

Required Skills:

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

Preferred:

Power BI

Azure Data Factory (ADF)

Azure Synapse

Experience: 5-8 years in SQL Server BI development and enterprise reporting solutions.

Apply on Happiest Minds Technologies