Power BI Architect

Bazeta; Northern (KY); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Career development opportunities

Entrepreneurial environment

Job summary

Tiger Analytics seeks a senior Power BI Architect to lead the design, strategy, and governance of the enterprise BI platform using Power BI and Azure. You will guide BI Engineers, enforce security, and ensure scalable, high-performing BI solutions aligned with business needs.

With 10+ years in BI and 5+ years in Power BI architecture, you will drive capability assessments, governance, and collaboration with Microsoft partner teams to deliver enterprise-scale reporting across units.

Qualifications

• 10+ years of experience in Business Intelligence and Data Analytics.

Responsibilities

• Design scalable BI solutions with focus on infrastructure, capacity, and licensing needs.
• Define and enforce BI governance including security, data access, and workspace strategy.
• Provide effort estimations and delivery planning for BI initiatives.
• Architect and optimize semantic/OLAP models (star schema, composite models, aggregations, dataflows).
• Oversee dashboard/report design for enterprise-wide scalability and consistency.
• Collaborate with Azure Databricks, Synapse, and Data Lake teams for efficient BI consumption of large data.
• Define and implement CI/CD strategies using Git and Azure DevOps.
• Mentor BI Engineers on best practices in DAX, modeling, and performance optimization.
• Stay current on Microsoft Fabric and Power BI trends to future-proof BI strategy.

Skills

Power BI architecture

DAX modeling

ETL / data modeling

Azure Databricks

Synapse

Data governance

Security and access control

Leadership

Stakeholder management

CI/CD pipelines

Tools

Git

Azure DevOps

Deployment pipelines

Job description

# Power BI ArchitectUnited States8 hours agoID 975192Price on request## DetailsEmployment type: Full-timeRemote: YesCompany: Tiger AnalyticsLevel: Senior## DescriptionTiger 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.