BI Specialist (Microsoft Stack & Power BI)

SUMMARY:
Job Purpose:
Our client is seeking a highly skilled BI Specialist with strong expertise in the Microsoft BI stack, particularly Power BI, to design, develop, and maintain robust data models and visualizations that support strategic and operational decision-making. The ideal candidate will have deep knowledge of data modeling, DAX, Power Query, and integration with data sources such as SQL Server, Azure, and Excel.
 
Key Responsibilities:

• Design, develop, and deploy Power BI dashboards and reports tailored to business needs.
• Build and optimize data models using DAX and Power Query for performance and scalability.
• Translate business requirements into technical solutions leveraging the Microsoft BI stack (Power BI, SSAS, SQL Server, Azure Data Services).
• Collaborate with stakeholders to understand data needs and deliver actionable insights.
• Maintain and enhance the Power BI service environment including workspaces, datasets, and scheduled refreshes.
• Develop and document ETL processes using Power Query, SQL, or Azure Data Factory.
• Ensure data quality, integrity, and consistency across reports and data sources.
• Monitor report performance and conduct ongoing tuning to ensure efficiency.
• Train and support business users in Power BI usage and self-service analytics.

• Advanced Power BI development (Dashboards, Reports, DAX, Power Query).
• Strong proficiency with Microsoft SQL Server (T-SQL, views, stored procedures).
• Solid understanding of data warehousing, dimensional modeling, and ETL processes.
• Familiarity with Azure Data Services (e.g., Azure Synapse, Azure Data Lake, Azure SQL, Data Factory) is highly desirable.
• Knowledge of SSAS (Tabular models) and SSIS is advantageous.
• Ability to translate complex datasets into intuitive visualizations and narratives.
• Strong problem-solving, critical thinking, and communication skills.
• Experience with Agile/Scrum methodologies is a plus.

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field.
• Minimum of 3–5 years of experience in BI development, with a focus on Power BI.
• Microsoft certifications (e.g., PL-300, DP-500, or equivalent) are advantageous.
• Experience working with cross-functional teams in a data-driven environment.

• Work in a data-centric, innovation-driven organization.
• Be part of a collaborative and skilled BI team.
• Access to cutting-edge Microsoft tools and cloud technologies.
• Opportunities for professional growth and certification sponsorship.
• Flexible work arrangements and supportive work culture.

POSITION INFO:
Job Purpose:
Our client is seeking a highly skilled BI Specialist with strong expertise in the Microsoft BI stack, particularly Power BI, to design, develop, and maintain robust data models and visualizations that support strategic and operational decision-making. The ideal candidate will have deep knowledge of data modeling, DAX, Power Query, and integration with data sources such as SQL Server, Azure, and Excel.

Key Responsibilities:

• Design, develop, and deploy Power BI dashboards and reports tailored to business needs.
• Build and optimize data models using DAX and Power Query for performance and scalability.
• Translate business requirements into technical solutions leveraging the Microsoft BI stack (Power BI, SSAS, SQL Server, Azure Data Services).
• Collaborate with stakeholders to understand data needs and deliver actionable insights.
• Maintain and enhance the Power BI service environment including workspaces, datasets, and scheduled refreshes.
• Develop and document ETL processes using Power Query, SQL, or Azure Data Factory.
• Ensure data quality, integrity, and consistency across reports and data sources.
• Monitor report performance and conduct ongoing tuning to ensure efficiency.
• Train and support business users in Power BI usage and self-service analytics.

• Advanced Power BI development (Dashboards, Reports, DAX, Power Query).
• Strong proficiency with Microsoft SQL Server (T-SQL, views, stored procedures).
• Solid understanding of data warehousing, dimensional modeling, and ETL processes.
• Familiarity with Azure Data Services (e.g., Azure Synapse, Azure Data Lake, Azure SQL, Data Factory) is highly desirable.
• Knowledge of SSAS (Tabular models) and SSIS is advantageous.
• Ability to translate complex datasets into intuitive visualizations and narratives.
• Strong problem-solving, critical thinking, and communication skills.
• Experience with Agile/Scrum methodologies is a plus.

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field.
• Minimum of 3–5 years of experience in BI development, with a focus on Power BI.
• Microsoft certifications (e.g., PL-300, DP-500, or equivalent) are advantageous.
• Experience working with cross-functional teams in a data-driven environment.

• Work in a data-centric, innovation-driven organization.
• Be part of a collaborative and skilled BI team.
• Access to cutting-edge Microsoft tools and cloud technologies.
• Opportunities for professional growth and certification sponsorship.
• Flexible work arrangements and supportive work culture.