Associate Consultant, Data Warehousing

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. 

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

• 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