10+ years in Business Intelligence and Data Analytics, with 5+ years in Power BI architecture.
Proven track record in designing scalable BI infrastructure solutions.
Expert in Power BI Premium/Fabric, DAX, Power Query (M), and OLAP models.
Strong knowledge of Azure Databricks, Synapse, Data Lake, and SQL Server.
Hands-on experience with CI/CD pipelines (Git, Azure DevOps).
Skilled in data refresh automation and troubleshooting.
Strong grasp of data governance and enterprise security frameworks.
Responsibilities
Lead the design and strategy of the enterprise BI platform using Microsoft Power BI.
Assess infrastructure requirements to ensure scalable BI solutions.
Define governance frameworks for data access, security, and workspace management.
Create effort estimations and delivery plans for BI projects.
Design and optimize semantic and OLAP models for reporting.
Manage a central metric store for standardized KPIs and calculations.
Collaborate with Azure Databricks and Synapse teams for large data BI consumption.
Benefits
Significant career development opportunities as the company grows.
Gain experience in a fast-paced, challenging, entrepreneurial environment.
Enjoy a high degree of individual responsibility in your role.
Full Job Description
The Power BI Architect will lead the design, strategy, and governance of the enterprise BI platform using Microsoft Power BI and the Azure ecosystem. This role involves assessing infrastructure requirements, defining best practices, guiding BI Engineers, enabling security, handling large data, and ensuring scalable, high-performing BI solutions that align with business needs.
Key Requirements:
Design scalable BI solutions with a focus on infrastructure, capacity, and licensing needs.
Conduct capability assessments to align Power BI adoption with enterprise goals.
Define and enforce Power BI governance frameworks, including security, data access, and workspace strategy.
Provide effort estimations and delivery planning for BI initiatives.
Design and optimize semantic/OLAP models (star schema, composite models, aggregations, dataflows) for enterprise-scale reporting.
Establish and manage a central metric store for standardized KPIs and calculations.
Architect and oversee dashboard/report design, ensuring scalability, usability, and consistency across business units.
Partner with Azure Databricks, Synapse, and Data Lake teams to enable efficient BI consumption of large data.
Collaborate with Microsoft partner teams to evaluate new capabilities and align with best practices.
Define and enforce CI/CD strategies using Git, Azure DevOps, and deployment pipelines.
Oversee data refresh automation, monitoring, and troubleshooting at scale.
Guide and mentor BI Engineers on best practices in DAX, modeling, performance optimization, and visualization standards.
Stay current on Microsoft Fabric, Power BI Premium, and emerging BI trends to future-proof the BI strategy.
Qualifications & Skills:
10+ years of experience in Business Intelligence and Data Analytics, with 5+ years in Power BI architecture.
Proven experience in designing scalable BI/analytics infrastructure solutions.
Expertise in Power BI Premium/Fabric, DAX, Power Query (M), Tabular Models, and large semantic/OLAP models.
Strong knowledge of Azure Databricks, Synapse, Data Lake, SQL Server.
Hands-on with CI/CD pipelines (Git, Azure DevOps, deployment pipelines).
Skilled in refresh automation, monitoring, and troubleshooting large models.
Strong understanding of data governance, compliance, and enterprise security frameworks.
Excellent communication, stakeholder management, and leadership skills.
Experience working with Microsoft partner teams on solution alignment and best practices.
Benefits
Significant career development opportunities exist as the company grows. The position offers a unique opportunity to be part of a small, fast-growing, challenging, and entrepreneurial environment, with a high degree of individual responsibility.
About Tiger Analytics
Tiger Analytics is a consulting firm that provides data analytics consulting services to businesses. The company specializes in data science, machine learning, and artificial intelligence. Tiger Analytics helps businesses to leverage data to make better decisions, improve operations, and drive growth. The company has worked with clients in a variety of industries, including healthcare, retail, finance, and technology.