Perceptive Logo

Perceptive

Senior Data & Analytics Analyst (PowerBI)

Posted 2 Hours Ago
Be an Early Applicant
Remote
Hiring Remotely in India
Senior level
Remote
Hiring Remotely in India
Senior level
Develops and maintains Power BI dashboards, data models, reporting pipelines, and semantic models using SQL, Power Query, and DAX. Integrates and governs operational data, troubleshoots refresh and connectivity issues, optimizes reporting performance, and ensures data quality. Works with stakeholders to define requirements, analyze trends and KPIs, and deliver clear recommendations, demonstrations, and training. Supports scalable, automated reporting solutions in regulated life sciences environments.
The summary above was generated by AI

About Perceptive

We’re on a mission to change the future of
clinical research. At Perceptive, we help the
biopharmaceutical industry bring medical
treatments to the market, faster.
Our mission is to change the world
but to do this, we need people like you.

Apart from job satisfaction, we can offer you:

HEALTH:

- Medical plan for you and your dependents.

- Personal Accident Insurance

- Life Insurance

- Critical illness cover

WEALTH:

- Salary structure and Flexi basket

- Provident fund of 12%

- Gratuity scheme

YOURSELF: Internal growth and development programs & trainings

The Senior Data & Analytics Analyst is responsible for connecting and integrating operational data to provide accurate, automated and actionable business reporting and insight. The role develops robust data models and reporting pipelines, ensures the quality and integrity of reporting data, and uses Power BI to analyze operational performance, identify trends, risks and opportunities, and translate findings into clear business recommendations. Working closely with stakeholders, the role turns operational requirements into scalable reporting and analytical solutions that support informed strategic and operational decision-making.

Key Responsibilities


Automate and maintain reporting solutions

  • Design, develop and maintain Power BI dashboards and reports using appropriate data modelling, Power Query and DAX techniques.
  • Ensure timely delivery of reports and dashboards while maintaining data quality.
  • Design clear, user-friendly visualisations aligned with business requirements and agreed reporting standards.
  • Maintain report documentation, version control, and release notes for dashboard changes.
  • Create end user demos and training to support roll out

Datasets and Data Pipeline Maintenance

  • Connect, integrate and maintain operational datasets and data pipelines used for reporting and analysis.
  • Connect Power BI to multiple data sources and transform raw data into actionable insights, using SQL to extract, query, join and manipulate data from operational data sources.
  • Perform data cleaning, transformation, and integration using Power Query.
  • Build and maintain scalable data pipelines and semantic models within Microsoft Fabric.
  • Apply data governance, access controls, naming conventions, and refresh schedules across shared datasets to prepare data for analysis and reporting.
  • Optimization
  • Review data models, DAX measures, visuals, and queries to identify performance bottlenecks.
  • Optimise data models, queries and reporting solutions for performance, scalability and efficient use of large datasets.
  • Reduce unnecessary data volume and improve model efficiency through appropriate design and aggregation.
  • Identify opportunities to simplify and automate manual data extraction, preparation and reporting processes, improving efficiency, consistency and scalability.
  • Troubleshooting
  • Troubleshoot reporting, refresh, connectivity and data pipeline issues and implement appropriate preventive controls.
  • Investigate root causes of failed refreshes, inaccurate outputs, and data connectivity issues.
  • Resolve incidents promptly and communicate impact, progress, and resolution to relevant stakeholders.
  • Put preventive checks and monitoring in place to reduce repeat issues.
  •  Stakeholder management and reporting requirements
  • Gather, clarify, and document reporting requirements, measures, definitions, and acceptance criteria.
  • Translate business needs into practical data models, reports, and dashboard solutions.
  • Provide demonstrations, guidance, and support to encourage effective use of reporting products.
  • Report analysis and interpretation
  • Analyse and interpret reporting outputs to identify trends, exceptions and areas requiring stakeholder attention, providing data-led observations to support business decision-making.
  • Analyse trends, exceptions, and KPIs to identify risks and opportunities.
  • Present clear, evidence-based recommendations tailored to stakeholder needs.
  • Support the creation, tracking, and follow-up of agreed action plans and outcomes.

Other

  • Carryout any other reasonable duties as requested.

Functional Competencies (Technical knowledge/Skills)


  • Strong practical SQL skills, including querying, joining, transforming and extracting data from multiple data sources.
  • Strong understanding of data modelling principles and experience developing robust data models for analytical and reporting purposes.
  • Strong understanding of data quality principles, including validation, reconciliation and investigation of data discrepancies.
  • Strong understanding of data protection methods and policies.
  • Strong analytical capability, with experience interpreting complex and large datasets; translating findings into clear business insights and recommendations.
  • Understanding of data warehouse and/or modern data platform concepts.
  • Ability to work effectively with business stakeholders to translate operational questions into data, analytical and reporting requirements.
  • Ability to communicate complex data and analytical findings clearly to technical and non-technical audiences.
  • Strong understanding of working with Business operations data including financials
  • Strong understanding of data modelling and data visualization concepts
  • Knowledge of Data Analysis Expressions (DAX) for creating calculations
  • Proficiency in Microsoft Office Suite
  • Strong interpersonal skills, ability to communicate well at all levels of the organization
  • A flexible attitude with respect to work assignments and new learning.
  • Ability to manage multiple and varied tasks with enthusiasm and prioritize workload with attention to detail.
  • Maintains an up-to-date awareness of trends, tools, technology, techniques and processes that affect testing and technology within the Life sciences domain.

 

Experience, Education, and Certifications


  • Demonstrable experience applying data analysis, modelling and reporting skills to operational business problems.
  • Experience working with large and/or complex operational datasets.
  • Experience developing and maintaining automated data pipelines and data transformation processes.
  • Strong practical experience using Microsoft Power BI, including dashboard/report development, Power Query and DAX.
  • Experience integrating and analysing data from multiple operational systems and sources.
  • Experience with Microsoft Fabric, Azure Data Lake or equivalent modern cloud data platforms, advantageous.
  • Experience using Python or an equivalent analytical/programming methodology for data manipulation, automation or advanced analysis, desirable.
  • Experience using tools to communicate progress to Stakeholders.
  • Experience of regulated environments (GxP, Financial, etc…).
  • Relevant Microsoft Power BI/Data Analyst certification, desirable.
  • Bachelor’s degree in Business, Operations, Life Sciences, Information Systems, Computer Science or a related discipline, or equivalent relevant experience.
  • English: Fluent.

Come as you are.

We're proud to be a Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Similar Jobs

47 Minutes Ago
Remote
India
Entry level
Entry level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Develop and support Pfizer’s generative AI platform, with a focus on building and operating an LLM gateway. The provided description contains no additional responsibilities, qualifications, compensation, travel, or clearance details.
Top Skills: GenaiLarge Language Models (Llms)Llm Gateway
47 Minutes Ago
Remote or Hybrid
India
Expert/Leader
Expert/Leader
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads integrated buy-side and sell-side network strategy for Pfizer’s external CMO and CentreOne supply networks. Develops strategic roadmaps, evaluates network footprint, capacity, capabilities, resilience, sourcing, and exits, and identifies cross-network synergies. Governs network strategy processes, operating models, data tools, and reporting while partnering with procurement, operations, quality, finance, supply chain, business development, and leadership. Uses analytics and AI tools to translate network intelligence into strategic decisions and supports growth initiatives in a global regulated pharmaceutical environment.
Top Skills: Artificial IntelligenceExcelMicrosoft 365Microsoft CopilotNetwork Intelligence ToolsPower BIPowerPoint
4 Hours Ago
Remote or Hybrid
India
Entry level
Entry level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Manage strategic projects from initiation through delivery, defining scope, timelines, deliverables, and success metrics. Track progress, risks, and reporting while facilitating governance meetings and senior leadership updates. Prepare executive presentations and synthesize business performance, project updates, KPIs, and transformation milestones into data-driven narratives. Partner with senior stakeholders across business, finance, operations, risk, technology, analytics, and BI teams, using dashboards and reports to support decision-making.
Top Skills: Power BISap Businessobjects

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account