Job Description
Ovii's Interpretation of the Role
We are seeking a senior consultant to design, build, and optimize data warehouse solutions for life‑sciences clients. You will translate business needs into technical architecture, lead ETL and reporting implementations, and mentor teams while managing project delivery in a hybrid Bangalore setting.
Role Snapshot
- Design and implement data warehouse architectures
- Lead ETL optimization and database performance tuning
- Translate business requirements into technical solutions
- Manage project timelines, budgets, and stakeholder communication
- Mentor and train internal teams on data practices
- Drive client engagement and risk management
Must-Have Requirements
- Data modeling & management best practices
- ETL design & optimization
- SQL, Python, R
- Tableau, PowerBI
- U.S. pharmaceutical dataset expertise
- Project management
- People management
- Verbal and written communication
- Cloud platform awareness
- consulting industry experience
- data management and analytics
- U.S. pharmaceutical dataset knowledge
- Engineering/Master’s Degree in Computer Science or related field
Work Setup
- Location: Bangalore, India
- Work mode: HYBRID
- Remote scope: UNSPECIFIED
- Timezone: US working hours overlap 3-4 hours
- Employment type: Full-Time
Not Specified in JD
- Salary range
- Visa sponsorship
- Remote eligibility
- Travel requirement
What You'll Likely Work On
- Convert client business needs into scalable data warehouse designs and reporting solutions
- Evaluate and improve ETL pipelines and database performance for efficiency
- Define project scope, develop hypotheses, and deliver actionable recommendations to clients
- Lead project teams, manage timelines, budgets, and risks while ensuring clear stakeholder communication
- Provide training, mentorship, and ongoing education to internal teams on data practices
- Collaborate with leadership on process‑improvement and innovation initiatives
Good Fit If You Have
- Passion for applying analytics to life‑sciences commercialization
- Interest in emerging cloud and AI technologies
- Experience working in international matrix environments
Skills
- Data modeling & management best practices
- ETL design & optimization
- SQL, Python, R
- Tableau & PowerBI
- U.S. pharmaceutical dataset expertise
- Project & people management
- Strong verbal & written communication
- Cloud platform awareness