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.
Key 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 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.
Desired Skills
2–5 years of hands-on experience in Master Data Management (MDM), within relevant consulting-industry experienceStrong understanding of core MDM concepts, including data stewardship, data governance, and data quality managementProven experience in Customer Mastering (HCP / HCO) & address mastering and standardization using third party toolsProficient in data profiling, applying data quality rules, data standardization, and reference data managementFamiliarity 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 solutionsHands on experience with leading MDM platforms such as Reltio, Informatica MDM, etc. is a plusStrong logical thinking and problem-solving skills, with a collaborative mindsetProficiency in Python for scripting and data manipulationStrong SQL skills for data extraction and analysis