BI Architect

Job Description

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.

---