Power Bi Architect - Pharma exp is a must

location - Noida, Gurugram, Pune, Hyderabad, Bangalore

Rich experience in the Pharmaceutical / Life Sciences Domain.

Job Title: - Sr Architect-Power BI / Architect-Tableau

Requisition ID:
Job Summary: - We are seeking an experienced Power BI Architect with 8-12 years of experience in business intelligence and data analytics. The ideal candidate will have a deep understanding of Power BI and a proven track record in designing and implementing enterprise-level BI solutions. You will be responsible for leading the BI strategy, ensuring the scalability and performance of the Power BI infrastructure, and guiding the team in best practices and innovative solutions.

Your Responsibilities includes but not limited to:

1. Technology Leadership Lead guide the team independently or with little support to design, implement deliver complex reporting and BI project assignments.

• Technical portfolio Expertise in a range of BI and hosting technologies like the AWS stack, Azure & Snowflake.
• He/she can work on multiple project streams for a client and apply pharma domain knowledge for better business decision making especially around Cloud Data Warehouse.
• Person will be responsible to design and implement enterprise grade BI solutions on cloud platforms.
• Understand business requirements in 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 data sets for interactive Reports & Dashboards
• Ability to write complex DAS functions, Power Query, Power Apps
• Strong in RDBMS/SQL Server and handling complex queries

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

3. Handle Client Relationship Manage client relationship and client expectations independently. Should be able to deliver results back to the Client independently. Should have excellent communication skills.

4. 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 logical approach to analyze data, problems, and situations.
• Proficiency in Power BI, including Power Query, Power Pivot, and DAX.
• Strong understanding of data modelling, 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 analyse 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

Must have Skills: -

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

We will provide– (Employee Value Proposition)

• Offer an inclusive environment that encourages diverse perspectives and ideas
• Delivering challenging and unique opportunities to contribute to the success of a transforming organization
• Opportunity to work on technical challenges that may impact on geographies
• Vast opportunities for self-development: online Axtria Institute, knowledge sharing opportunities globally, learning opportunities through external certifications
• Sponsored Tech Talks & Hackathons
• Possibility of relocating to any Axtria office for short and long-term projects
• Benefit package:

-Health benefits

-Retirement benefits

-Paid time off

-Flexible Benefits

-Hybrid /FT Office/Remote

Axtria is an equal-opportunity employer that values diversity and inclusiveness in the workplace.

Who we are

Axtria 14 years journey

Axtria, Great Place to Work

Life at Axtria

Axtria Diversity