Power BI Solution Architect

Role Summary

PowerBi Solution architect

Key Responsibilities

• Architect and implement scalable

  Power BI solutions

  that span data modeling, integration, visualization, and performance tuning
• Design and lead the development of

  enterprise-grade data models

  using Star, Snowflake, and composite architecture

• Lead the integration of cloud-based

  data warehouse platforms

  including

  Oracle ADW

  and

  Snowflake

• Lead the development of scalable, interactive dashboards using Power BI, driving self-service analytics across business units
• Develop

  ETL and ELT pipelines

  to ingest and transform structured, semi-structured, and API-driven data sources
• Implement automated data ingestion and transformation using

  Python

  and

  shell

  scripting

  for performance and reliability

• Handle and harmonize data from diverse

  API sources

  across applications, platforms, and third-party services
• Deliver

  interactive dashboards

  and storytelling experiences tailored for executives, analysts, and operational teams
• Optimize semantic layers, DAX calculations, and deployment pipelines for reusability and governance
• Mentor BI developers and analysts, setting architectural standards and fostering collaboration across analytics teams
• Collaborate with cross-functional teams to translate strategic business goals into robust analytics solutions

Required Qualifications

• 7+ years in

  Power BI development and analytics Engineering

  , with 3+ years in architecture leadership roles
• Strong command of

  DAX

  ,

  M Query

  , and performance tuning best practices
• Deep experience in

  data modeling

  (Star, Snowflake, composite) and cross-platform architecture
• Hands-on expertise in

  Oracle ADW

  ,

  Snowflake

  , and API-based data ingestion
• Proficiency in

  Python

  ,

  shell scripting

  , and automation of analytics pipelines
• Strong background in

  ETL/ELT

  development, data quality assurance, and deployment orchestration
• Demonstrated success in

  solution architecture

  across cloud ecosystems such as

  Azure

  ,

  Oracle OCI

Preferred Skills

• Experience with Power BI Premium capacity management and deployment pipelines
• Experience with DAX, M language, and performance tuning technique
• Experience integrating

  third-party BI tools

  , data lakehouses, and stream processing services
• Effective communicator capable of translating technical architecture into business value
• Exposure to MS Fabric and Azure Data Factor