Job Description

Job Description for Senior Software Engineer(MS BI Developer)

Key Responsibilities

Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS)

Develop and optimize complex SQL queries, stored procedures, views, and database objects in Microsoft SQL Server

Build and maintain operational and analytical reports using SQL Server Reporting Services (SSRS)

Participate in data warehouse design, dimensional modeling, and data integration initiatives

Analyze business and reporting requirements and translate them into technical solutions

Troubleshoot ETL failures, data discrepancies, and performance bottlenecks

Ensure data quality, consistency, and integrity across systems

Collaborate with business analysts, QA teams, and application developers

Perform code reviews and enforce development standards and best practices

Support production deployments and post-production issue resolution

Create and maintain technical documentation and deployment procedures

Participate in Agile/Scrum ceremonies and sprint planning activities

Required Qualifications

Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field

6+ years of experience in BI/ETL development

Strong hands-on experience with

Microsoft SQL Server

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)