BI Architect

3 - 8 years

3 - 8 Lacs

Posted:8 hours ago| Platform: Foundit logo

Apply

Skills Required

Work Mode

On-site

Job Type

Full Time

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Axtria logo
Axtria

Software Development

Berkeley Heights NJ

RecommendedJobs for You

bengaluru, karnataka, india

bengaluru, karnataka

pune, maharashtra, india

bengaluru, karnataka

Gurugram, Haryana, India