Senior Consultant - Snowflake Architect

13 Minutes ago • 5 Years +
Data Analysis

Job Description

This Senior Consultant role focuses on leading the architecture, design, and deployment of advanced data management solutions within the Snowflake platform. The ideal candidate will possess deep technical expertise in Snowflake, capable of building comprehensive data ecosystems from ingestion to governance. Responsibilities include integrating diverse technologies, optimizing Snowflake environments for scalability and security, and ensuring solutions meet business needs and regulatory standards. Experience with life sciences data and compliance frameworks like HIPAA/GxP is highly desirable for this impactful role.
Good To Have:
  • 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.
Must Have:
  • Lead architecture, design, and deployment of Snowflake data management solutions.
  • Design and optimize Snowflake environments for scalability, security, and cost-effectiveness.
  • Build end-to-end Snowflake data ecosystems, including ingestion, pipelines, and transformation.
  • Integrate Snowflake with third-party ETL/ELT platforms, BI tools, and cloud services.
  • Architect high-performing, scalable data models for advanced analytics.
  • Implement robust security controls and data governance frameworks for regulated industries.
  • Provide project leadership and coordinate with diverse global teams.
  • Utilize expert-level SQL and strong Python scripting abilities.
  • Manage project finances, client relationships, and team mentorship.
  • Possess an Engineering/master’s degree in Computer Science or relevant field.
  • Have 5+ years in data engineering/architecture, with 3+ years hands-on Snowflake experience.
  • Proficiency with ETL/ELT platforms (dbt, Informatica, Talend, Matillion, Fivetran).
  • Experience with orchestration tools (Airflow, Prefect, Dagster).
  • Familiarity with major cloud platforms (AWS, Azure, GCP).
  • Strong project management, people management, analytical, and problem-solving skills.
  • Knowledge of data management best practices in the pharmaceutical industry.
Perks:
  • Highly collaborative, values-driven team
  • Technical excellence
  • Analytical rigor
  • Personal growth opportunities
  • Opportunity to make an impact in AI innovation, commercialization strategies, and data-first solutions in life sciences

Add these skills to join the top 1% applicants for this job

team-management
timeline-management
communication
data-analytics
game-texts
aws
azure
python
sql
machine-learning

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.

We'll trust you to:

  • Snowflake Architecture & Optimization: Design, implement, and optimize Snowflake environments for scalability, security, and cost-effectiveness.
  • End-to-End Data Management: Lead the build-out of full Snowflake data ecosystems, including ingestion, pipelines, transformation, governance, and cataloging.
  • Integration & Ecosystem Design: Connect Snowflake to third-party tools (ETL/ELT platforms, BI tools, APIs, cloud services) and ensure seamless data flow.
  • Data Modeling & Analytics Enablement: Architect high-performing, scalable data models to support advanced analytics, reporting, and machine learning.
  • Governance & Compliance: Implement robust security controls, audit mechanisms, and data governance frameworks tailored to regulated industries (HIPAA, GxP).
  • Coordinates with diverse teams, including those globally.
  • Frequently utilizes coding to facilitate data processing and reporting.
  • Provides project leadership for team members regarding process improvements, planned approaches for client requests, or transition of new deliverables.
  • Monitors progress, manages risk and ensures key stakeholders are kept informed about progress and expected outcomes; manages project finances by maintaining financial summaries, drafts SOWs for new work, and manages client invoices.
  • Assists in supporting management, including promoting employee engagement, recruiting, training, and providing ongoing education, employee mentorship and coaching; contributes to internal initiatives as needed.
  • Fosters an innovative and inclusive team-oriented work environment.
  • Coaches and mentors junior team members on their professional development and serves as their Professional Development Manager.
  • Grows external client engagements, owning aspects of the relationship between the client and the firm.
  • These essential functions are not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required. Duties, responsibilities, and activities may change or new ones may be assigned at any time with or without notice.

You'll need to have:

  • 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.

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!

Set alerts for more jobs like Senior Consultant - Snowflake Architect
Set alerts for new jobs by beghou consulting
Set alerts for new Data Analysis jobs in India
Set alerts for new jobs in India
Set alerts for Data Analysis (Remote) jobs

Contact Us
hello@outscal.com
Made in INDIA 💛💙