The Role
Leads the design and implementation of Snowflake-based data management solutions for life sciences clients. Translates business requirements into data models, technical designs, transformation logic, and implementation plans; owns technical workstreams through deployment; and delivers ingestion, transformation, warehousing, reporting, testing, and operational readiness. The Consultant troubleshoots complex data issues, advises clients, mentors junior team members, contributes to project planning, and develops scalable data engineering best practices.
Summary Generated by Built In
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!
Skills Required
- 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 modeling, and ETL/ELT
- 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 technical and business stakeholders
- Ability to independently lead a technical workstream while remaining hands-on
- Willingness to support US-based clients with US working-hour overlap
- Life sciences, pharmaceutical, or healthcare data experience
- Experience with MDM, data quality, data governance, or reporting and 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 or PySpark
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Beghou Consulting provides sales force and marketing consulting services to clients in the pharmaceutical and health care industries. We bring significant expertise in addressing sales and marketing issues and in developing advanced analytic approaches to support our clients' decision-making. We pride ourselves on our growing list of long-term clients, for whom we deliver an increasing array of services and analyses. Our clients are developing and launching innovative, high-profile products, and as such require a partner that provides similarly innovative insights and processes to support their sales force and marketing management.
