Pharma Power BI Architect - Enterprise Analytics Lead

Prophecy Technologies; New Jersey; On-site; USD 140,000 - 180,000; Full time

Job summary

Prophecy Technologies seeks an experienced Power BI Architect with pharma domain expertise to lead design, development, and modernization of enterprise analytics. The role focuses on scalable Power BI solutions, governance, and collaboration with IT leadership.

Responsibilities include leading dashboard design, data modeling, and KPI frameworks, while guiding cloud platform integration (Snowflake, Azure, Databricks) and AI-enabled analytics. Strong stakeholder engagement is required.

Qualifications

• Experience designing enterprise Power BI architectures and governance.
• Strong background in data warehousing concepts and dimensional modeling.
• Pharma domain analytics exposure is highly desirable.

Responsibilities

• Design and architect scalable Power BI solutions for enterprise reporting.
• Translate business requirements into analytics solutions with stakeholders.
• Lead dashboard and semantic model design for performance and security.
• Define BI architecture, data models, KPI frameworks, and standards.
• Drive migration from legacy BI to Power BI and modernize analytics.

Skills

Power BI

DAX

Data Modeling

Semantic Layer

Governance

BI Architecture

KPI Frameworks

AI/ML awareness

Stakeholder Communication

Education

Bachelor's or Master’s degree in engineering/CS/data analytics

Tools

Snowflake

Azure Synapse

Databricks

Redshift

Power BI Service Administration

Git & CI/CD

Job description

Prophecy Technologies seeks an experienced Power BI Architect with pharma domain expertise to lead design, development, and modernization of enterprise analytics. The role focuses on scalable Power BI solutions, governance, and collaboration with IT leadership.

Responsibilities include leading dashboard design, data modeling, and KPI frameworks, while guiding cloud platform integration (Snowflake, Azure, Databricks) and AI-enabled analytics. Strong stakeholder engagement is required.