Associate Consultant - Data Warehouse 483
Beghou Consulting3 months ago
Pune, IndiaMid Level
Responsibilities
- Translate business requirements into technical specifications 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, conduct issue analysis, and develop hypotheses.
- 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, stakeholders, and client communications.
- Lead data warehouse implementation projects with minimal supervision and manage multiple projects simultaneously.
- Support employee engagement, recruiting, training, education, mentorship, coaching, process improvement, and innovation initiatives.
Requirements
- Engineering or master’s degree from a Tier-I or Tier-II institution in computer science or a relevant concentration, 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 and their integration with ETL outputs.
- Strong understanding of U.S. pharmaceutical datasets and their applications.
- Proficiency in Microsoft Office products and data analysis tools such as SQL, Python, and R.
- Strong project management, people management, communication, organizational, problem-solving, 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.