Power BI Architect

Location: Houston, Texas, United States

Department: BI

Workplace: remote

Employment Type: full

Description

Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms, including Forrester and Gartner. We are looking for top-notch talent as we continue to build the best analytics global consulting team in the world.

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.

Tiger Analytics provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy,
national origin, ancestry, marital status, protected veteran status, disability
status, or any other basis as protected by federal, state, or local law.