Ubique Systems

TRCD-26-06971

Decision Analytics Associate (DAA)

The Decision Analytics Associate will write and maintain SQL queries, QC recurring KPI outputs, reconcile figures to source data, and maintain Excel workbooks and PowerPoint deliverables. The work supports analytics using patient-level programme data, with pharma patient services and launch analytics as relevant context rather than mandatory prior experience. Strong day-to-day SQL, advanced Excel, practical data analysis, and clear communication are must-haves; PowerPoint comfort and availability for US-overlap hours are also specified. Pharma patient services data, Snowflake, Salesforce CRM, and PSP or launch analytics exposure are beneficial. The structured input gives 1–2 years of experience, Bengaluru, and contract employment; work mode is not specified, while the description notes US-overlap hours may be needed.

Position summary

Location
India
Workplace
Hybrid
Employment
Contract
Experience
Minimum 1 years and Maximum 2 years
Apply now

Role overview

Why This Role Matters.

The Decision Analytics Associate will write and maintain SQL queries, QC recurring KPI outputs, reconcile figures to source data, and maintain Excel workbooks and PowerPoint deliverables. The work supports analytics using patient-level programme data, with pharma patient services and launch analytics as relevant context rather than mandatory prior experience. Strong day-to-day SQL, advanced Excel, practical data analysis, and clear communication are must-haves; PowerPoint comfort and availability for US-overlap hours are also specified. Pharma patient services data, Snowflake, Salesforce CRM, and PSP or launch analytics exposure are beneficial. The structured input gives 1–2 years of experience, Bengaluru, and contract employment; work mode is not specified, while the description notes US-overlap hours may be needed.

Your Impact

Deliver Enterprise Value

Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.

Collaboration

Work Across Teams

Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.

Growth

Learn Continuously

Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.

Career Path

Grow With Ubique

Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.

Responsibilities

What You'll Be Doing.

Every role at Ubique contributes directly to solving meaningful business challenges for our clients.

01

Write and maintain SQL against patient-level datasets (Snowflake or similar): enrollments, consents, prior authorizations, dispenses, payer and programme data.

02

Build and QC weekly KPI outputs; reconcile derived figures against source systems and client-provided extracts; document the derivation rules.

03

Investigate data quality issues (duplicates, missing links between sources, reload artefacts), explain them clearly and propose fixes.

04

Work directly with the engagement team, onshore and client analytics counterparts; summarise findings in clear written notes.

05

Strong SQL (joins, window functions, de-duplication logic) — day-to-day use.

06

Advanced MS Excel (lookups, structured formulas, large workbooks) Comfortable with PowerPoint.

07

Clear written and verbal communication; comfortable working US-overlap hours when needed.

08

Exposure to patient services / PSP reporting or launch analytics (enrollment funnels, prior authorization, time-to-therapy, adherence metrics).

09

Familiarity with Snowflake and Salesforce-based CRM data models.

Technology stack

Tools & Technologies.

The platforms and technologies you'll use to build modern, enterprise-grade solutions.

01

SQL

02

Snowflake

03

RDBMS

04

relational databases

05

Microsoft Excel

06

MS Excel

07

VLOOKUP

08

XLOOKUP

09

INDEX MATCH

10

structured formulas

11

large workbooks

12

Microsoft PowerPoint

13

window functions

14

SQL joins

15

de-duplication

16

data profiling

17

data reconciliation

18

KPI reporting

19

patient-level data

20

claims data

Requirements

Skills & Experience.

We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.

Essential

Required Qualifications

Strong day-to-day SQL, including joins, window functions, and de-duplication logic

Advanced MS Excel, including lookups, structured formulas, and large workbooks

Comfort with PowerPoint

Hands-on data analysis, including profiling, number reconciliation, and explaining discrepancies

Clear written and verbal communication

Ability to work US-overlap hours when needed

Preferred

Nice to Have

Pharma patient-level data, including claims, specialty pharmacy, patient support programme or hub, copay, or patient assistance data

Patient services or PSP reporting and launch analytics

Enrollment funnel, prior authorization, time-to-therapy, or adherence metrics

Snowflake

Salesforce-based CRM data models

What you'll gain

More Than Just A Job.

We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.

Global Exposure

Collaborate with international clients and multicultural teams on enterprise programmes.

Continuous Learning

Expand your expertise through mentoring, certifications and hands-on project experience.

Career Growth

Take ownership, develop leadership skills and grow your consulting career over time.

Flexible Working

Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.

People First

Join a supportive culture where collaboration, respect and long-term relationships come first.

Enterprise Projects

Work on meaningful technology initiatives for leading organisations across industries.

Apply

Apply for Decision Analytics Associate (DAA)

One page, about two minutes. We only ask for what we actually need to have a first conversation.

Your CV

Optional. A line or two is plenty.