BI Architect R0(BFSI)
Share
Job Location:
Monthly Salary:
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
BI Architect
Exp- 10
Primary Skills
- MSBI (SSIS SSAS SSRS) SQL Advanced Excel Power BI Power App Azure Analysis Services Synapse Data Factory Databricks
Specialization
- Power BI Architecture: BI Architect
Job requirements
- Experience:
- 912 Years Cloud Exposure: Azure (Preferred)
- Additional BI Exposure: Qlik / Tableau / Looker (Good to Have)
- Role Summary
- We are seeking a seasoned Power BI Architect to lead the design and implementation of enterprise-grade Business Intelligence solutions.
- This role requires deep expertise in Power BI architecture data modeling performance engineering governance and secure deployment within large-scale data warehouse ecosystems.
- The ideal candidate will combine strong technical depth with architectural thinking stakeholder engagement capability and experience operating within regulated enterprise environments.
- Key Responsibilities
- Architecture & Design Define and implement scalable Power BI architecture across Development UAT and Production environments.
- Design robust semantic models aligned with enterprise data warehouse standards.
- Establish best practices for data modeling naming conventions workspace governance and deployment pipelines.
- Provide high-level design and effort estimation for BI initiatives.
- Data Modeling & Engineering Develop advanced DAX measures and optimized calculated columns.
- Build complex transformations using Power Query (M language).
- Design and implement Power BI Dataflows for centralized transformation logic.
- Optimize query performance through aggregation strategies incremental refresh and query folding.
- Integration & Deployment Manage report migration across environments using deployment pipelines.
- Configure and maintain On-Premises Data Gateways.
- Implement and manage Power BI Embedded solutions where applicable.
- Integrate BI systems with enterprise data sources including OLAP cubes SQL Server and cloud data platforms.
- Security & Governance Architect and implement Row-Level Security (RLS) and role-based access controls.
- Define enterprise-wide security frameworks aligned with Azure AD. Ensure compliance with data governance audit and regulatory standards. Performance & Optimization Conduct performance diagnostics for dashboards and datasets. Optimize SQL queries and backend data models for large-volume datasets.
- Implement scalable solutions for high concurrency and enterprise adoption.
- Stakeholder Engagement Collaborate with business stakeholders to translate analytical requirements into scalable BI solutions.
- Provide technical leadership and mentoring to BI developers. Identify automation opportunities to improve reporting efficiency and operational performance.
- Required Technical Expertise Power BI (Core Requirement) Power BI Service (Workspaces Deployment Pipelines Admin capabilities)
- Advanced DAX and data modeling principles Power Query (M language) Dataflows (Service-based transformations) Performance tuning and dataset optimization RLS and enterprise security implementation Gateway configuration and management
- Power BI Embedded architecture (preferred) Data & Database Expertise
- Strong SQL with complex joins indexing and performance tuning
- Experience with SSRS and SSIS In-depth knowledge of OLAP concepts
- Solid understanding of ETL/ELT frameworks Data warehousing design (Star/Snowflake schemas) Azure (Preferred) Azure Data Factory Azure Synapse Analytics Azure SQL Database Azure Data Lake Storage Azure Active Directory integration
- Other BI Tools (Good to Have) QlikView / Qlik Sense Tableau GCP Looker
- Familiarity with GCP analytics ecosystem Preferred Background Experience within Financial Services Banking or Asset Management environments. Exposure to regulatory reporting and secured data environments.
- Experience leading BI teams or architecting enterprise BI programs. Strong communication skills with the ability to engage both technical and business stakeholders.
We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.
Required Experience:
Staff IC
Key Skills
- Accounts Receivable
- Brand Management
- Apache Web Server
- High School
- HSSE
About Company
Brillio is a global leader in Enterprise Digital Transformation Solutions, providing strategic consulting services and solutions using emerging technologies.
