> Markdown version of [/jobs/ext/1216244-power-bi-architect-pharma-domain-w2](https://www.wearedevelopers.com/jobs/ext/1216244-power-bi-architect-pharma-domain-w2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Power BI Architect - Pharma domain- W2 - **Company:** CLOUDSCOUTS SOFTWARE SOLUTIONS LLC - **Location:** New York, NY, United States (Remote available) - **Salary:** $156,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Business Analytics Applications, Data Analysis, Microsoft Azure, Business Intelligence Development, Cloud Computing, Code Review, Continuous Integration, Information Engineering, Data Warehousing, Dimensional Modeling, IT Management, Power BI, Cloud Services, Salesforce.Com, Delivery Pipeline, Snowflake, Generative AI, Git, Powerquery, Information Technology, Data Analytics, Azure Synapse Analytics, Amazon Redshift, Databricks - **Published:** July 9, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=de37c16d0b1d6f5c ## About the Role We are seeking an experienced Power BI Architect with strong pharmaceutical domain expertise to lead the design, development, and modernization of enterprise analytics solutions. The ideal candidate should have extensive experience in Power BI, data warehousing, cloud platforms, and pharmaceutical commercial, patient, and market access analytics., * Expert in Power BI Architecture, DAX, Power Query, Data Modeling * Experience with Tabular Models and Semantic Layer design * Strong SQL expertise * Experience with Snowflake, Azure Synapse, Databricks, Redshift, or similar platforms * Knowledge of Power BI Service Administration and Governance * Experience with CI/CD, Deployment Pipelines, Git Integration * Understanding of Data Warehousing concepts and dimensional modeling * Experience integrating AI capabilities such as Power BI Copilot, Fabric AI, or Generative AI solutions is highly desirable, * Bachelor's or Master's degree in engineering, Computer Science, Data Analytics, or related field. * Microsoft Power BI Certification preferred. * Experience in Pharmaceutical or Life Sciences organizations such as Commercial, Patient Services, Medical Affairs, or Market Access functions. * Exposure to AI/ML, Fabric, Copilot, or Conversational Analytics platforms is a strong advantage. ## Description * Design and architect scalable Power BI solutions for enterprise-wide reporting and analytics. * Collaborate with business stakeholders, commercial teams, patient services teams, and IT leadership to translate business requirements into analytics solutions. * Lead dashboard and semantic model design, ensuring performance, scalability, governance, and security. * Define BI architecture, data models, KPI frameworks, and reporting standards across multiple business functions. * Drive migration and modernization initiatives from legacy BI platforms to Power BI. * Work closely with Data Engineering teams on Snowflake, Azure, AWS, Databricks, or similar cloud data platforms. * Implement Row-Level Security (RLS), governance frameworks, deployment pipelines, and enterprise reporting standards. * Provide technical leadership, code reviews, mentoring, and best practices to BI development teams. * Present analytics solutions and business insights to senior leadership and business stakeholders., * Act as a trusted advisor to business and technology stakeholders. * Lead requirement workshops, solution discussions, and architecture reviews. * Recommend innovative BI and AI-driven solutions to improve business decision-making. * Drive executive-level conversations around KPI definitions, reporting strategy, and analytics roadmap. * Support presales activities including solution estimation, architecture proposals, and client presentations. * Manage stakeholder expectations and provide regular updates on delivery progress and risks. Pharma Domain Experience Required Strong understanding of one or more of the following areas: * Commercial Analytics (Sales, Market Share, Territory Performance) * Patient Analytics & Patient Support Programs (PSP) * Market Access & Specialty Pharmacy Analytics * HCP Engagement & Omnichannel Analytics * Speaker Programs and Event Analytics * CRM Analytics (Veeva CRM preferred) * Field Force Effectiveness * Brand Performance Analytics * Patient Journey Analytics * Market Research & Real-World Data (RWD) ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Best Companies to Work For in Berlin: Top 14 Companies in 2023 ](https://www.wearedevelopers.com/magazine/188-best-companies-to-work-for-in-berlin-top-14-companies-in-2023)