Hybrid, US shift EST hours 9 AM EST to 6 PM EST (India timings are 6:30 PM IST to 3:30 AM IST)
Job Summary :
We are seeking an experienced MSBI Developer with Azure expertise to design, develop, support, and optimize enterprise data integration and business intelligence solutions. The ideal candidate should have strong hands-on experience in Microsoft SQL Server BI Stack (SSIS, SSRS, SSAS) along with exposure to Azure Data Services for building scalable data and reporting solutions.
Key Responsibilities :
- Design, develop, and maintain ETL solutions using SSIS (SQL Server Integration Services).
- Develop and optimize SQL Server stored procedures, functions, views, and complex queries.
- Create and maintain dashboards and reports using SSRS (SQL Server Reporting Services).
- Develop analytical and multidimensional solutions using SSAS (SQL Server Analysis Services).
- Build and maintain data warehouses and data marts.
- Work with business stakeholders to gather reporting and analytics requirements.
- Develop cloud-based data integration pipelines using Azure Data Factory (ADF).
- Work with Azure SQL Database, Azure Synapse Analytics, and Azure Storage.
- Support data migration and modernization initiatives from on-premise to Azure.
- Perform performance tuning and troubleshooting for ETL and reporting solutions.
- Implement data validation, monitoring, and error-handling mechanisms.
- Collaborate with cross-functional teams following Agile methodologies.
Required Skills :
MSBI Technologies :
- SQL Server (2016/2019/2022)
- SSIS
- SSRS
- SSAS
- T-SQL
- Data Warehouse Concepts
- ETL Development
Azure Technologies :
- Azure Data Factory (ADF)
- Azure SQL Database
- Azure Synapse Analytics
- Azure Data Lake Storage (ADLS)
- Azure Storage Accounts
- Azure DevOps
- Azure Monitor (preferred)
Additional Skills :
- Robust SQL query optimization skills
- Experience in data modeling and dimensional modeling
- Exposure to CI/CD pipelines
- Experience with Git/version control
- Knowledge of Agile/Scrum methodologies
Preferred Qualifications :
- Bachelors degree in Computer Science, Information Technology, or related field.
- Microsoft Azure certification is preferred.
- Experience in Power BI is an added advantage.
Nice to Have :
- Experience with Databricks
- Python scripting for data processing
- Exposure to Spark or big data technologies
- Experience in API-based integrations