Power BI Architect

Tiger Analytics; Houston (TX); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Career development opportunities

Job summary

Tiger Analytics is seeking a Power BI Architect in Houston to lead the design, strategy, and governance of the enterprise BI platform within the Azure ecosystem. You will guide BI Engineers, enable scalable reporting, and align BI solutions with business needs.

The role requires 10+ years in BI/Data Analytics with 5+ years in Power BI architecture and strong governance, data security, and collaboration with cross-functional teams. On-site in Houston with opportunities for growth.

Qualifications

• 10+ years of BI and data analytics experience, with 5+ years in Power BI architecture.
• Designing scalable BI/analytics infrastructure solutions.
• Expertise in Power BI Premium/Fabric, DAX, Power Query (M), Tabular Models.
• Strong knowledge of Azure Databricks, Synapse, Data Lake, SQL Server.
• Hands-on with CI/CD pipelines (Git, Azure DevOps).
• Governance, security, and data privacy understanding.
• Excellent communication and leadership abilities.

Responsibilities

• Design scalable BI solutions with a focus on infrastructure, capacity, and licensing needs.
• 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 for enterprise-scale reporting.
• Establish and manage a central metrics store for standardized KPIs and calculations.
• Architect and oversee dashboard/report design, ensuring scalability and consistency.
• Collaborate with Azure Databricks, Synapse, and Data Lake teams to enable BI consumption of large data.

Skills

Leadership

Communication

Stakeholder management

Tools

Power BI Premium

Fabric

DAX

Power Query (M)

Azure DevOps

Git

Job 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.