About this role.
Tiger Analytics seeks a Power BI Architect to lead enterprise BI strategy and design using Microsoft Power BI and Azure. The role involves defining governance, optimizing semantic models, and ensuring scalable solutions. Candidates need 10+ years of BI experience with 5+ years in Power BI architecture. The position offers career growth in a fast-paced consulting environment. This is a senior-level role requiring deep technical and leadership skills.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
4/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Cover letter sample
Dear Hiring Manager,
I am excited to apply for the Power BI Architect position at Tiger Analytics. With over 10 years of experience in business intelligence and a strong focus on Power BI architecture, I have successfully designed and governed enterprise-scale BI solutions. My expertise in Azure ecosystem, semantic modeling, and CI/CD pipelines aligns perfectly with your requirements.
In my previous role, I led the migration of legacy BI systems to Power BI Premium, resulting in a 30% improvement in report performance. I have also established governance frameworks and mentored teams on best practices. I am eager to bring my skills to Tiger Analytics and contribute to your mission of delivering data-driven value.
Thank you for considering my application. I look forward to discussing how I can help drive your BI strategy.
Sincerely,
[Your Name]
Sample interview questions
I would start by defining workspace roles, data access policies, and certification processes. Use Power BI admin portal for monitoring, implement row-level security, and establish a central metric store. Also, enforce naming conventions and version control via Azure DevOps.
I would analyze the data model for star schema design, reduce cardinality, use aggregations, and optimize DAX queries. Also, implement incremental refresh and consider using Power BI Premium capacity for larger datasets.
I have used Azure DevOps with Git for source control, deployment pipelines for promoting content across dev/test/prod, and automated deployment using PowerShell or REST APIs. I also set up branching strategies and release gates.
I implement row-level security (RLS) and object-level security (OLS) as needed, use Azure Active Directory for authentication, and apply data classification labels. I also ensure compliance with GDPR or HIPAA by restricting data access and auditing usage.
I designed a model for a retail company with sales, inventory, and customer data. I used a star schema with fact tables for transactions and dimensions for product, time, store, and customer. I created measures for KPIs like same-store sales and used calculated tables for time intelligence. The model supported drill-through and cross-filtering across multiple fact tables.
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.
Annual salary information is not provided for this position. Explore salary ranges for similar roles in our Salary Directory ›
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
