Data Engineer - Snowflake

Remote - Mexico

Applications have closed

About Enroute:

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.

We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and who you are as an individual. We get involved to know our people; we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.


Job Description

Data Engineers build an infrastructure to keep data organized. We are looking for data engineers looking to build and improve new data pipelines using cloud technologies.

We are looking for a Data engineer with strong experience Snowflake, data modeling and performance tuning. The candidate should be proficient to make data model and use database features . Additionally he/she needs to understand the difference between physical data model with logical data model.

Requirements

Required Skills:

-Excellent English Skills (in spoken and written)

-Data modeling
-Strong Snowflake experience
Materialized tables
Query execution plan knowledge and interpretation
Views
Aggregate functions
UDFs
Procedures
Tasks
Understanding of pros and cons of the Snowflake
Partitions
Cluster keys
Experience with handling big amount of data > billion of rows
- Strong SQL
- Performance tuning in Snowflake
- GIT knowledge (rebase, merge, forks)

Preferred Tech:

  • Looker knowledge
  • Liqui base
  • Java/Python or other programming language


Key Responsabilities:

- Data modeling and query performance tuning on Snowflake.
- Creation of procedures, tasks, views and materialized tables that Looker will consume to create reports and dashboards.
- Act as an intermediary between the Data Delivery and Reporting teams.
- Keep up to date Liquibase to manage and apply database schema changes.


Benefits

  • Monetary compensation
  • IMSS
  • Insurance of major medical expenses
  • Minor Medical Insurance (Ammsa)
  • Life insurance
  • Funeral Expenses Insurance (PreviMed)
  • Holidays and Vacations
  • English Classes
  • Certifications
  • Educational agreements
  • Taquitos Rewards
  • Amazon Gift Card in your Birthday


Equal employment

Enroute is vowed to provide equal employment opportunities to all qualified individuals and to administer all aspects and conditions of employment without regard to the following: Race, religion, color, national origin, age, sex, sexual orientation, gender, gender identity, pregnancy, genetic information, including family medical history, physical or mental disability, military or veteran status, citizenship and/or migration status, child and spousal support withholdings, expunged criminal records, any other protected class, in accordance with applicable federal, state, and local laws.

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Tags: Data pipelines Git Looker Pipelines Python Snowflake SQL

Perks/benefits: Flex hours Insurance

Regions: Remote/Anywhere North America
Country: Mexico
Job stats:  3  0  0
Category: Engineering Jobs

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.