Consultant – Data Management | Snowflake

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.