Power BI Solution Architect

Role Summary

We are looking for an accomplished PowerBi Solution architect to architect and drive scalable, insight-rich analytics solutions across the enterprise. This role sits at the intersection of data engineering, business intelligence, and solution architecture—ideal for a candidate with mastery of modern visualization tools, modeling strategies, and end-to-end data integration.

️ 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