Hiring BI Developer for Cloud based IT Company

Post A Resume HR Consultancy

  • Ahmedabad, Gujarat
  • Permanent
  • Full-time
  • 1 month ago
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 organization’s 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:
  • Bachelor’s 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)

Post A Resume HR Consultancy