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.