Consultant - Data Warehousing (MDM)

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