Associate Consultant - Data Warehouse (506)

Beghou Consulting; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Beghou Consulting seeks an Associate Consultant to design and implement robust data warehouse architectures, ensuring efficient data integration and governance. You will provide strategic insights, lead ETL optimizations, and deliver training to internal teams to drive data-driven decision making.

You will translate business needs into technical actions, manage project scopes and timelines, and coordinate with US clients during overlapping hours.

Qualifications

• Engineering/Master’s Degree in Computer Science or related field with strong academic performance.
• 2–4 years of relevant consulting experience.
• Deep understanding of data management best practices, data modeling and data analytics.
• Familiarity with data visualization and BI tools like Tableau and Power BI, including their integration with ETL outputs.
• Strong understanding of U.S. pharmaceutical datasets and their applications.
• Logical thinking and problem-solving with collaboration ability.
• Proficiency in Microsoft Office and data analysis tools (SQL, Python, R).
• Strong project and people management skills.
• Excellent verbal and written communication, with ability to convey complex information clearly.
• Strong organizational abilities and time management; able to work in an international matrix with US overlap.
• Awareness of latest technologies related to cloud platforms, visualization, and data management.

Responsibilities

• Translate business requirements into technical terms and lead design/development of data warehouse and reporting solutions.
• Evaluate and optimize ETL processes and database performance.
• Define project scope and development approach with leadership; analyze issues and hypotheses.
• Synthesize findings, develop recommendations, and communicate results to clients and teams.
• Distill complex concepts into clear frameworks and presentations.
• Assist in managing timelines, budgets, and scopes with stakeholder communication.
• Take on DW implementation project management with onshore client communication and meetings.
• Monitor progress, manage risk, keep stakeholders informed about progress and outcomes.
• Support management including training, mentorship, and internal initiatives.
• Collaborate with leadership on business unit initiatives like process improvement or innovation.
• Manage multiple projects simultaneously to meet deadlines.

Skills

Data management

Data modeling

Data analytics

Tableau

Power BI

SQL

Python

R

Project management

People management

Communication

Education

Bachelor's or Master's in CS or related

Tools

Tableau

Power BI

SQL

Python

R

ETL tools

Job description

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.

Propose of job

As a Associate Consultant in a Data Warehousing project, you have to design and implement effective data architectures, ensuring efficient data integration and management. Additionally, you should provide strategic insights to improve decision-making processes, implement best practices for data governance, and offer training for internal teams, ultimately driving the organization towards becoming more data-driven and efficient in its operations.

We'll trust you to

• Translate business requirements into technical terms and leads project teams in the design and development of data warehouse and reporting solutions that solve business problems
• Evaluate and assist in optimizing ETL processes and database performance to enhance overall system efficiency
• Works with project leadership to define project scope and development approach for each project, including conducting issue analysis and hypothesis development.
• Synthesizes findings, develops recommendations, and communicates results to clients and internal teams.
• Distill complex concepts into easy-to-understand frameworks and presentations
• Assist in managing project timelines, budgets, and scopes while ensuring effective communication among team members and stakeholders
• Assumes project management responsibilities for DW implementation on each project with minimal supervision, including managing onshore/client communication, leading meetings, drafting agendas, managing timelines and serving as a key client contact for project discussions.
• Monitors progress, manages risk and ensures key stakeholders are kept informed about progress and expected outcomes
• Assists in supporting management, including promoting employee engagement, recruiting, training, and providing ongoing education, employee mentorship and coaching, contributes to internal initiatives as needed
• Work with leadership on any business unit related initiatives such as process improvement or innovation initiatives
• Manage multiple projects simultaneously while meeting deadlines

You'll need to have:

• Engineering/Master’s Degree from a Tier-I/Tier-II institution/university in Computer Science or relevant concentration, with evidence of 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 data visualization and business intelligence tools like Tableau and PowerBI, including their integration with ETL outputs
• Strong understanding of U.S. pharmaceutical datasets and their applications
• Logical thinking and problem-solving skills along with an ability to collaborate.
• Proficiency in Microsoft Office products & data analysis tools (e.g., SQL, Python, R)
• Strong project management and people management skills.
• Excellent verbal and written communication skills, with the ability to convey complex information clearly to diverse audiences
• Strong organizational abilities and effective time management skills
• Ability to thrive in an international matrix environment and willingness to support US clients during US working hours with 3-4 hours of overlap.
• Awareness of latest technologies related (but not limited to) to cloud platform services, visualization, data management

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!