Data Engineer - Snowflake
Remote - Mexico
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
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.
- Open Data Science Manager jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Senior Data Architect jobs
- Open Data Analytics Engineer jobs
- Open Manager, Data Engineering jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Manager jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Product Manager jobs
- Open Azure Data Engineer jobs
- Open Head of Data jobs
- Open Privacy-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open NLP-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open DevOps-related jobs
- Open Data governance-related jobs
- Open Git-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs