Description

• Architect, design, and develop end-to-end business intelligence solutions using the Microsoft BI stack.
• Design, develop, and maintain scalable semantic layers to support enterprise reporting and analytics.
• Define data models, metrics, and KPIs for reporting and analytics.
• Lead efforts to design and optimize scalable multidimensional and tabular data models using SSAS/AAS and modern semantic modeling approaches.
• Demonstrate strong proficiency in DAX, Power Query, and SQL, along with designing intuitive and interactive Power BI dashboards.
• Work with modern data platforms including Snowflake to support analytics and reporting workloads. 
  
   

Project Management And Collaboration

 

• Manage project timelines, priorities, and deliverables effectively.
• Collaborate with cross-functional teams to deliver high-quality BI solutions.
• Communicate effectively with stakeholders to gather and refine requirements.
• Serve as a best practices resource for BI and analytics initiatives.
• Conduct training sessions and enablement for business users on modern BI tools.
• Mentor and guide junior team members on BI and data modeling best practices. 
  
   

Administration And Documentation

 

• Monitor and administer Power BI service capacities and environments.
• Troubleshoot, debug, and optimize BI solutions (reports, cubes, and semantic models).
• Define and maintain BI frameworks, semantic layers, and metadata repositories to support data governance.
• Document data warehouse structures, BI solutions, and metadata.
• Act as an escalation point for Power BI-related issues.
• Create and maintain technical documentation for BI tools and solutions. 
  
   

Qualifications: 

 

• Bachelor s degree in Computer Science, Engineering, or related field.
• 5 7 years of experience designing and developing BI solutions using Microsoft technologies.
• Strong proficiency in SQL, SSAS/AAS tabular modeling, DAX, Power BI, Paginated Reports, Gateway, Service, and Security.
• Experience working with Azure-based BI solutions (Azure SQL, Synapse, Data Factory, Data Lakes).
• Experience working with Snowflake, including data modeling and delivering analytics via Power BI.
• Strong experience designing semantic layers (core requirement).
• Experience with Power BI Service administration and capacity governance.
• Strong problem-solving, analytical, and communication skills.
• Hands-on experience with ETL development and data integration. 
  
   

Must-Have Skills:

 

• Extensive knowledge of Microsoft AAS/SSAS in developing cubes.
• Extensive knowledge of Microsoft Fabric and related tools.
• Strong expertise in semantic layer design and data modeling.
• Advanced knowledge of Power Query and DAX.
• Experience using Git for version control and deployment.
• Must have hands-on experience working with Snowflake.
• Experience working with Databricks. 
  
   

Preferred (Nice-to-Have) Skills:

 

• Experience with AI-driven analytics and reporting, including tools such as Microsoft Copilot and Snowflake Cortex.
• Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Azure Data Engineer Associate, Power BI).
• Experience with PowerShell.
• Experience coding in Python.
• Experience on MCP server integration and LLM models.
• Experience working and configuring AI Data Agents. Behavioral Competencies:
• Self-motivated with strong problem-solving abilities.
• Ability to work effectively across all levels of the organization.
• High attention to detail and commitment to quality.
• Ability to operate with urgency in ambiguous or high-risk situations.
• Strong collaboration skills and team-oriented mindset

Key Skills

Education

Bachelor's degree