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
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.
Build and QC weekly KPI outputs; reconcile derived figures against source systems and client-provided extracts; document the derivation rules.
Investigate data quality issues (duplicates, missing links between sources, reload artefacts), explain them clearly and propose fixes.
Work directly with the engagement team, onshore and client analytics counterparts; summarise findings in clear written notes.
Strong SQL (joins, window functions, de-duplication logic) — day-to-day use.
Advanced MS Excel (lookups, structured formulas, large workbooks) Comfortable with PowerPoint.
Clear written and verbal communication; comfortable working US-overlap hours when needed.
Exposure to patient services / PSP reporting or launch analytics (enrollment funnels, prior authorization, time-to-therapy, adherence metrics).
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.
SQL
Snowflake
RDBMS
relational databases
Microsoft Excel
MS Excel
VLOOKUP
XLOOKUP
INDEX MATCH
structured formulas
large workbooks
Microsoft PowerPoint
window functions
SQL joins
de-duplication
data profiling
data reconciliation
KPI reporting
patient-level data
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.