Associate Consultant - Data Warehouse- 440

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 architecture, and lead project delivery while ensuring data quality and governance.

Role Snapshot

• Design & build data warehouse and reporting solutions
• Optimize ETL pipelines and database performance
• Translate business requirements into technical specifications
• Lead project timelines, budgets, and stakeholder communication
• Provide data governance and best‑practice guidance
• Mentor and train internal teams on data tools

Must-Have Requirements

• Engineering/Master’s Degree in Computer Science or related field
• 2-4 years consulting‑industry experience
• Deep understanding of data management best practices, data modeling, and analytics
• Proficiency in SQL, Python, and R
• Experience with Tableau and PowerBI
• Strong project management and people management abilities
• Excellent verbal and written communication
• consulting experience
• data management and ETL expertise
• Engineering/Master’s Degree in Computer Science or relevant concentration
• Master’s degree in Computer Science or related field
• 2-4 years of relevant consulting experience
• Ability to work US client hours with 3‑4 hour overlap

Nice-to-Have Signals

• Awareness of cloud platform services related to data management
• cloud platform services awareness

Work Setup

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

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
• Create dashboards and reports using Tableau or PowerBI integrated with ETL outputs
• Collaborate with project leadership to define scope, manage risks, and track progress
• Communicate findings and recommendations to clients and internal stakeholders
• Oversee multiple concurrent projects, ensuring deadlines and quality standards are met
• Support internal initiatives such as employee training, mentorship, and process improvement

Good Fit If You Have

• Enjoys translating complex business problems into clear technical solutions
• Thrives in a matrixed, international environment with US client hour overlap
• Has a collaborative mindset and strong communication skills