Snowflake Data Architect

Year    MH, IN, India

Job Description

We are a fast-growing data-analytics consultancy dedicated to the

Life Sciences / Pharmaceutical commercial analytics space. Our teams build cloud-native data platforms that power sales, marketing, and patient-centric insights for leading global pharma brands--delivering compliant, high-impact solutions at enterprise scale.

Role & Responsibilities

-

Architect, build, and tune Snowflake data warehouses and ELT pipelines (SQL, Streams, Tasks, UDFs, Stored Procedures) to meet complex commercial-analytics workloads.

-

Integrate diverse pharma data sources (Veeva, Salesforce, IQVIA, Symphony, RWD, patient-services feeds) via Fivetran, ADF, or Python-based frameworks, ensuring end-to-end data quality.

-
Establish robust

data models (star, snowflake, Data Vault) optimized for sales reporting, market-share analytics, and AI/ML use-cases.

-
Drive

governance & compliance (HIPAA, GDPR, GxP) through fine-grained access controls, masking, lineage, and metadata management.

-
Lead code reviews, mentor engineers, and resolve performance bottlenecks while right-sizing compute for cost efficiency.

-
Partner with business stakeholders to translate commercial objectives into scalable data solutions and actionable insights.

Skills & Qualifications

Must-Have

-
7+ yrs data-engineering / warehousing experience, incl. 4+ yrs hands-on Snowflake design & development.

-
Expert?level SQL plus strong data-modeling (Dimensional, Data Vault) and ETL/ELT optimisation skills.

-
Proficiency in Python (or similar) for automation, API integrations, and orchestration.

-
Proven governance/security acumen within regulated industries (HIPAA, GDPR, PII).

-
Bachelor's in Computer Science, Engineering, Information Systems (Master's preferred).

-
Strong client-facing communication and problem-solving ability in fast-paced, agile environments.

Preferred

-
Direct experience with

pharma commercial datasets (sales, CRM, claims, MDM, adherence KPIs).

-
Cloud-platform depth (AWS, Azure, or GCP) and familiarity with tools such as Matillion/DBT/Airflow, Git.

-
Snowflake certifications (SnowPro Core / Advanced) plus Tableau, Power BI, or Qlik connectivity know-how.

Job Type: Full-time

Pay: ₹2,000,000.00 - ?2,500,000.00 per year

Work Location: In person

Speak with the employer


+91 9008078505

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD3798750
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    MH, IN, India
  • Education
    Not mentioned
  • Experience
    Year