Sr. BI Developer

URGENT JOB OPENING - Sr. BI Developer (Microsoft Stack) for UK based pharmaceutical company for their IT branch office in Ahmedabad

The selected candidate should have excellent communication and interpersonal skills to liaise with project managers and business users in United Kingdom.

The work hour for this position will be (13:30 to 22:30 [April to October] 14:30 to 23:30 [October to March]. Salary is not a constraint for the right candidate. Please note that the selected candidate might need to travel to the UK depending on the requirement.

Job Title:

Senior BI Developer (Microsoft Stack)

Role Overview:

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:

2. Design, develop, and maintain data warehouses using SQL Server or Azure Synapse Analytics.

3. Build ETL/ELT pipelines using SQL Server Integration Services (SSIS), Azure Data Factory (ADF), or other Microsoft tools.
4. Develop and deploy highly interactive dashboards and reports using Power BI.

5. Create and maintain tabular and multidimensional models in SQL Server Analysis Services (SSAS).

6. Collaboration and Stakeholder Management:

7. Collaborate with business stakeholders to gather requirements and translate them into scalable BI solutions.

8. Work with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment on deliverables.

9. Data Governance and Quality Assurance:

10. Implement data governance best practices, ensuring compliance with organizational and regulatory standards.

11. Ensure data accuracy, completeness, and consistency across all BI solutions.

12. Write and maintain technical documentation for BI solutions, including data models, ETL workflows, and reporting processes.

13. System Optimization and Maintenance:

14. Optimize database performance, including query tuning, indexing, and storage strategies.

15. Monitor and troubleshoot performance issues across BI systems.

16. Ensure scalability and high availability of BI systems.

17. Leadership and Mentoring:

18. Mentor junior developers, fostering best practices in BI development and Microsoft stack usage.

19. Lead BI-related projects, ensuring delivery within scope, budget, and timeline.

Skills and Qualifications:

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.
• Familiarity with scripting languages like Python or R for advanced data transformations or analytics.
• Experience with Microsoft Purview for data governance.

Soft Skills:

• Excellent communication and stakeholder engagement skills.
• Analytical mindset with a focus on problem-solving.
• Ability to work independently and lead multiple projects simultaneously.
• Strong documentation and organizational skills.

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

Key Competencies:

• Strategic Thinking and Planning
• Attention to Detail
• Leadership and Mentorship
• Adaptability to Emerging Technologies

EXCELLENT COMMUNICATION SKILLS REQUIRED

Candidate should have Mandatory Skills in Stack, SQL, TSQL, SSIS, SSAS, POWER BI.

Kindly send me your updated resume