I am a data architect with 25+ years of experience designing scalable data platforms, cloud data warehouses, and enterprise analytics solutions across banking, insurance, SaaS, and government sectors. I am an enterprise-level Power BI architect with 10+ years delivering scalable analytics, semantic modelling, DAX optimization, and strong governance. As a senior data & analytics consultant, I lead BI transformations that align data with strategic business objectives, turning fragmented ecosystems into governed, high-performance architectures. I am a collaborative leader and mentor, skilled in stakeholder engagement, cross-functional leadership, business analysis, requirements and metrics definition, and end-to-end project delivery, with a focus on data governance, lineage, quality frameworks, and security.

Raghuram Iyer (Ram)

I am a data architect with 25+ years of experience designing scalable data platforms, cloud data warehouses, and enterprise analytics solutions across banking, insurance, SaaS, and government sectors. I am an enterprise-level Power BI architect with 10+ years delivering scalable analytics, semantic modelling, DAX optimization, and strong governance. As a senior data & analytics consultant, I lead BI transformations that align data with strategic business objectives, turning fragmented ecosystems into governed, high-performance architectures. I am a collaborative leader and mentor, skilled in stakeholder engagement, cross-functional leadership, business analysis, requirements and metrics definition, and end-to-end project delivery, with a focus on data governance, lineage, quality frameworks, and security.

Available to hire

I am a data architect with 25+ years of experience designing scalable data platforms, cloud data warehouses, and enterprise analytics solutions across banking, insurance, SaaS, and government sectors. I am an enterprise-level Power BI architect with 10+ years delivering scalable analytics, semantic modelling, DAX optimization, and strong governance. As a senior data & analytics consultant, I lead BI transformations that align data with strategic business objectives, turning fragmented ecosystems into governed, high-performance architectures. I am a collaborative leader and mentor, skilled in stakeholder engagement, cross-functional leadership, business analysis, requirements and metrics definition, and end-to-end project delivery, with a focus on data governance, lineage, quality frameworks, and security.

See more

Work Experience

Principal Engineer at Clearpoint
September 1, 2025 - Present
Led the joint client and Clearpoint development team in stakeholder workshops and requirements analysis; architected and developed robust data & analytics solutions using a Medallion-style ETL approach with FiveTran, DBT, and Snowpipes; built a gold layer and a Kimball-style star schema; designed and delivered an extensive Power BI analytics suite and managed admin consoles for Power BI, Azure, FiveTran, and Snowflake; provided governance guidance and security architecture.
Sr. Data Analytics Consultant at Tower Insurance
July 1, 2024 - October 31, 2024
Led stakeholder workshops and business requirements analysis; developed Snowflake models (Kimball) and defined analytic metrics; migrated Auto Claims data and rebuilt a comprehensive Power BI dashboards and reporting suite for claims data.
Principal Architect & Data Analytics Practice Lead at TMNZ
September 1, 2020 - March 31, 2024
Defined data architecture, governance and enterprise reporting strategy; Architected the enterprise data warehouse, data lake and analytics platform; Delivered Power BI reporting; mentored analysts and engineers; introduced data governance models, metadata & master data management; created reusable templates and modular report design patterns.
Sr. Systems & Data Analyst at ASB Bank
June 1, 2019 - August 31, 2020
Designed the Finance BI Data Mart; developed ETL pipelines; performed data lineage analysis and semantic modeling; defined business metrics.
Data Warehouse Manager at Datacom Ltd
December 1, 2018 - May 31, 2019
Architected the Finance DW post-enterprise system migration; modeled semantic layer for Power BI reporting; led ETL design, Synapse pipelines and Power BI reporting architecture.
Sr. Power BI Consultant at Bank of New Zealand
August 1, 2018 - November 30, 2018
Led CFO-level reporting packs using SSAS Tabular and Power BI; designed security layers and complex DAX measures; introduced reusable templates and modular report design patterns.
Sr. BI Consultant at Datacom Ltd
September 1, 2014 - April 30, 2015
Led BI/DW design engagements; defined data pipelines and Power BI reporting architecture; aligned BI with business rules and governance.
DW Designer at Competenz Ltd.
May 1, 2015 - July 31, 2016
Designed data warehouse architecture; implemented reporting templates; supported Cognos and Power BI.
Sr. Technical Analyst at Partners Life Ltd.
August 1, 2016 - November 30, 2017
Drove data integration and BI/analytics initiatives; defined transformation rules and governance.
Sr. DW Consultant at Debit Success
January 1, 2018 - May 31, 2018
Azure Data Warehouse, ADF, SSIS, Power BI; built ETL pipelines and data marts; optimized performance.
Reporting Analyst at Air New Zealand
May 1, 2012 - November 30, 2012
Aircraft reliability, PRA reports; Oracle, SSRS, Hyperion, TOAD.
Information Analyst at Lumley Insurance
December 1, 2012 - February 28, 2013
Enterprise DW and information governance in BI reporting.
Information Analyst at Tower Insurance
March 1, 2013 - May 31, 2014
Finance Data Mart and Cognos-based reporting; data modeling and semantic design.
Sr. BI Consultant at Datacom Ltd
September 1, 2014 - April 30, 2015
BI/DW design, transformation pipelines, and Power BI reporting architecture.
BI Manager at Ponsonby Online
January 1, 2007 - April 30, 2012
Ecommerce DW and analytics leadership; DW/BI architecture and reporting.
Various Roles in DW/BI, Cognos, Business Analysis at Express Couriers, Cap Gemini NZ, Warehouse Stationery, McCain Foods, AAA Travel, NAV Global HK, Kale Software, Raymond Woolen Mills
September 1, 1989 - June 30, 2006
Various roles across data warehousing, BI, Cognos, business analysis, data modeling, and project leadership.

Education

MBA (Marketing) at Jamnalal Bajaj Institute of Management Studies, Mumbai
January 11, 2030 - January 17, 2026
MA (Psychology) at PSG College, Coimbatore
January 11, 2030 - January 17, 2026
BA (Economics) at Wilson College, Mumbai
January 11, 2030 - January 17, 2026

Qualifications

MCSD – Microsoft Certified Solution Developer (SQL Server & Windows Architecture)
January 11, 2030 - January 17, 2026
Advanced Power BI Training
January 11, 2030 - January 17, 2026