BI Architect

Technology Leadership

• Lead and guide the team independently or with minimal support to design, implement, and deliver complex reporting and BI project assignments.

Technical Portfolio

• Expertise in a range of BI and hosting technologies like the AWS stack, Azure & Snowflake.
• Ability to work on multiple project streams for a client and apply pharma domain knowledge for better business decision-making, especially around Cloud Data Warehouse.
• Responsible for designing and implementing enterprise-grade BI solutions on cloud platforms.
• Understand business requirements in a BI context and design data models to transform raw data into meaningful insights.
• Building Power BI Data Models, reports using charts, slicers, pivots, and custom visuals.
• Create relationships between data and develop tabular and other multidimensional data models.
• Experience in creating business-level datasets for interactive Reports & Dashboards.
• Ability to write complex DAX functions, Power Query, Power Apps.
• Strong in RDBMS/SQL Server and handling complex queries.

Logical Thinking

• Able to think analytically, use a systematic and logical approach to analyze data, problems, and situations. Must be able to guide team members in analysis.

Client Relationship

• Manage client relationships and client expectations independently. Should be able to deliver results back to the Client independently.
• Excellent communication skills.

Project Management (Good to know)

• Get accurate briefs from the Client and translate into tasks for team members with priorities and timeline plans.
• Must maintain high standards of quality and thoroughness. Should be able to monitor accuracy and quality of others' work.
• Ability to think in advance about potential risks and mitigation plans.

Job Requirements

• Rich experience in the Pharmaceutical / Life Sciences Domain.
• Define and drive the BI strategy and roadmap in alignment with business goals.
• Lead the design and architecture of scalable and robust Power BI solutions.
• Provide technical leadership and mentorship to BI developers and analysts.
• Can work across a variety of projects from advanced analytics, ad-hoc analysis, and reporting.
• Strong in logical reasoning, structuring of analysis, asking the right questions, and a logical approach to analyze data, problems, and situations.
• Proficiency in Power BI, including Power Query, Power Pivot, and DAX.
• Strong understanding of data modeling, data warehousing concepts, and relational databases (e.g., SQL Server, Oracle).
• Experience with ETL processes and tools.
• Knowledge of data visualization best practices.
• Experience with custom visuals and DAX formulas.
• Familiarity with other BI tools (e.g., Tableau, QlikView) is advantageous.
• Strong analytical and problem-solving skills.
• Ability to analyze complex datasets to identify trends, patterns, and insights.
• Ability to develop and implement key performance indicators (KPIs) and metrics.
• Excellent verbal and written communication skills.
• Ability to translate complex data findings into actionable insights for non-technical stakeholders.
• Experience in training and supporting end-users on Power BI functionalities.

Qualification

• BE/ B. Tech/ /M Tech/MBA

Skills (Must Have)

• 11-15 years of experience in Designing, Developing, and publishing Power BI reports.
• 3+ years of Pharma domain experience in Commercial or Clinical or Patient functional areas.
• Strong experience (or knowledge) of Power BI CoPilot or Gen AI / OpenAI/Claude etc.
• Extensive Experience in building Power BI Data Models, reports using charts, slicers, pivots, and custom visuals.
• Hands-on experience of Design, Development of visualizations (Charts, Plots, themes etc.), Adhoc reporting.
• Strong knowledge of SQL and ability to write DAX queries and do customization as per requirement.
• Extensive self-service BI roll-out and end-user training experience.
• Experience of Designing, Developing Report data model, ETL data Processes in preparation of Dashboards.
• Strong expertise in reports performance optimization through reporting platform settings and underlying data layer optimization.
• Good knowledge and expertise in PBI Admin features and capabilities.
• Experience in creation of technical documentation.
• Knowledge of Cloud technologies is a must-have.
• Experience / Strong knowledge of CoPilot, AI/ML, Narrative features of PBI.
• Excellent written, presentation, and verbal communication skills.

Skills that Give You an Edge

• Good to have work experience in other BI tools such as Tableau, MicroStrategy, QlikView etc.

Skills Required
bi architecture , Power Bi, Dax, Data Visualisation, Sql, Azure