Perceptive logo

Senior Data & Analytics Analyst (PowerBI)

Hiring from
India
Work type
Remote
Posted

623,336 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

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.

At Perceptive, we enable the world’s pharmaceutical, biotech, and clinical research organizations to rapidly discover and advance life-changing treatments.

Together, our global team delivers unmatched scientific and technological expertise, global operational experience, and end-to-end solutions to help the global research community realize tomorrow’s new therapies. To do this, we need people like you.

Serving Science

At Perceptive, your work will enable our customers to bring lifesaving and life-improving options to patients around the world. Learn how you can make a difference by joining our team and uniting under our shared goal – serving science to improve people’s lives.

Similar jobs

Apply for this job100% free