Consultant - Data Warehousing (MDM)- 482

Beghou; Maharashtra; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Beghou Consulting is looking for a Data Warehousing Consultant with 4–6 years of MDM experience to guide data governance and master data initiatives. You will design data models, lead project activities, and develop robust ETL architectures alongside a global team.

You'll mentor junior colleagues, engage with clients, and drive best practices in data quality, profiling, and platform choices such as Reltio or Informatica MDM. Strong Python and SQL skills are essential.

Qualifications

• 4-6 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

Responsibilities

• Owns and drives self and team effort across all phases of a project lifecycle.
• Oversees and develops Data Warehouse projects to deliver quality client deliverables on time.
• Assist in designing data models reflecting business needs and analytical objectives.
• Partner with Project lead in delivering projects and assist in project management tasks like plans and risk mitigation.
• Develop and maintain documentation for data warehouse architecture, ETL processes, and configurations.
• Participate in design reviews and code reviews to ensure quality standards in data warehousing.
• Collaborate with onshore and offshore team members for seamless communication and execution.
• Lead task planning and distribution across team members and report progress to project lead.
• Mentor junior team members and provide coaching as needed.
• Communicate with clients to manage expectations and deliverables.
• Drive continuous improvement and learning of new technologies and processes.
• Analyze requirements to design and implement complex solutions using programming languages and ETL platforms.
• Demonstrate flexibility in taking on new challenges and managing multiple tasks.
• Provide project leadership for process improvements and transitions of new deliverables.

Skills

MDM concepts

Data governance

Data quality management

Python

SQL

Project management

Stakeholder management

Customer mastering

Tools

Reltio

Informatica MDM

ETL tools

Job description

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 a 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.

We'll trust you to:

• 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 Programing languages, ETL platform
• Exhibit flexibility in undertaking new and challenging problems and demonstrate excellent task management
• Provides project leadership for team members regarding process improvements, planned approaches for client requests, or transition of new deliverables

You'll need to have:

• 4-6 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 and identifying potential inconsistencies or verification signals in application materials based on available information. 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.