Allata

Allata is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices. Allata also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance—to deliver measurable results and build lasting partnerships.

Data Manager, Snowflake

Data ScientistData ScientistFull TimeRemoteTeam 201-500H1B SponsorCompany SiteLinkedIn

Location

Texas

Posted

2 days ago

Salary

Not specified

Bachelor DegreeEnglishAirflowAWSAzureCloudGoogle Cloud PlatformMatillionPythonSQLTerraform

Job Description

• Define and evolve Snowflake platform architecture, standards, and best practices. • Translate business goals into a pragmatic technical roadmap and delivery plan. • Lead and mentor data engineers; establish quality bars, review code, and guide execution. • Manage delivery using Agile rituals; align priorities across data, analytics/BI, and application teams. • Design, build, and optimize ELT pipelines on Snowflake with an ELT-first approach (dbt preferred). • Implement modern data ingestion using tools such as Fivetran, ADF, Glue, or Matillion. • Set up orchestration and CI/CD for data using Airflow or Dagster and Git-based pipelines. • Ensure data quality, observability, monitoring, alerting, documentation, and runbooks. • Apply performance tuning and cost optimization in Snowflake, including query profiling and warehouse sizing. • Implement security and governance in Snowflake (RBAC, masking, row access policies, auditing, data sharing). • Facilitate discovery with stakeholders, clarify requirements, and communicate trade-offs and recommendations.

Job Requirements

  • Deep hands-on Snowflake experience: warehouses, databases/schemas, stages, file formats, external tables, Snowpipe, Streams and Tasks, Time Travel/Fail-safe, query performance, micro-partitions, clustering, and cost management.
  • Strong SQL and Python for data engineering use cases.
  • ELT-first development with dbt or an equivalent modeling/testing/documentation framework.
  • Experience with modern ingestion and orchestration (Fivetran, ADF, Glue, Matillion, Airflow, or Dagster).
  • Cloud experience (AWS preferred; Azure or GCP considered), including storage, IAM, networking basics, and secrets management.
  • CI/CD for data with Git-based workflows and environment promotion.
  • Familiarity with Infrastructure as Code (e.g., Terraform Snowflake provider).
  • Solid understanding of dimensional modeling and data quality practices.
  • Proven leadership with coaching, feedback, objective setting, and conflict resolution.
  • Excellent stakeholder communication; able to facilitate discovery and manage expectations.
  • Ownership mindset with proactive risk identification, prioritization, and mitigation.
  • Structured problem-solving; comfortable with ambiguity and change.

Benefits

  • Health insurance
  • Professional development opportunities

Related Categories

Related Job Pages

More Data Scientist Jobs

Data Scientist2 days ago
Full TimeRemoteTeam 11-50Since 2014H1B No Sponsor

Director of Product Analytics & Strategy at ClassWallet, a financial technology company

United States

Data Scientist, AI Native

ConsumerAffairs

Make big purchases no big deal

Data Scientist2 days ago
Full TimeRemoteTeam 201-500Since 2007H1B No Sponsor

AI-Native Data Scientist building AI solutions at ConsumerAffairs

AWSCloudPythonPyTorchScikit-LearnSQLTensorflow
United States

Senior Data Scientist, GTM Strategy & Transformation

Red River

Technology Decisions Aren't Black and White. Think Red.

Data Scientist2 days ago
Full TimeRemoteTeam 501-1,000Since 2003H1B Sponsor

You will design and deploy end-to-end automated processes for the quota and incentive lifecycle while translating technical outputs into strategic recommendations for executive leadership. Additionally, you will apply predictive modeling to evaluate sales coverage and optimize customer engagement.

United States
$123K - $203K / year

AI Native, Data Scientist

ConsumerAffairs

Make big purchases no big deal

Data Scientist2 days ago
Full TimeRemoteTeam 201-500Since 2007H1B No Sponsor

As an AI-Native Data Scientist at ConsumerAffairs, you will design and build AI-driven solutions that help us better understand consumers, improve marketplace performance, and accelerate business growth. You will partner closely with engineering, produ...

United States