Associate Consultant - Data Warehouse (299)

Ovii's Interpretation of the Role

The Associate Consultant will design and implement data‑warehouse solutions for life‑science clients, translate business needs into technical designs, and lead project delivery while mentoring internal teams. The role blends data‑engineering expertise with client‑facing consulting in a hybrid Pune setting.

Role Snapshot

• Design & build data warehouse architectures
• Optimize ETL pipelines and database performance
• Translate business requirements into technical specs
• Lead project timelines, budgets, and stakeholder communication
• Provide training, mentorship, and client support

Must-Have Requirements

• Data modeling
• ETL process design
• SQL
• Python
• R
• Tableau
• PowerBI
• Project management
• People management
• Verbal and written communication
• consulting‑industry experience
• data warehousing
• Engineering/Master’s Degree in Computer Science or related concentration

Nice-to-Have Signals

• Awareness of cloud platform services
• cloud platform services awareness

Work Setup

• Location: Pune, India
• Work mode: HYBRID
• Remote scope: UNSPECIFIED
• Timezone: US working hours overlap (3‑4 hrs)
• Employment type: Full-Time

Eligibility Gates

• Visa sponsorship: unknown

Not Specified in JD

• Salary range
• Visa sponsorship
• Remote eligibility
• Travel requirements
• Security clearance

What You'll Likely Work On

• Create end‑to‑end data‑warehouse designs that meet client business goals
• Develop and fine‑tune ETL processes to improve system efficiency
• Collaborate with project leadership to define scope, timelines, and risk mitigation
• Communicate findings, recommendations, and technical concepts to clients and internal teams
• Manage project delivery, including budgets, schedules, and stakeholder updates
• Mentor junior staff, deliver training, and support employee engagement initiatives
• Support US‑based clients with a 3‑4 hour overlap in US working hours

Good Fit If You Have

• Experience with life‑science or pharmaceutical data sets
• Familiarity with cloud platform services and emerging data‑tech
• Ability to thrive in an international matrix environment
• Strong academic background in Computer Science or related field