Power BI Solution Architect

Role Summary : We are looking for an accomplished Power BI 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. 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 : - 8+ 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 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 Factory.