Associate Consultant- Data Warehouse-298
Beghou Consulting1 year ago
Pune, IndiaMid Level
Responsibilities
- Translate business requirements into technical terms and lead the design and development of data warehouse and reporting solutions.
- Evaluate and optimize ETL processes and database performance.
- Define project scope and development approaches while conducting issue analysis and hypothesis development.
- Synthesize findings, develop recommendations, and communicate results to clients and internal teams.
- Create clear frameworks and presentations for complex concepts.
- Manage project timelines, budgets, scopes, risks, meetings, agendas, and stakeholder communications.
- Serve as a key client contact and lead data warehouse implementation projects with minimal supervision.
- Support employee engagement, recruiting, training, education, mentoring, coaching, and internal initiatives.
- Manage multiple projects simultaneously while meeting deadlines.
Requirements
- Bachelor-level engineering or relevant degree, or a master's degree, from a Tier-I or Tier-II institution with strong academic performance.
- 2-4 years of relevant consulting-industry experience.
- Deep understanding of data management best practices, data modeling, and data analytics.
- Familiarity with Tableau and Power BI, including integration with ETL outputs.
- Strong understanding of U.S. pharmaceutical datasets and their applications.
- Proficiency with Microsoft Office, SQL, Python, R, and data analysis tools.
- Strong project management, people management, problem-solving, collaboration, communication, organizational, and time-management skills.
- Ability to work in an international matrix environment and support U.S. clients during U.S. working hours with 3-4 hours of overlap.
- Awareness of current technologies related to cloud platform services, visualization, and data management.
About Beghou Consulting
Beghou Consulting provides commercialization strategy, advanced analytics, and data/technology solutions to pharmaceutical and broader life sciences companies. The privately held firm sells consulting services and deploys proprietary and third-party tools for forecasting, territory design, customer data management, and engagement analytics. Founded in 1993 and headquartered in Evanston, Illinois, it operates 10 global offices and supports clients across launch planning, sales operations, and market access.