Msbi Software Engineer

Brace Infotech; Hyderabad; On-site; INR 8,00,000 - 12,00,000; Full time

Job summary

A technology company in Hyderabad is seeking a Business Intelligence Developer experienced in ETL processes using SSIS and SSRS. You will design and maintain reports and dashboards, ensure data quality, and collaborate with teams to recommend BI solutions. The ideal candidate has at least 4 years of experience in MSBI, strong SQL skills, and knowledge of data warehousing concepts. This role offers a collaborative environment focused on data integrity and compliance.

Qualifications

• Minimum of 4 years of hands-on experience in MSBI, especially SSIS & SSRS.
• Strong in SSIS creating, scheduling, monitoring, and deploying ETL packages.
• Solid SQL skills (T-SQL), ability to write efficient queries, stored procedures.

Responsibilities

• Design, develop, test, and maintain end-to-end ETL processes using SSIS.
• Build, deploy, and maintain reports and dashboards using SSRS.
• Troubleshoot data quality issues and implement robust error handling.

Skills

MSBI

SSIS

SSRS

SQL

Data warehousing concepts

Tools

Git

Job description

Key Responsibilities

• Design, develop, test, and maintain end-to-end ETL processes using SSIS to extract, transform, and load data from multiple sources (databases, flat files, APIs) into data warehouses.
• Build, deploy, and maintain reports, dashboards, and visualizations using SSRS. Translate business requirements into meaningful reports.
• Collaborate with business analysts, data architects, and other stakeholders to gather requirements, analyze data needs, and recommend BI solutions.
• Optimize existing SSIS packages & SSRS reports for performance, scalability, and maintainability.
• Troubleshoot data quality issues, report errors, and ETL failures; implement robust error handling, logging, and recovery logic.
• Participate in design & architecture discussions around data warehousing, data modelling, and reporting best practices.
• Ensure data security, data integrity, and compliance standards are met in ETL and reporting activities.
• Document ETL workflows, reporting logic, data lineage, and processes; aid in knowledge transfer.
• Support maintenance & enhancements of BI solutions; possibly support deployment, versioning, and environment migrations (Dev/Test/Prod).

Required Skills & Qualifications

• Experience: Minimum of 4 years of hands-on experience in MSBI, especially SSIS & SSRS.
• Technical Skills:
• Strong in SSIS creating, scheduling, monitoring, and deploying ETL packages.
• Strong in SSRS report design (tabular, matrix, charts), parameterized reports, subscriptions, drill-down/drill-through.
• Solid SQL skills (T-SQL), ability to write efficient queries, stored procedures, views, functions.
• Experience with data warehousing concepts: star/snowflake schemas, slowly changing dimensions, fact/dimension tables, indexing, partitioning etc.
• Familiarity with performance tuning of ETL and reporting systems.
• Knowledge of version control systems (Git or similar).