REQUIREMENTS:
- Total experience 3years.
- Hands on experience as a Snowflake SQL Developer.
- Strong handson expertise in SQL programming and Snowflake development.
- Experience working with structured and semistructured data (JSON Parquet Avro) in Snowflake.
- Knowledge of Snowflake features like Streams Tasks Snowpipe Time Travel and Cloning.
- Background in data modeling and warehouse design (Star/Snowflake schema).
- Strong analytical skills and attention to detail.
- Experience with pharmaceutical data (e.g. clinical trials sales patient data regulatory RWE) is preferred.
- Familiarity with data governance compliance (HIPAA GDPR CFR Part 11 and security standards.
- Handson experience with ETL/ELT tools (dbt Matillion Informatica Talend Fivetran).
- Cloud platform experience (AWS Azure GCP) and integration techniques.
- Certifications in Snowflake or cloud platforms are a plus.
- Familiarity with scripting languages (Python Shell) and BI tools (Tableau Power BI Looker).
- Excellent communication and collaboration skills.
RESPONSIBILITIES:
- Design develop and maintain performant SQL scripts stored procedures and queries in Snowflake.
- Work closely with business analysts and domain experts to translate pharmaceutical data requirements into scalable solutions.
- Build and optimize ELT pipelines using Snowflake features and external ETL tools.
- Create and maintain data models and data marts to support analytics and reporting.
- Collaborate with crossfunctional teams to troubleshoot issues and improve system efficiency.
- Implement data security governance and compliance protocols based on industry regulations.
- Tune performance for complex queries and large data sets to ensure optimal utilization.
- Develop reusable components and utilities for accelerated development.
- Support production rollouts troubleshoot incidents and drive resolution.
- Participate in knowledgesharing initiatives such as white papers technical discussions and learning sessions.
Qualifications :
Bachelors or masters degree in computer science Information Technology or a related field.
Remote Work :
No
Employment Type :
Fulltime