Source description
About the role
Role Overview: As a Power BI Architect at Mizuho, you will be responsible for designing, governing, and delivering enterprise-scale analytics solutions. Your role will involve leading Power BI architecture and semantic modeling, with a focus on deep integration into the Snowflake data platform. You will collaborate closely with Finance IT, IT Data, and Finance business stakeholders to ensure the delivery of governed, high-performance analytics across various platforms such as Snowflake, OneStream, SAP, Databricks, and SQL Server. Key Responsibilities: - Architect and lead end-to-end Power BI solutions, including datasets, semantic models, dashboards, and reports - Design scalable and reusable Power BI semantic layers aligned with enterprise data standards - Establish and enforce Power BI best practices for data modeling, DAX, performance tuning, and security - Own Power BI tenant governance, including workspace strategy, deployment pipelines, and capacity management - Support self-service BI while maintaining enterprise-grade governance and data integrity Snowflake Data Platform Integration: - Architect Power BISnowflake integrations using DirectQuery, Import, and hybrid models - Partner with data engineering teams to design analytics-optimized Snowflake data models (star/snowflake schemas) - Optimize Power BI query performance leveraging Snowflake SQL, virtual warehouses, and cost-management strategies - Ensure secure access patterns using RBAC, views, masking, and row-level security between Snowflake and Power BI - Guide data ingestion and transformation patterns supporting analytics use cases Enterprise System Integrations: - Design and support integration with OneStream (financial consolidation, planning, and reporting), SAP (S/4HANA), and Databricks - Translate complex financial and operational data structures into analytics-friendly models - Ensure consistent metric definitions between source systems and Power BI semantic models Data Governance & Security: - Implement row-level and object-level security across Power BI datasets - Align BI solutions with enterprise data governance, audit, and compliance requirements - Define certification and promotion standards for datasets and reports - Partner with risk, finance, and compliance teams as needed Leadership & Collaboration: - Act as a technical lead and mentor for Power BI developers and analysts - Collaborate with data architects, Snowflake engineers, finance teams, and business stakeholders - Provide architectural guidance during project planning, estimation, and delivery - Communicate complex technical concepts clearly to both technical and non-technical audiences Organization Overview: Mizuho Global Services (MGS), Pune, is an integral part of Mizuho Financial Group, supporting Mizuho's international businesses by delivering high-quality, scalable, and resilient services. MGS Pune plays a critical role in driving operational excellence, standardization, and innovation for Mizuho Americas, partnering closely with regional and global teams to support corporate and investment banking, capital markets, and corporate services. Role Overview: As a Power BI Architect at Mizuho, you will be responsible for designing, governing, and delivering enterprise-scale analytics solutions. Your role will involve leading Power BI architecture and semantic modeling, with a focus on deep integration into the Snowflake data platform. You will collaborate closely with Finance IT, IT Data, and Finance business stakeholders to ensure the delivery of governed, high-performance analytics across various platforms such as Snowflake, OneStream, SAP, Databricks, and SQL Server. Key Responsibilities: - Architect and lead end-to-end Power BI solutions, including datasets, semantic models, dashboards, and reports - Design scalable and reusable Power BI semantic layers aligned with enterprise data standards - Establish and enforce Power BI best practices for data modeling, DAX, performance tuning, and security - Own Power BI tenant governance, including workspace strategy, deployment pipelines, and capacity management - Support self-service BI while maintaining enterprise-grade governance and data integrity Snowflake Data Platform Integration: - Architect Power BISnowflake integrations using DirectQuery, Import, and hybrid models - Partner with data engineering teams to design analytics-optimized Snowflake data models (star/snowflake schemas) - Optimize Power BI query performance leveraging Snowflake SQL, virtual warehouses, and cost-management strategies - Ensure secure access patterns using RBAC, views, masking, and row-level security between Snowflake and Power BI - Guide data ingestion and transformation patterns supporting analytics use cases Enterprise System Integrations: - Design and support integration with OneStream (financial consolidation, planning, and reporting), SAP (S/4HANA), and Databricks - Translate complex financial and operational data structures into
More at Mizuho
Related open roles
Toc Mssql Dba Operations Engineer
India
Master And Reference Data Customer Master Specialist Pune
Mumbai
SQL Database Administrator (can be remote)
Mumbai
TOC Enterprise Storage Operations Engineer (Analyst/Associate/AVP)
Mumbai
Data Integration Support engineer -Databricks, Python, SQL Server in Investment
Mumbai
IT Server Infrastructure, Servicenow
Mumbai