Consultant – DW

Beghou Consulting

. Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology.

Posted 5/28/2026full-timeBengaluru • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AirflowAWSAzureCloudETLGoogle Cloud PlatformInformaticaMatillionPythonSQL

About the role

Key responsibilities & impact

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.
Purpose of Job
This role will lead the architecture, design, and deployment of data management solutions within the Snowflake platform. The ideal candidate combines deep technical expertise in Snowflake with the ability to build data systems from the ground up, integrate diverse technologies, and ensure solutions align with both business needs and regulatory standards. Experience with life sciences data is highly desirable, given our focus on industry-specific compliance and analytics.

Requirements

What you’ll need

Engineering/master’s degree from a Tier-I/Tier-II institution/university in Computer Science or a relevant concentration, with evidence of strong academic performance.
5+ years of experience in data engineering/architecture roles.
Minimum 3+ years of **hands-on Snowflake experience**.
Expert-level SQL and strong Python scripting abilities.
Proven knowledge of query optimization, workload management, and Snowflake-specific features (virtual warehouses, clustering, micro-partitioning).
Proficiency with ETL/ELT platforms (dbt, Informatica, Talend, Matillion, Fivetran).
Experience with orchestration tools (Airflow, Prefect, Dagster).
Familiarity with at least one major cloud platform (AWS, Azure, GCP).
Strong project management and people management skills.
Advanced analytical and problem-solving abilities.
Excellent organisational, time management, and communication skills.
Knowledge of data management best practices in the pharmaceutical industry.
Ability to thrive in an international matrix environment and willingness to support US clients during US working hours with 3-4 hours of overlap.
**Preferred Qualifications**
Snowflake Certified Architect or equivalent certification.
Prior experience with **life sciences, pharmaceuticals, or healthcare data**.
Knowledge of regulatory standards and compliance frameworks (HIPAA, GxP).
Strong stakeholder engagement and leadership skills.

Benefits

Comp & perks

Coordinates with diverse teams, including those globally.
Fosters an innovative and inclusive team-oriented work environment.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SnowflakeSQLPythonquery optimizationworkload managementETLELTdata engineeringdata architecturedata management

Soft Skills

project managementpeople managementanalytical skillsproblem-solvingorganizational skillstime managementcommunication skillsstakeholder engagementleadership skillsability to thrive in a matrix environment

Certifications

Snowflake Certified Architect