Msbi Software Engineer

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).