Consultant – Data Management | Snowflake

Beghou; Bengaluru; On-site; INR 2,000,000 - 3,000,000; Full time

Job summary

Beghou Consulting seeks a seasoned Data Engineer to design and deliver Snowflake-based data management solutions for life sciences clients. You will translate business needs into scalable data models, transformation logic, and end-to-end implementations.

The role emphasizes hands-on Snowflake expertise, data engineering, and solution design, with responsibility to mentor team members and collaborate with US-based clients over overlapping hours.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Engineering, IT or related field.
• 5–7 years of data engineering, warehousing, data management or consulting experience.
• 4+ years hands-on Snowflake experience.
• Strong SQL and Python skills.
• Experience with ETL/ELT tools (dbt, Informatica, Talend, Matillion, Fivetran).
• Experience with orchestration tools (Airflow, Prefect, Dagster).
• Familiarity with AWS or Azure.

Responsibilities

• Lead the design and delivery of Snowflake-based Data Management solutions.
• Own technical workstreams end-to-end from requirements through deployment.
• Lead data ingestion, transformation, warehousing, consumption and reporting.
• Develop and review SQL and Python-based data solutions.
• Mentor junior team members and guide US-based clients with overlapping hours.

Skills

Snowflake

SQL

Python

Data warehousing

Data modeling

Education

Bachelor's degree in CS/Engineering

Tools

dbt

Airflow

Databricks

Fivetran

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.

Purpose of Job

This role will lead the design and delivery of Snowflake-based Data Management solutions for Beghou’s Life Sciences clients. The Consultant will translate business and data requirements into practical technical solutions, own technical workstreams, lead solution design and enable L1/L2 team members through implementation.The role requires a strong combination of hands-on Snowflake expertise, data engineering, solution design, problem solving and client-facing consulting skills. The candidate should be able to independently lead a workstream from requirements through implementation while partnering with project leadership and clients.

We'll trust you to:

• Lead the design and implementation of Snowflake-based Data Management solutions based on client requirements
• Translate business and data requirements into data models, technical designs, transformation logic and implementation plans
• Own technical workstreams end-to-end, from requirements and design through development, testing and deployment
• Lead delivery across data ingestion, transformation, data warehousing, consumption and reporting
• Apply strong hands-on knowledge of Snowflake, including Streams, Tasks, Snowpipe, virtual warehouses, clustering, micro-partitioning, Time Travel and data sharing
• Develop and review complex SQL and Python-based data solutions
• Make sound technical decisions around performance, scalability, data quality, maintainability and cost
• Enable and guide L1/L2 team members through clear designs, technical direction, code/design reviews and problem resolution
• Lead technical discussions with clients and internal stakeholders and clearly communicate recommendations, trade-offs and solution choices
• Lead troubleshooting of complex data and production issues and drive root-cause resolution
• Drive appropriate testing, documentation, deployment and operational readiness for solutions
• Contribute to project planning, estimation, risk management and delivery
• Develop reusable technical approaches and contribute to Data Management capabilities and best practices across projects
• Mentor junior team members and contribute to capability development and recruiting
• Work effectively with US-based clients and global teams

You’ll need to have:

• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology or a related field
• 5–7 years of experience in data engineering, data warehousing, data management or consulting
• 4+ years of strong hands-on Snowflake experience
• Strong SQL and hands-on Python skills
• Strong understanding of data warehouse architecture, dimensional modelling and ETL/ELT
• Proven experience designing, building and optimizing Snowflake solutions at scale
• Strong understanding of query optimization, workload management, clustering and micro-partitioning
• Experience with ETL/ELT tools such as dbt, Informatica, Talend, Matillion or Fivetran
• Experience with orchestration tools such as Airflow, Prefect, Dagster or equivalent
• Familiarity with AWS or Azure
• Strong analytical, problem-solving and structured thinking skills
• Excellent communication skills with the ability to work with both technical and business stakeholders
• Ability to independently lead a technical workstream and remain hands-on when required
• Willingness to support US-based clients with US working-hour overlap

Preferred Qualifications

• Life Sciences / Pharmaceutical / Healthcare data experience strongly preferred
• Experience with MDM, Data Quality, Data Governance or reporting/semantic layers
• Experience with commercial data such as customer, product, sales, claims or activity data
• Prior consulting or client-facing experience
• Snowflake certification or equivalent demonstrated expertise
• Exposure to Databricks/PySpark is a plus

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! We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.