Associate Consultant Data Warehousing(MDM)

For over 30 years, Beghou Consulting has been a trusted adviser to life science firms. We combine our strategic consulting services with proprietary technology to develop custom, data-driven solutions that allow life sciences companies to take their commercial operations to new heights. We are dedicated to client service and offer a full suite of consulting and technology services, all rooted in advanced analytics, to enhance commercial operations and boost sales performance.

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.

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:

• 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

What you should know:

• We treat our employees with respect and appreciation, not only for what they do but who they are
• We value the many talents and abilities of our employees and promote a supportive, collaborative, and dynamic work environment that encourages both professional and personal growth
• You will have the opportunity to work with and learn from all levels in the organization, allowing everyone to work together to develop, achieve, and succeed with every project
• We have had steady growth throughout our history because the people we hire are committed not only to delivering quality results for our clients, but also to becoming leaders in sales and marketing analytics