Architect Jobs

About The Position

Requirements

• 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
• 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)
• 12+ Years of experience

Nice To Haves

• 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.

Responsibilities

• 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.

Benefits

• Flexible work from home options available.