MSBI Developer 2

The ideal candidate should have excellent SQL development skills, hands-on experience with the Microsoft BI technology stack, and the ability to translate business requirements into reliable data and reporting solutions.

Responsibilities

• Design, develop, test, deploy, and maintain MSBI solutions using SQL Server and Microsoft BI technologies.
• Develop and maintain SSIS packages for ETL and data integration processes.
• Extract, transform, and load data from multiple heterogeneous data sources into data warehouses and data marts.
• Design and develop complex T-SQL queries, stored procedures, functions, views, triggers, and scripts.
• Develop, enhance, and maintain SSRS reports, including parameterized, drill-down, drill-through, and operational reports.
• Develop and maintain SSAS Tabular and/or Multidimensional models based on project requirements.
• Work on data warehouse design, including fact tables, dimension tables, star schemas, and snowflake schemas.
• Perform data analysis, data validation, reconciliation, and troubleshooting.
• Optimize SQL queries, stored procedures, ETL processes, and reports to improve application performance.
• Troubleshoot production issues related to ETL jobs, databases, reporting, and data quality.
• Implement error handling, logging, auditing, and restart/recovery mechanisms within ETL solutions.
• Schedule and monitor ETL processes using SQL Server Agent or enterprise scheduling tools.
• Collaborate with business analysts, data architects, application teams, and business stakeholders to understand reporting and analytical requirements.
• Participate in code reviews, unit testing, integration testing, deployment, and production support.
• Prepare and maintain technical documentation, data mappings, ETL specifications, and deployment documents.
• Follow development standards, version-control practices, and CI/CD processes.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 4+ years of hands-on experience in MSBI/Business Intelligence development.
• Strong experience developing ETL processes using SSIS.
• Strong SQL programming and performance-tuning experience.
• Hands-on experience developing reports using SSRS.
• Experience with SSAS Tabular or Multidimensional models.
• Good understanding of relational databases, data warehousing, and dimensional modeling.
• Ability to analyze complex business requirements and convert them into technical BI solutions.
• Strong analytical, troubleshooting, and problem-solving capabilities.
• Good communication and stakeholder-management skills.
• Ability to work independently as well as within geographically distributed teams.