Consultant - Data warehousing-245

Ovii's Interpretation of the Role

The Data Warehousing Consultant will design and implement data warehouse solutions for life‑science clients, translate business needs into technical architecture, and lead project delivery while providing data‑governance best practices and client training.

Role Snapshot

• Design and build data warehouse architectures
• Optimize ETL pipelines and database performance
• Translate business requirements into technical designs
• Lead project teams and manage timelines/budgets
• Provide data‑governance and best‑practice guidance
• Train and mentor internal and client teams

Must-Have Requirements

• Data modeling & governance
• ETL design & optimization
• SQL
• Python or R
• Tableau or PowerBI
• Project management
• People management
• U.S. pharmaceutical dataset knowledge
• consulting experience
• data warehousing
• ETL processes
• Engineering/Master’s Degree in Computer Science or related field

Nice-to-Have Signals

• Cloud platform services awareness
• cloud platform services

Work Setup

• Location: Bangalore, India
• Work mode: HYBRID
• Remote scope: UNSPECIFIED
• Timezone: US working hours overlap 3-4 hours
• Employment type: Full-Time
• Shift: US hours overlap

Eligibility Gates

• Visa sponsorship: unknown

Not Specified in JD

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

What You'll Likely Work On

• Convert client business requirements into scalable data warehouse designs
• Develop and fine‑tune ETL processes to improve data flow and system efficiency
• Collaborate with project leadership to define scope, budgets, and risk mitigation plans
• Communicate analysis results and recommendations to clients and internal stakeholders
• Manage on‑shore/client communications, lead meetings, and serve as primary client contact
• Provide training, mentorship, and ongoing education for internal teams
• Support business‑unit initiatives such as process improvement and innovation

Good Fit If You Have

• 5‑8 years of consulting experience with data warehousing or analytics
• Strong familiarity with U.S. pharmaceutical datasets
• Ability to work US business hours with 3‑4 hour overlap
• Excellent verbal and written communication for diverse audiences