Perceptive Logo

Perceptive

Senior Data & Analytics Analyst (PowerBI)

Posted 3 Days Ago
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

An Hour Ago
Easy Apply
In-Office or Remote
Easy Apply
Senior level
Senior level
Cloud • Information Technology • Security • Software
Own the authentication product strategy and roadmap, translating customer, competitor, and market insights into priorities. Partner with UX, architecture, engineering, security, and go-to-market teams to simplify authentication experiences and deliver measurable outcomes. The role requires deep expertise in identity and authentication technologies including Kerberos, MFA, FIDO, passwordless authentication, Zero Trust, and certificate-based authentication, along with fluency in AI tools and strong cross-functional leadership.
Top Skills: Ai ToolsAuthenticationCertificate-Based AuthenticationConditional AccessFidoIdentity And Access ManagementKerberosLdapMfaPasswordless AuthenticationRadiusSaaSSsoZero Trust
5 Hours Ago
Remote
2 Locations
Junior
Junior
Events • Food • Travel • Hospitality • Hotels & Resorts
Prepares and cooks menu items under senior chef supervision, manages guest orders, executes recipes, oversees station quality and inventory, inspects plates, maintains sanitation and food safety standards, and requisitions supplies. The role requires at least one year of cooking experience in a high-standard hotel or restaurant, basic Western or Chinese cuisine knowledge, teamwork, communication, and the ability to work calmly in a demanding kitchen environment.
5 Hours Ago
Remote
India
Mid level
Mid level
Events • Food • Travel • Hospitality • Hotels & Resorts
Manages corporate and group hotel sales, develops new business, oversees the full sales cycle, negotiates contracts, drives room and event revenue, analyzes sales performance, coordinates service delivery, and coaches sales team members.
Top Skills: DelphiMarket Planner SurveyOnqSalesforce

What you need to know about the Kolkata Tech Scene

When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account