Associate Consultant, Data Warehousing (MDM)

Beghou; Pune District; On-site; INR 800,000 - 1,200,000; Full time

Benefits offered by this job

Collaborative work environment

Opportunities for personal growth

Access to AI tools for efficiency

Job summary

A global life sciences consulting firm in Pune is seeking an Associate Consultant for a Data Warehousing project. This role involves driving team efforts across project phases, overseeing quality deliverables, and designing data models to meet business needs. Candidates should possess 2-5 years of MDM experience and a strong understanding of data quality management and governance. Proficiency in Python and SQL is also essential. Join us to make a meaningful impact in life sciences!

Qualifications

• 2–5 years of hands-on experience in MDM, preferably in consulting.
• Strong understanding of MDM concepts including data governance.
• Experience in data standardization and quality management.

Responsibilities

• Drive team efforts across all project phases.
• Oversee Data Warehouse project quality and timelines.
• Design data models supporting analytical objectives.
• Document data warehouse architecture and configurations.
• Mentor junior team members for skill development.

Skills

Master Data Management (MDM)

Data Stewardship

Data Quality Management

Customer Mastering

Data Profiling

Data Governance

Python

SQL

Collaboration

Tools

Reltio

Informatica MDM

IQVIA

MedPro

Symphony

Job description

Overview

Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and building foundational data analytics infrastructures to leveraging artificial intelligence to improve customer insights and engagement, Beghou helps life sciences companies maximize performance across their portfolios. Beghou also deploys proprietary and third-party technology solutions to help companies forecast performance, design territories, manage customer data, organize, and report on medical and commercial data, and more. Headquartered in Evanston, Illinois, we have 10 global offices.

Our mission is to bring together analytical minds and innovative technology to help life sciences companies navigate the complexity of health care and improve patient outcomes.

Purpose of Job

As an Associate Consultant in a Data Warehousing project encompass a range of technical, analytical, and collaborative tasks essential for effective data management. You will play a pivotal role to ensure that the organization can effectively leverage its data assets for informed decision-making.

Responsibilities

• Undertake primary ownership in driving self and team member’s effort across all phases of a project lifecycle
• Oversees and develops Data Warehouse projects to ensure methodological soundness; deliver quality client deliverables within expected timeframe
• Assist in designing data models that reflect business needs and support analytical objectives
• Partner with Project lead/ Program lead in delivering projects and assist in project management responsibility like project plans and risk mitigation
• Develop and maintain comprehensive documentation for data warehouse architecture, ETL processes, and system configurations to ensure clarity and compliance
• Participate in design reviews and code reviews to ensure adherence to quality standards and best practices in data warehousing
• Foster collaboration with onshore and offshore team members to ensure seamless communication and effective task execution
• Lead task planning and task distribution across team members and ensure timely completion with high quality and report accurate status to project lead
• Mentor/coach the junior members in the team
• Oversee direct and indirect client communications based on assigned project responsibilities
• Foster a culture of continuous improvement and innovation while demonstrating the ability to learn new technologies, business domains, and project management processes
• Analyze problem statements and client requirements to design and implement complex solutions using programming languages and ETL platform
• Exhibit flexibility in undertaking new and challenging problems and demonstrate excellent task management
• Provide project leadership for team members regarding process improvements, planned approaches for client requests, or transition of new deliverables

Qualifications

• 2–5 years of hands-on experience in Master Data Management (MDM), within relevant consulting-industry experience
• Strong understanding of core MDM concepts, including data stewardship, data governance, and data quality management
• Proven experience in Customer Mastering (HCP/HCO) & address mastering and standardization using third party tools
• Proficient in data profiling, applying data quality rules, data standardization, and reference data management
• Familiarity with key pharma data sources such as IQVIA, MedPro, Symphony, etc
• Ability to translate both functional and non-functional business requirements into scalable, efficient MDM solutions
• Hands on experience with leading MDM platforms such as Reltio, Informatica MDM, etc. is a plus
• Strong logical thinking and problem-solving skills, with a collaborative mindset
• Proficiency in Python for scripting and data manipulation
• Strong SQL skills for data extraction and analysis

At Beghou Consulting, you\'ll join a highly collaborative, values-driven team where technical excellence, analytical rigor, and personal growth converge. Whether you\'re passionate about AI innovation, building commercialization strategies, or shaping the next generation of data-first solutions in life sciences, this is a place to make an impact!

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.