Job Openings JR-137676 Data Architect Snowflake

About the job JR-137676 Data Architect Snowflake

Job (Project) Description:

We are looking for a Data Architect to join our US-client, a life-sciences/pharmaceutical commercialization services company. The role is focused on designing and implementing scalable Snowflake data models, developing and optimizing ETL pipelines, and ensuring high performance, governance, and data quality across complex environments. 

The team is also working with Snowpark, iceberg table concepts, and Snowflakes data sharing/marketplace features, so hands-on expertise with these would be highly valuable.

Locations:

  • Brazil
  • Colombia
  • Argentina
  • Peru
  • Costa Rica
  • Mexico

Requirements:

  • Bachelor's degree in computer science, information technology, or a similar field.
  • 6+ of experience in data engineering;
  • 2+ years of experience in Snowflake architecture, data modeling, and ETL processes;
  • Snowflake SnowPro certification;
  • Knowledge with Snowpark;
  • Knowledge with iceberg table concept;
  • Snowflake data sharing concept, and familiarity with Snowflake marketplace;
  • Solid Python programming;
  • Proficiency in SQL, query optimization techniques;
  • Hands-on experience implementing robust, scalable data pipelines;
  • Skills in workflow management using tools such as Argo, Oozie, or Apache Airflow
  • Familiarity with one of the cloud providers (AWS, Azure, GCP); 
  • Experience with CI/CD pipelines and DevOps practices for data engineering;
  • Solid understanding of data warehousing, data lakes, MPP data platforms, and data processing frameworks.

Will be a plus:

  • Knowledge in AI/ML;
  • Competency in the design and implementation of data enrichment between Snowflake and Salesforce with the DBT framework; 
  • Competency in the design and development of data transformation pipelines with either Mulesoft, Boomi, or Snaplogic.

Other skills:

  • English Excellent written and verbal communication skills;
  • Ability to work in a global multi-cultural multi-national company;
  • Good communication skills and persuasiveness;
  • Ability to lead conversations with both technical and business representatives;
  • Proven ability to work both independently and as a part of an international project team.

Job Responsibilities:

  • Design and implement scalable Snowflake data models to meet data ingestion and analytics needs;
  • Develop and maintain robust ETL pipelines, ensuring data consistency and integrity across multiple sources;
  • Optimize Snowflake configurations for performance enhancements, query tuning, and efficient data partition management;
  • Implement data security measures, role-based access control, and data masking within Snowflake to adhere to compliance and governance standards;
  • Automate data processing and pipeline monitoring;
  • Implement data migration processes from other data solutions;
  • Collaborate with cross-functional teams to solve complex data challenges and effectively troubleshoot Snowflake-related issues.

What We Offer:

  • Competitive salary;
  • 100% remote opportunity;
  • Paid time off (PTO), sick leave, and national holidays;
  • Travel expenses are covered when applicable;
  • Referral program;
  • Paid certification program;
  • Personal development plan (PDP);
  • Access to the language platform.

JR-137676