Hiring BI Developer Lead for Cloud based IT Company

Ahmedabad - India

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Job Description:

The Senior BI Developer (Microsoft Stack) is responsible for designing building and managing end-to-end Business Intelligence solutions using Microsoft technologies. The role involves developing robust data models implementing ETL/ELT pipelines building interactive reports and optimizing the organizations data ecosystem to deliver actionable insights.

Key Responsibilities:

1. Solution Design and Development:
Design develop and maintain data warehouses using SQL Server or Azure Synapse Analytics.
Build ETL/ELT pipelines using SQL Server Integration Services (SSIS) Azure Data Factory (ADF) or other Microsoft tools.
Develop and deploy highly interactive dashboards and reports using Power BI.
Create and maintain tabular and multidimensional models in SQL Server Analysis Services (SSAS).

2. Collaboration and Stakeholder Management:
Collaborate with business stakeholders to gather requirements and translate them into scalable BI solutions.
Work with cross-functional teams including business analysts data engineers and IT teams to ensure alignment on deliverables.

3. Data Governance and Quality Assurance:
Implement data governance best practices ensuring compliance with organizational and regulatory standards.
Ensure data accuracy completeness and consistency across all BI solutions.
Write and maintain technical documentation for BI solutions including data models ETL workflows and reporting processes.

4. System Optimization and Maintenance:
Optimize database performance including query tuning indexing and storage strategies.
Monitor and troubleshoot performance issues across BI systems.
Ensure scalability and high availability of BI systems.

5. Leadership and Mentoring:
Mentor junior developers fostering best practices in BI development and Microsoft stack usage.
Lead BI-related projects ensuring delivery within scope budget and timeline.

Essential Skills:
BI Tools and Development:
Extensive experience with Power BI (data modeling DAX visualizations and report deployment).
Proficiency in SQL Server (T-SQL for querying database design and optimization).
Expertise in SSIS for ETL/ELT processes.
Strong experience with SSAS including tabular models and MDX/DAX queries.

Data Platforms:
Experience with Azure Data Platform components such as Azure SQL Database Azure Synapse Analytics Azure Data Lake and Azure Data Factory.
Data Modeling and Architecture:
Strong understanding of dimensional modeling and star schema design.
Familiarity with modern data warehousing methodologies such as data lakehouse architecture.

Preferred Skills:
Experience with Azure DevOps for CI/CD pipelines in BI solutions.
Knowledge of Azure Machine Learning Power Automate or Power Apps for advanced automation and integration.
Experience with Microsoft Purview for data governance.

Qualifications:
Bachelors degree in Computer Science Data Analytics Information Systems or a related field.
5 years of experience in BI development with significant exposure to the Microsoft stack.
Certifications are a strong advantage:
Microsoft Certified: Data Analyst Associate
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Azure Solutions Architect Expert

(Working Hours/Timing:1:30 pm to 10:30 pm 6 months and 2:30 pm to 11:30 pm 6 months due to daylight UK timing)

Interested candidate can send their resume on
Call now on 91-

Required Experience:

Job Description:The Senior BI Developer (Microsoft Stack) is responsible for designing building and managing end-to-end Business Intelligence solutions using Microsoft technologies. The role involves developing robust data models implementing ETL/ELT pipelines building interactive reports and optimi...