Consultant - Data Warehouse(507)
Beghou Consulting2 months ago
Pune, IndiaSenior / Staff+
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, create recommendations, and communicate results to clients and internal teams.
- Lead data warehouse implementation projects, including meetings, agendas, timelines, client communication, and stakeholder updates.
- Manage project timelines, budgets, scopes, risks, and multiple concurrent projects.
- Support employee engagement, recruiting, training, education, mentorship, coaching, and internal business 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.
- 5–8 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 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.
Benefits
- Collaborative, values-driven environment focused on technical excellence, analytical rigor, and personal growth.
- Requires support for U.S. clients during U.S. working hours with 3–4 hours of overlap.
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.